V$TRANSACTION contains an entry for every active transaction.
V$LOCK contains an entry for all locks held as well as locks being waited on.
V$SESSION shows us the sessions logged in.
V$MUTEX_SLEEP shows a summary of sleeps and wait time for particular mutex_type/location combination
V$MUTEX_SLEEP_HISTORY show sessions sleeping for a particular mutex_type/location combination by time while it is held by a specific holding session.
V$SESS_IO shows sessions io activity like GETS, READS or CHANGES
V$SQLTEXT shows full sql for hash. full SQL may not able available in V$SQLAREA
No comments:
Post a Comment