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!

SQL Query Details in AWR Report

SaggyAug 30 2012 — edited Sep 4 2012

Hi

In AWR Report i found that there are few SQL queries that have full table scans
how can we drill about this and find which table have full scan

yes with Explain plan we can do this but is there any other way in Oracle 11g
please let me know

CHeers

This post has been answered by Jonathan Lewis on Sep 3 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 2 2012

Added on Aug 30 2012

#general-database-discussions

7 comments

1,570 views