Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Usenet ->
c.d.o.server ->
How To identify SQL command performance from V$ table
How To identify SQL command performance from V$ table
Dear Sir:
I have some question about Oracle dynamic performance view :
- I can identify session performance (CPU usage) from v$session,
V$sesstat,
And I only can get disk reads, buffer gets indices of sql command, but I
can not
get any CPU performance data of sql command from V$sql, v$sqlarea,
v$sqltext..
so, would you please tell me how can I get cpu usage performance data
for
sql command from v$ table, not from trace file.
- did object will still in v$db_object_cache when it is age
out library cache
- how can I get object dependency relationship from V$session, v$sql,
v$object_dependency because there is not relation key of
v$object_dependency
with v$session and v$sql
Thanks a lot!
Roger Li
Received on Mon May 03 1999 - 21:51:27 CDT
Original text of this message