Home » SQL & PL/SQL » SQL & PL/SQL » Object access info.
Object access info. [message #18800] Thu, 14 February 2002 11:01 Go to next message
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 Go to previous message
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)'
Previous Topic: how to get records which are not matching
Next Topic: Time dependent primary key.
Goto Forum:

Current Time: Fri Sep 24 16:18:29 CDT 2021