oracle 小操作

最新推荐文章于 2024-11-09 21:51:58 发布

weixin_30492601

最新推荐文章于 2024-11-09 21:51:58 发布

阅读量85

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/mycapple-zgs-111411/p/8250618.html

版权

SQL> conn sys as sysdba
已连接。
SQL> select count(*) from dba_tables;

COUNT(*)
----------
2786

SQL> select count(*) from dba_objects;

COUNT(*)
----------
72481

SQL> desc dba_objects;
名称是否为空? 类型
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------------------------------------------------------
OWNER VARCHAR2(30)
OBJECT_NAME VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_ID NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(19)
CREATED DATE
LAST_DDL_TIME DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
NAMESPACE NUMBER
EDITION_NAME VARCHAR2(30)

SQL> select object_id,object_name,object_type from dba_objects where rownum<20;

OBJECT_ID OBJECT_NAME
---------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OBJECT_TYPE
--------------------------------------
20 ICOL$
TABLE

46 I_USER1
INDEX

28 CON$
TABLE

已选择19行。

SQL> col object_name format a20;
SQL> col object_type format a10;
SQL> select object_id,object_name,object_type from dba_objects where rownum<20;

OBJECT_ID OBJECT_NAME OBJECT_TYP
---------- -------------------- ----------
20 ICOL$ TABLE
46 I_USER1 INDEX
28 CON$ TABLE
15 UNDO$ TABLE
29 C_COBJ# CLUSTER
3 I_OBJ# INDEX
25 PROXY_ROLE_DATA$ TABLE
41 I_IND1 INDEX
54 I_CDEF2 INDEX
40 I_OBJ5 INDEX
26 I_PROXY_ROLE_DATA$_1 INDEX

OBJECT_ID OBJECT_NAME OBJECT_TYP
---------- -------------------- ----------
17 FILE$ TABLE
13 UET$ TABLE
9 I_FILE#_BLOCK# INDEX
43 I_FILE1 INDEX
51 I_CON1 INDEX
38 I_OBJ3 INDEX
7 I_TS# INDEX
56 I_CDEF4 INDEX

已选择19行。

SQL> create table myobjects (object_id number,object_name varchar2(64),object_type varchar2(64))
2 partition by range(object_id)
3 (
4 partition p1 values less than (10000) ,
5 partition p2 values less than (20000),
6 partition p3 values less than (30000),
7 partition p4 values less than (40000),
8 partition p5 max values less than (100000)
9 );
partition p5 max values less than (100000)
*
第 8 行出现错误:
ORA-00926: 缺失 VALUES 关键字

SQL> edit
已写入 file afiedt.buf

1 create table myobjects (object_id number,object_name varchar2(64),object_type varchar2(64))
2 partition by range(object_id)
3 (
4 partition p1 values less than (10000) ,
5 partition p2 values less than (20000),
6 partition p3 values less than (30000),
7 partition p4 values less than (40000),
8 partition p5 values less than (100000)
9* )
SQL> /

表已创建。

SQL> select * from user_tab_partitions;

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
WRH$_SQLSTAT NO WRH$_SQLSTA_1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 3874 244 0
0 0 273 3874 07-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_WAITSTAT NO WRH$_WAITST_1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 612 5 0
0 0 31 612 07-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------

WRH$_LATCH NO WRH$_LATCH_1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 18190 118 0
0 0 46 18190 07-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_FILESTATXS NO WRH$_FILESTATXS_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_LATCH_MISSES_SUMMARY NO WRH$_LATCH__1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 1168 13 0
0 0 57 1168 07-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_DB_CACHE_ADVICE NO WRH$_DB_CAC_1492391684_0 0 1492391684, MAXVALUE 20 1

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 681 13 0
0 0 61 681 07-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_ROWCACHE_SUMMARY NO WRH$_ROWCAC_1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 1870 20 0
0 0 58 1870 07-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
WRH$_SQLSTAT NO WRH$_SQLSTAT_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_SGASTAT NO WRH$_SGASTA_1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 789 5 0
0 0 40 789 07-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------

