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

Script to find sql with high disk reads. By: Ramesh Jois Sep 06 2007 Script to find sql with high disk reads.   REM: Script to find sql with high disk reads. REM: REM:***************************************** REM: Author: Ramesh REM: Date Submitted: 6-Sep-2007 REM: REM: REM: NOTE: PLEASE TEST THIS SCRIPT BEFORE USE. REM: Author will not be responsible for any damage that may be cause by this script. REM:***************************************** SELECT disk_reads, sql_text FROM v$sqlarea WHERE disk_reads > 1000 ORDER BY disk_reads DESC;

About Us

Advertise

Terms of Use

Privacy

Newsletters

Contact Us

Home   Discussion Forum   FAQs  Articles  Jobs   Newsletters  Directory  Downloads

Our Premium Sponsor