Oracle常用動態視圖

標籤：oracle 動態視圖

1.關於資料庫/執行個體的動態效能檢視

 

v$database :displays information about the database from the control file.

v$instance :displays the state of the current instance(當前執行個體的狀況)

v$option ：displays oracle database options and features(資料庫的選項和特性)

         ：option must be separately licensed(選項單獨認證設定)

         ：whereas features come with the product and are enabled based on

          the product that is running(產品特性的發揮也是要產品運行才能體現)

v$parameter ：displays information about the initialization parameter that

            :are currently in effect for the session.A new session inherits

            :parameter values from the instance-wide values displayed by the

            :v$system_parameter view.

v$backup    :display the backup status of all online datafiles.(所有線上資料檔案的備份情況)

v$px_process_sysstat ：contains information about the sessions running parallel execution

                       (包含並存執行會話的資訊)

v$process ：displays information about the currently active processes(活動進程的資訊)

v$waitstat: displays block contention statistics.this table is only updated when timed

          :statistics are enabled(顯示熱塊競爭的統計，當時間統計參數啟動時，這個表只能更新）

v$system_event ：total waits for an event(事件的總等待時間)

 

2.關於磁碟檔案的視圖

v$datafile :datafile information from the control file

v$filestat :displays the number of physical reads and writes done and the total number of

         :single-block and multiblock I/Os done at file level(在檔案層級顯示物理讀寫和io資訊）

v$log    ：displays log file information from the control file

v$log_history :log history information from the control file

v$dbfile :all datafiles making up the database

v$tempfile :tempfile information

v$tempstat :file read/write statistics(檔案讀寫的統計)

v$segment_statistics ：segment-level statistics

 

3.contention競爭的視圖

v$lock :lists the locks currently held by the oracle database and outstanding requests for

       : a lock or latch (正在使用的鎖和過多的請求對鎖）

v$rollname ：lists the names of all online rollback segments(線上復原段的資訊)

v$rollstat ：contains rollback segment statistics（復原段的統計情況）

v$waitstat ：block contention statistics(塊爭用統計)

v$latch ：aggregate latch statistics (閂鎖的總和統計)

 

4.memory 的視圖

v$buffer_pool_statistics :statistics about all buffer pools available for the instance

                         :(執行個體所有可用的緩衝池的統計)

v$db_object_cache：database objects thatare cached inthe library cache(被緩衝在庫緩衝區的對象)

v$librarycache ：contains statistics about library cache performance and activity

               (庫緩衝區的效能和活動的統計資訊)

v$rowcache ：statistics for data dictionary activity(資料字典活動資訊統計)

v$sysstat：system statistics

v$sgastat :detailed information on the system global area（sga）

 

5.使用者/會話的視圖

v$lock :lists the locks currently held by the oracle database and outstanding requests for

       : a lock or latch (正在使用的鎖和過多的請求對鎖）

v$open_cursor :list cursors that each user session currently has opened and parsed,or cached

               (當前會話開啟的遊標列表)

v$process ：displays information about the currently active processes(活動進程的資訊)

v$transaction ：lists the active transaction in the system (列出系統活動的事物)

v$px_sesstat ：parallel execution(px),contains information about the sessions running

              (正在執行會話的並存執行情況統計)

v$px_session ：parallel execution(px),contains information about the sessions running

v$sesstat ：user session statistics

v$session_event :on waits for an event by a session(會話等待事件)

v$sort_usage ：在11g好像就沒有了

v$sort_segment:displays information about every sort segment in given instance

               顯示執行個體中給出的每個復原段的資訊。

v$session_wait ：current or last wait for each session(當前或上次的等待資訊)

v$session

v$session_object_cache ：object cache statistics for the current user session on the local 

                       :server(instance)

本文出自 “閑雲野鶴” 部落格，請務必保留此出處http://228110.blog.51cto.com/218110/1589766

Oracle常用動態視圖