WRH$_SYSTEM_EVENT NO WRH$_SYSTEM_1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 2505 20 0
0 0 41 2505 07-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_LATCH_CHILDREN NO WRH$_LATCH__1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 10 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_LATCH_PARENT NO WRH$_LATCH__1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 10 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_SYSTEM_EVENT NO WRH$_SYSTEM_EVEN_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_SEG_STAT NO WRH$_SEG_ST_1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 2835 50 0
0 0 113 2835 07-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
WRH$_SYSSTAT NO WRH$_SYSSTA_1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 19992 73 0
0 0 23 19992 07-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_FILESTATXS NO WRH$_FILEST_1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 211 5 0
0 0 57 211 07-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------

WRH$_PARAMETER NO WRH$_PARAME_1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 11934 65 0
0 0 37 11934 07-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_INST_CACHE_TRANSFER NO WRH$_INST_C_1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 10 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_WAITSTAT NO WRH$_WAITSTAT_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_DLM_MISC NO WRH$_DLM_MI_1492391684_0 0 1492391684, MAXVALUE 20 1

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
SYSAUX 10 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_EVENT_HISTOGRAM NO WRH$_EVENT__1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 14239 58 0
0 0 27 14239 07-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
WRH$_LATCH NO WRH$_LATCH_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_SERVICE_STAT NO WRH$_SERVIC_1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 4032 20 0
0 0 30 4032 07-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------

WRH$_ACTIVE_SESSION_HISTORY NO WRH$_ACTIVE_1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 673 28 0
0 0 265 673 07-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_TABLESPACE_STAT NO WRH$_TABLES_1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 10 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 199 5 0

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
0 0 58 199 07-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_INTERCONNECT_PINGS NO WRH$_INTERC_1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 10 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_LATCH_CHILDREN NO WRH$_LATCH_CHILD_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
SYSAUX 10 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_SERVICE_WAIT_CLASS NO WRH$_SERVIC_1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 986 13 0
0 0 44 986 07-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
WRH$_LATCH_PARENT NO WRH$_LATCH_PAREN_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2
SYSAUX 10 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_OSSTAT NO WRH$_OSSTAT_1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 510 5 0
0 0 22 510 07-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------

WRH$_SYS_TIME_MODEL NO WRH$_SYS_TI_1492391684_0 0 1492391684, MAXVALUE 20 1
SYSAUX 10 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 646 5 0
0 0 25 646 07-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

STREAMS$_APPLY_SPILL_MSGS_PART NO P0 0 0 1 1
SYSAUX 10 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
0 0 0 30-3月 -10 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_LATCH_MISSES_SUMMARY NO WRH$_LATCH_MISSE_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_DB_CACHE_ADVICE NO WRH$_DB_CACHE_AD_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_ROWCACHE_SUMMARY NO WRH$_ROWCACHE_SU_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
WRH$_SGASTAT NO WRH$_SGASTAT_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_SYSSTAT NO WRH$_SYSSTAT_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------

WRH$_PARAMETER NO WRH$_PARAMETER_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_SEG_STAT NO WRH$_SEG_STAT_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_DLM_MISC NO WRH$_DLM_MISC_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2
SYSAUX 10 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_SERVICE_STAT NO WRH$_SERVICE_STAT_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_ACTIVE_SESSION_HISTORY NO WRH$_ACTIVE_SES_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
WRH$_TABLESPACE_STAT NO WRH$_TABLESPACE_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2
SYSAUX 10 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_OSSTAT NO WRH$_OSSTAT_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------

WRH$_SYS_TIME_MODEL NO WRH$_SYS_TIME_MO_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2
SYSAUX 10 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_SERVICE_WAIT_CLASS NO WRH$_SERVICE_WAIT_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_INST_CACHE_TRANSFER NO WRH$_INST_CACHE_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2
SYSAUX 10 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_EVENT_HISTOGRAM NO WRH$_EVENT_HISTO_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
SYSAUX 1 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

WRH$_INTERCONNECT_PINGS NO WRH$_IC_PINGS_MXDB_MXSN 0 MAXVALUE, MAXVALUE 18 2
SYSAUX 10 1 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 0 0 0
0 0 0 05-1月 -18 DEFAULT DEFAULT DEFAULT YES NO NO NO YES

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
MYOBJECTS NO P1 0 10000 5 1
SYSTEM 10 40 1 255 65536 1048576 1 2147483645 2147483645 1 1 YES DISABLED
DEFAULT DEFAULT DEFAULT NO NO NO NO YES

