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_LEVELV$STATISTICS_LEVEL displays the status of the statistics/advisories controlled by STATISTICS_LEVEL.ColumnDatatypeDescriptionSTATISTICS_NAMEVAR

后台进程

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

SQL> set long 1000SQL> 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_EXTENTSDBA_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$ROLLSTATV$ROLLSTAT contains rollback segment statistics.ColumnDatatypeDescriptionUSNNUMBERRollback segment numberLATCHNUMBERLa