Statspack in 10g to get cost of Top SQL
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Statspack in 10g to get cost of Top SQL

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Statspack in 10g to get cost of Top SQL

    I'm using statspack in 10g to get execution plan information (cost, rows, etc.) using 'old hash value' for Top SQL identified in Instance Report.

    However, I'm not getting the information required from the shared pool during the snapshot period.

    I'm using the scripts provided in $ORACLE_HOME/rdbms/admin. spreport.sql for instance report to identify 'old hash value' and sprepsql.sql to get more detailed information for the SQL.

    Am I missing anything here?

    How can I get the cost of these Top SQL using statspack in 10g?

    Thanks in advance.

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    You are not getting the information from the shared pool because the sql has been aged out.

    regards
    Hrishy

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    You are not getting the information from the shared pool because the sql has been aged out.

    when you supply the old hash value to sprepsql.sql you will get the required cost if you have run the snapshot at level 6.

    regards
    Hrishy

    regards
    Hrishy

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