MYOBJECTS NO P2 0 20000 5 2
SYSTEM 10 40 1 255 65536 1048576 1 2147483645 2147483645 1 1 YES DISABLED
DEFAULT DEFAULT DEFAULT NO NO NO NO YES

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------

MYOBJECTS NO P3 0 30000 5 3
SYSTEM 10 40 1 255 65536 1048576 1 2147483645 2147483645 1 1 YES DISABLED
DEFAULT DEFAULT DEFAULT NO NO NO NO YES

MYOBJECTS NO P4 0 40000 5 4
SYSTEM 10 40 1 255 65536 1048576 1 2147483645 2147483645 1 1 YES DISABLED

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
DEFAULT DEFAULT DEFAULT NO NO NO NO YES

MYOBJECTS NO P5 0 100000 6 5
SYSTEM 10 40 1 255 65536 1048576 1 2147483645 2147483645 1 1 YES DISABLED
DEFAULT DEFAULT DEFAULT NO NO NO NO YES

已选择54行。

SQL> select * from user_tab_partitions where table_name='MYOBJECTS';

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
MYOBJECTS NO P1 0 10000 5 1
SYSTEM 10 40 1 255 65536 1048576 1 2147483645 2147483645 1 1 YES DISABLED
DEFAULT DEFAULT DEFAULT NO NO NO NO YES

MYOBJECTS NO P2 0 20000 5 2
SYSTEM 10 40 1 255 65536 1048576 1 2147483645 2147483645 1 1 YES DISABLED
DEFAULT DEFAULT DEFAULT NO NO NO NO YES

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------

MYOBJECTS NO P3 0 30000 5 3
SYSTEM 10 40 1 255 65536 1048576 1 2147483645 2147483645 1 1 YES DISABLED
DEFAULT DEFAULT DEFAULT NO NO NO NO YES

MYOBJECTS NO P4 0 40000 5 4
SYSTEM 10 40 1 255 65536 1048576 1 2147483645 2147483645 1 1 YES DISABLED

TABLE_NAME COMPOS PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION
------------------------------------------------------------ ------ ------------------------------------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------
TABLESPACE_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION COMPRESS_FOR NUM_ROWS BLOCKS EMPTY_BLOCKS
------------------------------------------------------------ ---------- ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- -------------- ---------------- ------------------------ ---------- ---------- ------------
AVG_SPACE CHAIN_CNT AVG_ROW_LEN SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CAC GLOBAL USER_S IS_NES PARENT_TABLE_PARTITION INTERV SEGMEN
---------- ---------- ----------- ----------- -------------- -------------- -------------- -------------- ------ ------ ------ ------------------------------------------------------------ ------ ------
DEFAULT DEFAULT DEFAULT NO NO NO NO YES

MYOBJECTS NO P5 0 100000 6 5
SYSTEM 10 40 1 255 65536 1048576 1 2147483645 2147483645 1 1 YES DISABLED
DEFAULT DEFAULT DEFAULT NO NO NO NO YES

SQL> DESC user_tab_partitions;
名称是否为空? 类型
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------------------------------------------------------
TABLE_NAME VARCHAR2(30)
COMPOSITE VARCHAR2(3)
PARTITION_NAME VARCHAR2(30)
SUBPARTITION_COUNT NUMBER
HIGH_VALUE LONG
HIGH_VALUE_LENGTH NUMBER
PARTITION_POSITION NUMBER
TABLESPACE_NAME VARCHAR2(30)
PCT_FREE NUMBER
PCT_USED NUMBER
INI_TRANS NUMBER
MAX_TRANS NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENT NUMBER
MAX_EXTENT NUMBER
MAX_SIZE NUMBER
PCT_INCREASE NUMBER
FREELISTS NUMBER
FREELIST_GROUPS NUMBER
LOGGING VARCHAR2(7)
COMPRESSION VARCHAR2(8)
COMPRESS_FOR VARCHAR2(12)
NUM_ROWS NUMBER
BLOCKS NUMBER
EMPTY_BLOCKS NUMBER
AVG_SPACE NUMBER
CHAIN_CNT NUMBER
AVG_ROW_LEN NUMBER
SAMPLE_SIZE NUMBER
LAST_ANALYZED DATE
BUFFER_POOL VARCHAR2(7)
FLASH_CACHE VARCHAR2(7)
CELL_FLASH_CACHE VARCHAR2(7)
GLOBAL_STATS VARCHAR2(3)
USER_STATS VARCHAR2(3)
IS_NESTED VARCHAR2(3)
PARENT_TABLE_PARTITION VARCHAR2(30)
INTERVAL VARCHAR2(3)
SEGMENT_CREATED VARCHAR2(3)

