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" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 05/30/01 03:38 PM
|
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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.