...
- SHOW INDEX
- SHOW INDEXES
- SHOW INDEXGAP
- SHOW LSM
- SHOW LICENSE
- SHOW STATEMENTS
- SHOW STORAGE
- SHOW TABLE
- SHOW TABLES
- SHOW TABLESPACE
- SHOW TABLESPACES
- SHOW USERS
...
| Code Block |
|---|
Mach> SHOW STATEMENTS
USER_ID SESSION_ID QUERY
--------------------------------------------------------------------------------------------------------------
0 2 SELECT ID USER_ID, SESS_ID SESSION_ID, QUERY FROM V$STMT
[1] row(s) selected. |
SHOW STORAGE
사용자가 생성한 테이블 별 디스크 사용량을 출력한다.
Syntax:
| Code Block |
|---|
SHOW STORAGE |
Example:
| Code Block |
|---|
Mach> CREATE TAGDATA TABLE TAG (name varchar(20) primary key, time datetime basetime, value double summarized); Created successfully. Mach> SHOW STORAGE TABLE_NAME DATA_SIZE INDEX_SIZE TOTAL_SIZE ------------------------------------------------------------------------------------------------------------------------ _TAG_DATA_0 50335744 0 50335744 _TAG_DATA_1 50335744 0 50335744 _TAG_DATA_2 50335744 0 50335744 _TAG_DATA_3 50335744 0 50335744 _TAG_META 0 0 0 |
SHOW TABLE
사용자가 생성한 테이블의 정보를 출력한다.
...