Re: curious

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 5 May 2005 13:49:56 +0000 (UTC)
Message-ID: <d5d8a4$51t$1@nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com>

The script uses Steve's own layer of x$ objects, which you have to create from the sys account.

There is a 'pre0-installation' script to run before you use any of his scripts, but in the short term, change:

sys.x_$kcccp to sys.x$kcccp
sys.x_$kccle to sys.x$kccle

and run from the SYS account to see that the method is still valid.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated April 5th 2005






"Koki Sarmiento" <kokisarmiento_at_yahoo.com> wrote in message 
news:1114887741.894419.229180_at_o13g2000cwo.googlegroups.com...


>> You'll find a script on Steve Adam site:

>> http://www.ixora.com.au/scripts/redo_log.htm#log_file_usage

>

> Won't work on Oracle 9iR2.

>

> Does anyone know a way to monitor the usage of the current Online Redo

> Log.

> Oracle version 9.2.0.1

>

> Regards,

> Koki

>

Received on Thu May 05 2005 - 08:49:56 CDT