Friday, November 28, 2008

Relationship of some dynamic view

v$session.paddr=v$process.addr
v$session.taddr=v$transaction.addr
v$session.lockwait=v$lock.kaddr
v$session.sql_id,prev_sql_id=v$sql/v$sqltext.sql_id
v$session.sid=v$sess_io.sid
v$session.sid=v$sesstat

I should make a diagram about them later.
With these dynamic view, we know what's going on at instance.

No comments: