Online Redo Log, changes in [message #61240] |
Wed, 07 April 2004 02:11 |
Eric Langager
Messages: 38 Registered: April 2004 Location: Beijing, China
|
Member |
|
|
Greetings.... wondering if anyone knows a view that can tell me what percentage of an online redo log file has been filled. Thanks
|
|
|
Re: Online Redo Log, changes in [message #61248 is a reply to message #61240] |
Wed, 07 April 2004 21:10 |
ora9iDBA
Messages: 31 Registered: March 2003
|
Member |
|
|
select
le.leseq "Current log sequence No",
100*cp.cpodr_bno/le.lesiz "Percent Full",
cp.cpodr_bno "Current Block No",
le.lesiz "Size of Log in Blocks"
from
x$kcccp cp,
x$kccle le
where
LE.leseq =CP.cpodr_seq
and bitand(le.leflg,24)=8;
|
|
|
Re: Online Redo Log, changes in [message #61249 is a reply to message #61248] |
Wed, 07 April 2004 21:24 |
Anatol Ciolac
Messages: 113 Registered: December 2003
|
Senior Member |
|
|
I have a question to Kishor Bhalwankar: where you are finded description of x$ tables. I understand that this is views, that contain useful information but cannot find documentation about them.
|
|
|
|
Re: Online Redo Log, changes in [message #61252 is a reply to message #61250] |
Wed, 07 April 2004 22:36 |
Anatol Ciolac
Messages: 113 Registered: December 2003
|
Senior Member |
|
|
Yes, of course - they era undocumented. But i doesn't mean that knowlegde of them is restricted or inutil. I want to understand them, how they are fonctioning, what propreties are, and how possible to utilize them.
|
|
|
|
|