SQL> SELECT TABLE_NAME,PARTITION_NAME,HIGH_VALUE FROM USER_TAB_PARTITIONS WHERE TABLE_NAME='MYOBJECTS';

TABLE_NAME PARTITION_NAME HIGH_VALUE
------------------------------------------------------------ ------------------------------------------------------------ --------------------------------------------------------------------------------
MYOBJECTS P1 10000
MYOBJECTS P2 20000
MYOBJECTS P3 30000
MYOBJECTS P4 40000
MYOBJECTS P5 100000

SQL> INSERT INTO MYOBJECTS VALUES SELECT OBJECT_ID,OBJECT_NAME,OBJECT_TYPE FROM ALL_OBJECTS;
INSERT INTO MYOBJECTS VALUES SELECT OBJECT_ID,OBJECT_NAME,OBJECT_TYPE FROM ALL_OBJECTS
*
第 1 行出现错误:
ORA-00936: 缺失表达式

SQL> INSERT INTO MYOBJECTS SELECT OBJECT_ID,OBJECT_NAME,OBJECT_TYPE FROM ALL_OBJECTS;

已创建71711行。

SQL> SELECT COUNT(*) FROM P1;
SELECT COUNT(*) FROM P1
*
第 1 行出现错误:
ORA-00942: 表或视图不存在

SQL> SELECT COUNT(*) FROM MYOBJECT PARTITON(P1);
SELECT COUNT(*) FROM MYOBJECT PARTITON(P1)
*
第 1 行出现错误:
ORA-00933: SQL 命令未正确结束

SQL> SELECT COUNT(*) FROM MYOBJECT PARTITON('P1');
SELECT COUNT(*) FROM MYOBJECT PARTITON('P1')
*
第 1 行出现错误:
ORA-00933: SQL 命令未正确结束

SQL> SELECT COUNT(*) FROM MYOBJECT PARTITION(P1);
SELECT COUNT(*) FROM MYOBJECT PARTITION(P1)
*
第 1 行出现错误:
ORA-00942: 表或视图不存在

SQL> SELECT COUNT(*) FROM MYOBJECTS PARTITION(P1);

COUNT(*)
----------
9691

SQL> SELECT COUNT(*) FROM MYOBJECTS PARTITION(P2);

COUNT(*)
----------
9788

SQL> SELECT COUNT(*) FROM MYOBJECTS PARTITION(P3);

COUNT(*)
----------
10000

SQL> SELECT COUNT(*) FROM MYOBJECTS PARTITION(P4);

COUNT(*)
----------
10000

SQL> SELECT COUNT(*) FROM MYOBJECTS PARTITION(P5);

COUNT(*)
----------
32232

SQL> SELECT COUNT(*) FROM MYOBJECTS where object_id=199;

COUNT(*)
----------
0

SQL> create index idx_myobjects on myobjects(object_id)
2 global partition by range(object_id)
3 partition p1 values less than(10000),
4 partition p2 values less than(20000),
5 partition p3 values less than(30000),
6 partition p4 values less than(maxvalue));
partition p1 values less than(10000),
*
第 3 行出现错误:
ORA-00906: 缺失左括号

SQL> edit
已写入 file afiedt.buf

1 create index idx_myobjects on myobjects(object_id)
2 global partition by range(object_id)
3 (
4 partition p1 values less than(10000),
5 partition p2 values less than(20000),
6 partition p3 values less than(30000),
7 partition p4 values less than(maxvalue)
8* )
9 /

索引已创建。

SQL> spool off

转载于:https://www.cnblogs.com/mycapple-zgs-111411/p/8250618.html