Full Table Scans
Jaideep, July 10, 2003 - 1:58 pm UTC
Wonderful answer. I was not looking for anything more than this !
Cool
Khalid, February 07, 2004 - 11:09 am UTC
I want to now what is the sql statements that do a full table scan in the database
February 07, 2004 - 3:12 pm UTC
if you have 9i, easy. just look at v$sql_plan
if you do not, then, start thinking about all of the other things you might be missing in the older releases :)
Time Period?
John Keymer, April 16, 2019 - 7:23 am UTC
Sorry for dragging up an old thread... we have an instance which is running a huge amount of queries (COTS ERP with a lot of customisations). I suspect poor (dynamic) code is knocking other plans out of the SGA quite frequently and thought I might be able to use the above to prove this. One thing though - what time period are the stats recorded over? Is it since the instance was started? Is there anything which gives daily counts? I.e. so I can say "today we had XXX queries parsed by Oracle, of which YYY were hard parsed"? We have diagnostics and tuning pack.
Thanks
Parse Stats
John Keymer, April 17, 2019 - 7:22 am UTC
Sorry, I meant the parse stats:
select * from v$sysstat where name like '%parse count%';
This gives me counts - but over what time period are they?
April 17, 2019 - 1:13 pm UTC
They're totals - which will be since instance startup.