block dump to determine ITL count
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: block dump to determine ITL count

  1. #1
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Hi Friends,

    I am attempting to learn more about 'data block' waits in v$waitstats.

    I have read that it is possible to get block dumps which will allow me to take a look at ITL count for blocks. This will allow me to determine how many freelists required.

    Can anyone please tell me how to do this.



    I have also read that data block waits can be due to 2 sessions requiring the same block. this can be determined by the P3 parameter in v$session wait.

    Does anyone have a breakdown of the different codes in P3 and what they mean.

    I have some examples of P3 codes found on my system.

    Can anyone tell me what they mean :-

    P3
    -----
    130
    231

    Thanks

    Suresh


    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    go http://www.jlcomp.demon.co.uk J. Lewis tells you how to dump a block

    or try http://www.ixora.com.au, S. Adams also tells you how to

  3. #3
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Thanks Pando..

    Any information on P3 reason codes in v$session_wait ?
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

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