Performance Tuning - Time consuming SQL Statements
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Performance Tuning - Time consuming SQL Statements

  1. #1
    Join Date
    Nov 2005
    Posts
    3

    Performance Tuning - Time consuming SQL Statements

    Hi All
    I am working on Performance Tuning on Oracle 10g/ Solaris environment.
    I need to write a shell script that gives top 10 Time Consuming SQL Statements...... My client does not want to utilize statspack or OEM for somereasons which i dont know. I am wondering if any of you might help me out ....

    Please post your shell script here .....

    thanks in advance
    riah

  2. #2
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Write a SQL script and shell wrapper to call it. Schedule is with cron.

    If you are doing a tuning assignment for this company I think it would be a perfectly reasonable question to ask why they don't want to use Statspack. Does that mean you aren't going to be able to set session level tracing up either? Why are they trying to make your job more difficult by not letting you use the tools you need?
    Assistance is Futile...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width