2.136 ALL_EXPRESSION_STATISTICS
ALL_EXPRESSION_STATISTICS
provides expression usage tracking statistics for tables that are accessible to the current user.
Related Views
-
DBA_EXPRESSION_STATISTICS
provides expression usage tracking statistics for all the tables in the database. -
USER_EXPRESSION_STATISTICS
provides expression usage tracking statistics for tables owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the table |
|
|
|
Name of the table contained in the expression |
|
|
|
Expression ID of the current expression |
|
|
|
Type of snapshot for the expression:
|
|
|
|
Number of times the expression has been evaluated |
|
|
|
Optimizer fixed cost of evaluating the expression |
|
|
|
Optimizer dynamic cost of evaluating the expression |
|
|
|
Text of the expression |
|
|
|
Time this expression is first evaluated |
|
|
|
Time this expression is last evaluated |
See Also: