USER_TAB_PENDING_STATS
仕様
PROD(JASON)> select * from v$version;

BANNER
----------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
PL/SQL Release 11.1.0.7.0 - Production
CORE    11.1.0.7.0      Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production

PROD(JASON)> desc USER_TAB_PENDING_STATS;
 名前                                                                              NULL?    型
 ----------------------------------------------------------------------------------- -------- ----------------
 TABLE_NAME                                                                                   VARCHAR2(30)
 PARTITION_NAME                                                                               VARCHAR2(30)
 SUBPARTITION_NAME                                                                            VARCHAR2(30)
 NUM_ROWS                                                                                     NUMBER
 BLOCKS                                                                                       NUMBER
 AVG_ROW_LEN                                                                                  NUMBER
 SAMPLE_SIZE                                                                                  NUMBER
 LAST_ANALYZED                                                                                DATE

PROD(JASON)>
使用例
PROD(JASON)> col TABLE_NAME format a30
PROD(JASON)> col PARTITION_NAME format a20
PROD(JASON)> col SUBPARTITION_NAME format a20
PROD(JASON)> select * from user_tab_pending_stats;

TABLE_NAME                     PARTITION_NAME       SUBPARTITION_NAME      NUM_ROWS     BLOCKS AVG_ROW_LEN SAMPLE_SIZE LAST_ANA
------------------------------ -------------------- -------------------- ---------- ---------- ----------- ----------- --------
CALL_HISTORY                                                                      2         10          38           2 10-02-18
CALL_HISTORY_SYS                                                                  1          5          38           1 10-02-18
CUSTOMER_ORDERS                                                                   0          0           0           0 10-02-18
CUSTOMER_ORDER_ITEMS                                                              0          0           0           0 10-02-18
EMPLOYEE                                                                          0          0           0           0 10-02-18
T_OBJ                                                                         11978        172  91.3188345       11978 10-02-18
CALL_HISTORY                   P0                                                 0          0           0           0 10-02-18
CALL_HISTORY                   P1                                                 1          5          38           1 10-02-18
CALL_HISTORY                   SYS_P22                                            1          5          38           1 10-02-18
CALL_HISTORY_SYS               S1                                                 1          5          38           1 10-02-18
CALL_HISTORY_SYS               S2                                                 0          0           0           0 10-02-18
CALL_HISTORY_SYS               S3                                                 0          0           0           0 10-02-18
CALL_HISTORY_SYS               S4                                                 0          0           0           0 10-02-18
CALL_HISTORY_SYS               S5                                                 0          0           0           0 10-02-18
CUSTOMER_ORDERS                P_2007_JAN                                         0          0           0           0 10-02-18
CUSTOMER_ORDERS                P_BEFORE_JAN_2007                                  0          0           0           0 10-02-18
CUSTOMER_ORDER_ITEMS           P_2007_JAN                                         0          0           0           0 10-02-18
CUSTOMER_ORDER_ITEMS           P_BEFORE_JAN_2007                                  0          0           0           0 10-02-18
EMPLOYEE                       P1                                                 0          0           0           0 10-02-18
EMPLOYEE                       P2                                                 0          0           0           0 10-02-18
EMPLOYEE                       P3                                                 0          0           0           0 10-02-18

21行が選択されました。

PROD(JASON)>
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License