Purpose
The DBA_OB_TABLE_STAT_STALE_INFO view displays the number of DDL operations performed on each table since the last statistics collection, and whether the current statistics are outdated.
Note
This view is introduced since OceanBase Database V4.2.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the table. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the table. |
| PARTITION_NAME | VARCHAR2(128) | YES | The name of the partition. If the value of this column in a partitioned table is NULL, the current record is summarized at the table level. |
| SUBPARTITION_NAME | VARCHAR2(128) | YES | The name of the subpartition. If the value of this column in a subpartitioned table is NULL, the current record is summarized at the table or partition level. |
| LAST_ANALYZED_ROWS | NUMBER | YES | The number of rows when statistics were collected the last time. The value NULL indicates that no statistics have been collected. |
| LAST_ANALYZED_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | YES | The time when statistics were last collected. The value NULL indicates that no statistics have been collected. |
| INSERTS | NUMBER | NO | The number of rows inserted since statistics were last collected. |
| UPDATES | NUMBER | NO | The number of rows updated since statistics were last collected. |
| DELETES | NUMBER | NO | The number of rows deleted since statistics were last collected. |
| STALE_PERCENT | NUMBER | NO | The percentage for determining whether statistics are outdated. |
| IS_STALE | VARCHAR2(3) | NO | Indicates whether statistics are outdated. Valid values:
|