常用动态性能表(有书签)

h051202020

571

88页

1次

2019-12-10

5墨值下载

C (V$)

C.1

Oracle SYS

CATALOG.SQL CATALOG.SQL

C.1.1 V$

V_$ V$

V$ V_$

Oracle Trace Oracle Trace

C.1.2 GV$

Oracle GV$ Global V$ V$

V$ V$CACHE_LOCK V$LOCK_ACTIVITY V$LOCKS_WITH_COLLISIONS

V$ROLLNAME GV$ GV$

V$ V$ GV$ INST_ID

INST_ID V$ INST_ID

SELECT * FROM GV$LOCK WHERE INST_ID = 2 OR INST_ID = 5

2 5 V$

GV$ OPS_ADMIN_GROUP

GV$

z PARALLEL_MAX_SERVERS

z OPS_ADMIN_GROUP

C.1.2

SYS SYSDBA ROLE

C.2

1 V$ACCESS

SID NUMBER

OWNER VARCHAR2(64)

OBJECT VARCHAR2(1000)

TYPE VARCHAR2(12 )

2 V$ACTIVE_INSTANCES

INST_NUMBER NUMBER

INST_NAME VARCHAR2(60)

3 V$AQ

QID NUMBER

WAITING NUMBER WAITING

READY NUMBER READY

EXPIRED NUMBER EXPIRED

TOTAL_WAIT NUMBER READY

AVERAGE_WAIT NUMBER READY

4 V$ARCHIVE

V$LOG Oracle V$LOG V$LOG

GROUP# NUMBER

THREAD# NUMBER

SEQUENCE# NUMBER

CURRENT# VARCHAR2(3)

FIRST_CHANGE# NUMBER SCN

5 V$ARCHIVE_DEST

DEST_ID NUMBER ID(1-5)

STATUS VARCHAR2(9) VAILID

of 88

5墨值下载

oracle 优化性能优化

关注

评论