| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: alter session set events 'immediate trace name redohdr level
Hi
Riyaj,
<FONT face=Arial color=#0000ff
size=2>
<SPAN
class=349122721-30052001>Thank you! It's very nice to be here among
such kind and knowledgeable people.
<SPAN
class=349122721-30052001>
<SPAN
class=349122721-30052001>I appreciate the definitions. I'll write again as
I move through the log maps, as I'm sure other questions will arise.
<SPAN
class=349122721-30052001>
<FONT face=Arial color=#0000ff
size=2>Regards, Linda
<FONT face="Times New Roman"
size=2>-----Original Message-----From: Riyaj_Shamsudeen_at_i2.com
[mailto:Riyaj_Shamsudeen_at_i2.com]Sent: Wednesday, May 30, 2001 3:07
PMTo: Multiple recipients of list ORACLE-LSubject: 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' <FONT face=sans-serif
size=2>nab:next available block. <FONT face=sans-serif
size=2>flg:Status of the log, like current etc. If I remember correctly, this
is a bitmap to indicate various statuses. <FONT face=sans-serif
size=2>dup: # of members in the group. <FONT face=sans-serif
size=2>ThanksRiyaj "Re-yas" ShamsudeenCertified Oracle DBAi2
technologies www.i2.com
"Hagedorn, Linda"
<lindah_at_epocrates.com> <FONT face=sans-serif
size=1>Sent by: root_at_fatcity.com
05/30/01 03:38 PM <FONT
face=sans-serif size=1>Please respond to ORACLE-L
<FONT
face=sans-serif size=1> To:
Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com> <FONT face=sans-serif
size=1> cc:
Subject: alter session set events
'immediate trace name redohdr level
10'<FONT face="Courier New"
 |
 |