Re: Where am I in the Redo Log?

Thanks John,

This was the method (more or less) I was reduced to, until K Gopalkrishnan pointed out to me that X$KCCCP (which reminded me vaguely of the old Soviet Union -I find mnemonics helpful with the X$'s!!) tells you the info more or less directly (the column I was after is catchily named as CPODR_BNO [mnemonic="Dennis the Menace"].

After which it was a sinch to discover (more or less preciely) that an update of a person's salry in the EMP table generates thirty times more redo when performed in hot backup mode than when not. I'd never been able to quantify it before.

Regards
HJR

--

Oracle Resources : http://www.geocities.com/howardjr2000
========================================


"John Darrah" <jdarrah_at_veripost.net> wrote in message
news:d8927a385699498612f94338cf50521f.36240_at_mygate.mailgate.org...


> Howard,

>

> I imagine there is an X$ table that would show this in a more elegant way

but


> since I am not smart enough to know of such things, here is my clumsy

solution.


> add your current logfile to v$logmnr_contents via the dbms_logmnr package,

and


> run the following query:

>

> select scn,rbablk*512,

>        to_char(timestamp,'YYYY/MM/DD HH24:MI:SS')

>   from v$logmnr_contents

> /

> then execute your dml

> then rerun the query

>

>

> the difference between the two numbers should give you the amount of space

your


> dml took up on the logs.

>

> Hope this Helps,

>

> John

>

>

> "Howard J. Rogers" <howardjr_at_www.com> wrote in message

> news:3bd0bea9$1_at_news.iprimus.com.au...

>

> > Anyone know a good way of identifying whereabouts you are in a redo log?

> >

> > Put another way, I'm after measuring precisely the amount of redo

generated


> > by any given transaction, and I'd like to know how close that takes me

to


> > inducing a log switch.

> >

> > All thoughts appreciated.

> >

> > Regards

> > HJR

> > --

> > Resources for OracleT: www.geocities.com/howardjr2000

> > =========================================

>

>

>

>

> --

> Posted from d225s240.hotbank.com [63.83.225.240]

> via Mailgate.ORG Server - http://www.Mailgate.ORG