Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find SQL which caused FULL TABLE scan

3528418Mar 13 2018 — edited Mar 13 2018

Hi Team,

Using Oracle 11g R2.

I want to generate report which should contain sql which have caused FULL Table SCAN in last 24 Hrs.

Need input on in-built Oracle table which have this information.

I found this link, but its referring to v$sqlarea, ORACLE @ Work: Find Full Table Scan Queries whereas I need queries for last 24 Hrs.

I think, I should be combination of DBA_HIST_SQLSTAT, DBA_HIST_SQL_PLAN, DBA_HIST_SQLTEXT but not able use this to develop final query.

Any input on above will be helpful.

-

Thanks

Amit
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 10 2018
Added on Mar 13 2018
#general-database-discussions, #oracle
11 comments
7,185 views