Dear All,
I would like to know as to how many full table scans were happening on my database at any point of time. How do I find out.
Regards,
K.Diwakar
Printable View
Dear All,
I would like to know as to how many full table scans were happening on my database at any point of time. How do I find out.
Regards,
K.Diwakar
Query from v$session_longops.
v$session_longops will not necessarily give you FTS count.
The best way will be to automate a process that will capture SQL statements that are running at a goven time and see their plans for FTS.
But basically, what the use of 'how many' FTS ?
The value for "table scans (short tables)" and "table scans (long tables)" relate to FTS.Code:select name, value from v$sysstat
where name like '%table scans%';
HTH
Sanjay
Quote:
Originally posted by tamilselvan
Query from v$session_longops.
Thank you verymuch sir...
K.Diwakar
Thank you sanjay..Quote:
Originally posted by SANJAY_G
The value for "table scans (short tables)" and "table scans (long tables)" relate to FTS.Code:select name, value from v$sysstat
where name like '%table scans%';
HTH
Sanjay
K.Diwakar
Sir,Quote:
Originally posted by svk
v$session_longops will not necessarily give you FTS count.
The best way will be to automate a process that will capture SQL statements that are running at a goven time and see their plans for FTS.
But basically, what the use of 'how many' FTS ?
I do agree with you but when you are given a database, at a given point of time, this could give you an idea of as to if the problem in the database is due to the full-tablescans that are consumiming the resources. This could be substantiated by the execution plans of the sql-sttements hitting the sqlarea.
Excuse me if Iam wrong..
K.Diwakar