SELECT CONVERT(DESCRIPTION, 'WE8ISO8859P1', 'UTF8') FROM TABLE_NAME;
TAB, ALL_TABLES, USER_TABLES
SELECT SEGMENT_NAME, BYTES FROM USER_SEGMENTS WHERE SEGMENT_TYPE = 'TABLE';
USER_USERS, USER_ROLE_PRIVS, SESSION_PRIVS;
ALL_INDEXES, USER_INDEXES
V$SESSION
最大连接数:SELECT VALUE FROM V$PARAMETER WHERE NAME = 'PROCESSES';
当前连接数:SELECT COUNT(1) FROM V$PROCESS;
表空间:SELECT T.TABLESPACE_NAME, ROUND(SUM(BYTES/(1024*1024)),0) TS_SIZE FROM DBA_TABLESPACES T, DBA_DATA_FILES D WHERE T.TABLESPACE_NAME = D.TABLESPACE_NAME GROUP BY T.TABLESPACE_NAME;
文件大小:SELECT TABLESPACE_NAME, FILE_ID, FILE_NAME, ROUND(BYTES/(1024*1024),0) TOTAL_SPACE FROM DBA_DATA_FILES ORDER BY TABLESPACE_NAME;