Object access info. [message #18800] |
Thu, 14 February 2002 11:01 |
Rajeeva Thambugala
Messages: 5 Registered: March 2001 Location: NJ USA
|
Junior Member |
|
|
How can I see whether a user is doing a full table scan on a given tablename whitout doing a trace on the session. Basically is there a V$ table where I can get this information.
|
|
|
Re: Object access info. [message #18801 is a reply to message #18800] |
Thu, 14 February 2002 11:31 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
run this query:
select a.sid,c.name,a.username,b.value
from v$session a,v$sesstat b,v$statname c
where a.sid=b.sid and b.statistic#=c.statistic#
and a.sid=&yoursid and c.name like 'table%'
check values of 'table scans (short tables)' and
'table scans (long tables)'
|
|
|