EVISWANG的博客

SQL> select sid,event,p1,p1raw from v$session_wait where event not like 'SQL*Net%'; SID EVENT P1 P1RAW ---------- ---------------------------------------------------------------- --

SQL> desc v$sqlarea; Name Null? Type ----------------------------------------- -------- ---------------------------- SQL_TEXT VARCHAR2(1000) SQL_FULLTEXT CLOB SQL_ID

V$STATISTICS_LEVEL V$STATISTICS_LEVEL displays the status of the statistics/advisories controlled by STATISTICS_LEVEL. Column Datatype Description STATISTICS_NAME VAR

后台进程

SQL> set linesize 80 SQL> desc v$latch Name Null? Type ----------------------------------------- -------- ---------------------------- ADDR RAW(8) LATCH# NUMBER LEVEL#

SQL> set long 1000 SQL> select dbms_metadata.get_ddl('TABLESPACE','PMMS_DATA') from dual; DBMS_METADATA.GET_DDL('TABLESP ----------------------------------------------------------------------------

1.当前的数据库连接数 select count(*) from v$process 查看不同用户的连接数 select username,count(username) from v$session where username is not null group by username; select username,status , count(username) from v$s

DBA_UNDO_EXTENTS DBA_UNDO_EXTENTS describes the extents comprising the segments in all undo tablespaces in the database. Note: The status of the undo space distribution reported by DBA_UNDO_E

V$ROLLSTAT V$ROLLSTAT contains rollback segment statistics. Column Datatype Description USN NUMBER Rollback segment number LATCH NUMBER La