Re: alter session set events 'immediate trace name redohdr level 10'

Hi  Linda
        Welcome to Oracle! I am aware that db2 has wealth of documentation and manuals, but you would n't find these information any where in the Oracle documentation..
Anyway , here is the info that you are looking for: Again, this is from my memory so use caution..

siz: Indicates the size of the log file in log block size. So your log file size would be 20480 * 512 =10M
seq: Log sequence # in hex
hws: heck, I don't remember this:-( Been a while looking at this..
bsz:log block size. same as 'select lebsz from x$kccle'
nab:next available block.
flg:Status of the log, like current etc. If I remember correctly, this is a bitmap to indicate various statuses.
dup: # of members in the group.

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com

"Hagedorn, Linda" <lindah_at_epocrates.com> Sent by: root_at_fatcity.com
05/30/01 03:38 PM
Please respond to ORACLE-L

       
        To:        Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc:        
        Subject:        alter session set events 'immediate trace name redohdr level 10'

Hello,
I'm looking for documentation to name and label the output from the dump of redo headers and logs.  For example, siz: 0x5000 seq: 0x00001087 hws: 0x2 bsz: 512 nab: 0x5001 flg: 0x0 dup: 2 The size parameter is what, the header size in hex?  x5000 = decimal 20480?   In the DB2 world, this kind of information is readily available and provided to licensed customers in the DB2 Diagnosis Manual.  I would think the Oracle diagnosis info should be as available as IBM's.  Yes?  A search in MetaLink for this list returned zero hits: siz seq hws bsz nab flg dup      
Any information or referral to documentation is appreciated.  Thanks, Linda.  Oracle DBA, former IBM DB2 L2.   Received on Wed May 30 2001 - 15:56:22 CDT