Table stored historic HASH_VALUE?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Table stored historic HASH_VALUE?

  1. #1
    Join Date
    Dec 2001
    Posts
    203

    Table stored historic HASH_VALUE?

    Good Afternoon,

    I got a sql_id from awr which is 8 days old. I need to know the hash value for that sql_id.

    with the help of "awrsqrpt" I could see the hash_value but would like to know is which Dictionary TABLE oracle stores that value?

    So that, hHow to get the hash_value without running awrsqrpt?


    Regards
    sumit

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    have you tried in v$sql or v$sqlarea views??

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Dec 2001
    Posts
    203
    Alright,

    I believe Oracle use DBA_HIST_SQLSTAT & DBA_HIST_SQLTEXT ... the first one has snap_id and both can be joined through sql_id

    Regards
    sumit

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Thanks for the update Sumit. Have you tried with those DBA_ views and find the hash value that you are looking for?

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

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