檢視統計資訊分析每次經歷的時間
As of Oracle Database 10g, the procedures in the package dbms_stats working at database, data
dictionary, or schema level, log information about their execution in the data dictionary. This
logging information is externalized through the data dictionary view dba_optstat_operations.
Basically, you are able to know which operations were performed, when they were started, and
how long they took. The following example, which is an excerpt taken from a production database,
shows that the procedure gather_database_stats is started every day, except on Sunday,
and takes between 10 and 17 minutes to run:
SELECT operation,target, start_time,
(end_time-start_time) DAY(1) TO SECOND(0) AS duration
FROM dba_optstat_operations
ORDER BY DURATION desc;
OPERATION TARGET START_TIME DURATION
------------------------------ ---------- ---------------------------------------- ------------
gather_schema_stats APOLLO 07-MAR-11 10.19.55.408841 PM +08:00 +0 03:19:11
gather_schema_stats VODKA 08-MAR-11 01.39.06.322315 AM +08:00 +0 00:54:06
gather_schema_stats BPM 07-MAR-11 09.54.06.545743 PM +08:00 +0 00:25:49
gather_schema_stats CAESAR 08-MAR-11 02.33.12.589664 AM +08:00 +0 00:13:16
export_schema_stats APOLLO 19-FEB-11 11.00.45.480386 PM +08:00 +0 00:00:19
export_schema_stats APOLLO 26-FEB-11 11.02.02.211903 PM +08:00 +0 00:00:13
export_schema_stats APOLLO 05-MAR-11 11.03.56.529214 PM +08:00 +0 00:00:12
export_schema_stats APOLLO 07-MAR-11 09.53.50.080197 PM +08:00 +0 00:00:11
export_schema_stats APOLLO 12-FEB-11 10.58.29.181090 PM +08:00 +0 00:00:10
export_schema_stats VODKA 07-MAR-11 09.54.02.209570 PM +08:00 +0 00:00:02
export_schema_stats BPM 07-MAR-11 09.54.01.232017 PM +08:00 +0 00:00:01
export_schema_stats CAESAR 07-MAR-11 09.54.04.475133 PM +08:00 +0 00:00:01
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22034023/viewspace-689179/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle錶的歷史統計資訊檢視Oracle
- [sqlserver] 檢視錶的統計資訊SQLServer
- Bash 指令碼實現每次登入到 Shell 時可以檢視 Linux 系統資訊指令碼Linux
- 11g新特性--檢視錶的歷史統計資訊差異
- 【統計資訊】全面檢視錶所有統計資訊SQLSQL
- Windows 檢視系統資訊及持續執行時間 - systeminfoWindows
- 檢視oracle系統的執行時間Oracle
- oracle 統計資訊檢視與收集Oracle
- PostgreSQL統計資訊的幾個重要檢視SQL
- oracle檢視和更新統計表的資訊Oracle
- 檢視錶的統計資訊SQL指令碼SQL指令碼
- win10如何檢視系統安裝的時間_win10檢視系統安裝時間的方法Win10
- Oracle 11g 建立臨時window時間視窗 收集統計資訊Oracle
- [20180322]檢視統計資訊的儲存歷史.txt
- Linux檢視系統開機時間Linux
- 如何檢視 Linux 系統安裝的時間Linux
- 分享檢視統計資訊非常好的指令碼指令碼
- 檢視oracle臨時表空間佔用率的檢視Oracle
- 物化檢視中的統計資訊導致的查詢問題分析和修復
- 檢視系統中各種等待時間佔用的資料庫時間比例資料庫
- oracle 11g 統計資訊 相關檢視Oracle
- Oracle檢視查詢慢之統計資訊收集Oracle
- Linux下如何檢視系統啟動時間和執行時間Linux
- 檢視Cookie過期時間Cookie
- Git檢視分支建立時間Git
- 檢視windows開機時間Windows
- 檢視語句執行的時間
- Linux下時間的檢視(轉)Linux
- systeminfo 檢視windows 系統持續開啟時間Windows
- 檢視歷史會話等待事件對應的session資訊會話事件Session
- 檢視歷史執行計劃
- Linux如何檢視系統/伺服器的執行時間及啟動時間?Linux伺服器
- 如何使用SQL計算寶寶每次吃奶的時間間隔(文末含PPT)SQL
- 檢視系統資源資訊
- 檢視 Linux 系統資訊Linux
- 檢視電腦的開關機時間
- 檢視/修改Linux時區和時間Linux
- Macbook如何檢視開機時間?Mac