ORACLE建庫過程中自動生成的跟鎖相關的VIEW
之前一直沒有注意過,而且都是使用現成的文件來手工建庫,今天才發現我們的手冊沒有執行catblock.sql這個指令碼,所以就沒有建立這些檢視。這些檢視不是必須的,但是有了這些檢視可能會使用起來方便點。
ORACLE自動建立瞭如下幾個檢視:
DBA_KGLLOCK
DBA_LOCK
DBA_LOCK_INTERNAL
DBA_DML_LOCKS
DBA_DDL_LOCKS
DBA_WAITERS
DBA_BLOCKERS
他們各自的含義其實只要看catblock.sql指令碼中的註釋就可以了,這裡只是把註釋搬過來,記錄一下。
[@more@]DBA_KGLLOCK:
/* this is an auxiliary view containing the KGL locks and pins */
DBA_LOCK:
/*
* DBA_LOCK has a row for each lock that is being held, and
* one row for each outstanding request for a lock or latch.
* The columns of DBA_LOCK are:
* session_id - session holding or acquiring the lock
* type - type of lock
* mode_held - mode the lock is currently held in by the session
* mode_requested - mode that the lock is being requested in by the process
* lock_id1 - type specific identifier of the lock
* lock_id2 - type specific identifier of the lock
* last_convert - time (in seconds) since last convert completed
* blocking_others - is this lock blocking other locks
*/
DBA_LOCK_INTERNAL:
/*
* DBA_LOCK_INTERNAL has a row for each lock or latch that is being held, and
* one row for each outstanding request for a lock or latch.
* The columns of DBA_LOCK_INTERNAL are:
* session_id - session holding or acquiring the lock
* type - type of lock (DDL, LATCH, etc.)
* mode_held - mode the lock is currently held in by the session
* mode_requested - mode that the lock is being requested in by the process
* lock_id1 - type specific identifier of the lock
* lock_id2 - type specific identifier of the lock
*
* NOTE: this view can be very, very slow depending on the size of your
* shared pool area and database activity.
*/
DBA_DML_LOCKS:
/*
* DBA_DML_LOCKS has a row for each DML lock that is being held, and
* one row for each outstanding request for a DML lock. It is subset
* of DBA_LOCKS
*/
DBA_DDL_LOCKS:
/*
* DBA_DDL_LOCKS has a row for each DDL lock that is being held, and
* one row for each outstanding request for a DDL lock. It is subset
* of DBA_LOCKS
*/
DBA_WAITERS:
/*
* Show all the sessions waiting for locks and the session that holds the
* lock.
*/
DBA_BLOCKERS:
/*
* Show all the sessions that have someone waiting on a lock they hold, but
* that are not themselves waiting on a lock.
*/
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25016/viewspace-1004706/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle11g 自動化建庫及調整相關引數Oracle
- 透過oracle的指令碼研究其建庫過程Oracle指令碼
- 通過oracle的指令碼研究其建庫過程Oracle指令碼
- oracle資料庫的關閉過程Oracle資料庫
- oracle建庫過程詳解Oracle
- Oracle 10g SGA 相關的VIEWOracle 10gView
- oracle資料庫的啟動與關閉過程詳解Oracle資料庫
- ORACLE建庫過程與操作(轉)Oracle
- Linux 中的靜態庫和動態庫簡介及生成過程示例Linux
- 手動建庫過程錯誤
- C#連線Oracle資料庫,通過EF自動生成與資料庫表相關的實體類C#Oracle資料庫
- Oracle 資料庫例項啟動關閉過程Oracle資料庫
- v$asm 相關的viewASMView
- 自動生成對錶進行插入和更新的儲存過程的儲存過程 (轉)儲存過程
- oracle自動生成編譯所有函式、儲存過程、觸發器的語句Oracle編譯函式儲存過程觸發器
- MySQL中鎖的相關問題DTQUMySql
- View 的繪製過程View
- Oracle的啟動過程Oracle
- Django中的ORM如何通過資料庫中的表格資訊自動化生成Model 模型類?DjangoORM資料庫模型
- 模擬積體電路設計系列部落格——8.1.3 鎖相環的鎖相過程
- ORACLE 死鎖分析過程Oracle
- 淺談移動端 View 的顯示過程View
- Oracle資料庫啟動過程Oracle資料庫
- faster rcnn中anchor的生成過程理解ASTCNN
- 簡單瞭解 MySQL 中相關的鎖MySql
- 檢視oracle鎖相關資訊Oracle
- linux 跟oracle相關的系統核心引數?LinuxOracle
- Oracle基礎結構之手工建庫相關Oracle
- Android中父View和子view的點選事件的執行過程AndroidView事件
- 基於儲存過程的百萬級測試資料自動生成儲存過程
- oracle中於資料庫相關的常用命令????Oracle資料庫
- Android中View的測量和佈局過程AndroidView
- Flutter中的自定義View的基本流程和相關知識FlutterView
- Oracle自動新增資料檔案過程Oracle
- Dataguard (Standby) 相關的檢視(View)View
- 簡單介紹Oracle 19c RAC 手工建庫的過程Oracle
- 手工建庫完成過程
- Android View滑動相關的基礎知識點AndroidView