Job Seekers   Employers

dbapool: Authors | Submissions | Contact Us

Forgot password? | Sign up

Home

Discussion Forum

Articles

Interview Questions

FAQs

Scripts

Rewards

Analyzer

White Papers

Blog

Certification

Downloads

Tools

Frequently Asked Questions Go Back to FAQ list How can I get the largest amount of logical reads by any query? By:- dbapool Editor  1 Person(s) found this faq useful. You can use the following statement to find the largest amount of logical reads by any query. This will search those queries where logical reads are grater then 10,000. According to your system, you can set it to higher. select disk_reads, sql_text from v$sqlarea where disk_reads >10000 order by disk_reads desc ; Did you find this FAQ helpful? Yes: No: Name: Email: Comments: Go Back to FAQ list

About Us

Advertise

Terms of Use

Privacy

Newsletters

Contact Us

Home   Discussion Forum   FAQs  Articles  Jobs   Newsletters  Directory  Downloads

Our Premium Sponsor