oracle怎么解锁视图,oracle 锁相关视图

View Description

V$LOCK

Lists the locks currently held by Oracle Database and outstanding

requests for a lock or latch

DBA_BLOCKERS

Displays a session if it is holding a lock on an object for which

another session is waiting

DBA_WAITERS

Displays a session if it is waiting for a locked object

DBA_DDL_LOCKS

Lists all DDL locks held in the database and all outstanding

requests for a DDL lock

DBA_DML_LOCKS

Lists all DML locks held in the database and all outstanding

requests for a DML lock

DBA_LOCK

Lists all locks or latches held in the database and all outstanding

requests for a lock or latch

DBA_LOCK_INTERNAL

Displays a row for each lock or latch that is being held, and one

row for each outstanding request for a lock or latch

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16147313/viewspace-718719/，如需转载，请注明出处，否则将追究法律责任。