【導(dǎo)讀】SELECT,FROMv$accessa,ORDERBY;SELECTNVL(,'(oracle)')ASusername,#,TO_CHAR(,'DD-MON-YYYYHH24:MI:SS')ASlogon_time. FROMv$sessions,AND='ACTIVE'ORDERBY,;SELECTSum(Decode(,'consistentgets',,0))"ConsistentGets",Sum(Decode(,'dbblockgets',,0))"DBBlockGets",Sum(Decode(,'physicalreads',,0))"PhysicalReads",Round(((Sum(Decode(,'consistentgets',,0))+. FROMv$sysstata;v_stackVARCHAR2(2021);v_stack:=;(v_stack);END;

　　

【正文】 onitoring FROM v$object_usage WHERE table_name = UPPER(39。amp。139。) AND index_name = DECODE(UPPER(39。amp。239。), 39。ALL39。, index_name, UPPER(39。amp。239。))。 28. 顯示指定索引或全部索引的分區(qū)信息 File Name : Author : DR Timothy S Hall Description : Displays partition information for the specified index, or all indexes. Requirements : Access to the DBA views. Call Syntax : @index_patitions (index_name or all) (schemaname) Last Modified: 15/07/2021 SET LINESIZE 500 SET PAGESIZE 1000 SET FEEDBACK OFF SET VERIFY OFF SELECT , , , , , , FROM dba_ind_partitions a WHERE = Decode(Upper(39。amp。amp。139。),39。ALL39。,Upper(39。amp。amp。139。)) AND = Upper(39。amp。amp。239。) ORDER BY , / PROMPT SET PAGESIZE 14 SET FEEDBACK ON 29. 顯示索引的使用度 File Name : Author : DR Timothy S Hall Description : Shows the usage for the specified table indexes. Call Syntax : @index_usage (tablename) (indexname or all) Last Modified: 04/02/2021 SET VERIFY OFF SET LINESIZE 200 SELECT table_name, index_name, used, start_monitoring, end_monitoring FROM v$object_usage WHERE table_name = UPPER(39。amp。139。) AND index_name = DECODE(UPPER(39。amp。239。), 39。ALL39。, index_name, UPPER(39。amp。239。))。 30. 查詢所有無效對象 File Name : Author : DR Timothy S Hall Description : Lists all invalid objects in the database. Call Syntax : @invalid_objects Requirements : Access to the DBA views. Last Modified: 18/12/2021 COLUMN object_name FORMAT A30 SELECT owner, object_type, object_name, status FROM dba_objects WHERE status = 39。INVALID39。 ORDER BY owner, object_type, object_name。 31. 顯示所有計劃任務(wù)信息 File Name : Author : DR Timothy S Hall Description : Displays information about all scheduled jobs. Requirements : Access to the DBA views. Call Syntax : @jobs Last Modified: 15/07/2021 SET LINESIZE 500 SET PAGESIZE 1000 SET VERIFY OFF SELECT Job, Substr(,1,15) Log User, Substr(,1,15) Priv User, Substr(,1,15) Schema User, Substr(To_Char(,39。DDMonYYYY HH24:MI:SS39。),1,20) Last Date, Substr(To_Char(,39。DDMonYYYY HH24:MI:SS39。),1,20) This Date, Substr(To_Char(,39。DDMonYYYY HH24:MI:SS39。),1,20) Next Date, Total Time, Broken, Interval, Failures, What, NLS Env, Misc Env FROM dba_jobs a。 SET PAGESIZE 14 SET VERIFY ON 32. 顯示在運行計劃任務(wù)信息 File Name : Author : DR Timothy S Hall Description : Displays information about all jobs currently running. Requirements : Access to the DBA views. Call Syntax : @jobs_running Last Modified: 15/07/2021 SET LINESIZE 500 SET PAGESIZE 1000 SET VERIFY OFF SELECT Job, , Failures, Substr(To_Char(,39。DDMonYYYY HH24:MI:SS39。),1,20) Last Date, Substr(To_Char(,39。DDMonYYYY HH24:MI:SS39。),1,20) This Date FROM dba_jobs_running a。 SET PAGESIZE 14 SET VERIFY ON 33. 顯 示 latch命中率信息 File Name : Author : DR Timothy S Hall Description : Displays current latch hit ratios. Requirements : Access to the V$ views. Call Syntax : @latch_hit_ratios Last Modified: 15JUL2021 SET LINESIZE 200 COLUMN latch_hit_ratio FORMAT SELECT , , , ((1 ( / )) * 100) AS latch_hit_ratio FROM v$latch l WHERE != 0 UNION SELECT , , , 100 AS latch_hit_ratio FROM v$latch l WHERE = 0 ORDER BY 4 DESC。 34. 顯示當(dāng)前鎖定 latch的使用進(jìn)程 File Name : Author : DR Timothy S Hall Description : Displays information about all current latch holders. Requirements : Access to the V$ views. Call Syntax : @latch_holders Last Modified: 15JUL2021 SET LINESIZE 200 SELECT Latch Name, PID, SID, Gets (Wait), Misses (Wait), Sleeps (Wait), Gets (No Wait), Misses (Wait) FROM v$latch l, v$latchholder lh WHERE = ORDER BY 。 35. 顯示當(dāng)前所有的 latch詳細(xì)信息 File Name : Author : DR Timothy S Hall Description : Displays information about all current latches. Requirements : Access to the V$ views. Call Syntax : @latches Last Modified: 15JUL2021