列出ALTIBASE所有性能试图-SQL语句
iSQL> select * from v$tab;
TABLE NAME TYPE
---------------------------------------------
V$ALLCOLUMN PERFORMANCE VIEW
V$ARCHIVE PERFORMANCE VIEW
V$BUFFPAGEINFO PERFORMANCE VIEW
V$BUFFPOOL_STAT PERFORMANCE VIEW
V$CATALOG PERFORMANCE VIEW
V$DATABASE PERFORMANCE VIEW
V$DATAFILES PERFORMANCE VIEW
V$DB_FREEPAGELISTS PERFORMANCE VIEW
V$DISKGC PERFORMANCE VIEW
V$DISKTBL_INFO PERFORMANCE VIEW
V$FLUSHINFO PERFORMANCE VIEW
V$INDEX PERFORMANCE VIEW
V$INSTANCE PERFORMANCE VIEW
V$LATCH PERFORMANCE VIEW
V$LFG PERFORMANCE VIEW
V$LOCK PERFORMANCE VIEW
V$LOCK_STATEMENT PERFORMANCE VIEW
V$LOCK_WAIT PERFORMANCE VIEW
V$LOG PERFORMANCE VIEW
V$MEMGC PERFORMANCE VIEW
V$MEMSTAT PERFORMANCE VIEW
V$MEMTBL_INFO PERFORMANCE VIEW
V$MUTEX PERFORMANCE VIEW
V$PLANTEXT PERFORMANCE VIEW
V$PROCTEXT PERFORMANCE VIEW
V$PROPERTY PERFORMANCE VIEW
V$REPEXEC PERFORMANCE VIEW
V$REPGAP PERFORMANCE VIEW
V$REPRECEIVER PERFORMANCE VIEW
V$REPRECEIVER_TRANSTBL PERFORMANCE VIEW
V$REPSENDER PERFORMANCE VIEW
V$REPSENDER_TRANSTBL PERFORMANCE VIEW
V$REPSYNC PERFORMANCE VIEW
V$SEGMENT PERFORMANCE VIEW
V$SEQ PERFORMANCE VIEW
V$SERVICE_THREAD PERFORMANCE VIEW
V$SESSION PERFORMANCE VIEW
V$SESSIONMGR PERFORMANCE VIEW
V$SESSTAT PERFORMANCE VIEW
V$SQLTEXT PERFORMANCE VIEW
V$STABLE_MEM_DATAFILES PERFORMANCE VIEW
V$STATEMENT PERFORMANCE VIEW
V$STATNAME PERFORMANCE VIEW
V$SYSSTAT PERFORMANCE VIEW
V$TABLE PERFORMANCE VIEW
V$TABLESPACES PERFORMANCE VIEW
V$TRACELOG PERFORMANCE VIEW
V$TRANSACTION PERFORMANCE VIEW
V$TRANSACTION_MGR PERFORMANCE VIEW
V$UNDO_BUFF_STAT PERFORMANCE VIEW
V$VERSION PERFORMANCE VIEW
51 rows selected.
|