MACHSQL is an interactive tool that performs SQL queries through the terminal screen.
...
- 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
Displays the disk usage for each table created by the user.
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
Displays information about the table created by the user.
...