Re: Need A real GURU. Big Quest

In article <1993Apr15.210029.2812_at_gwl.com>, jgol_at_gwl.com (Jon Goldberg) writes:
> Ok,
>
> The twenty cent question is:
>
> In version 6.0.3X is there a way to get the size of redo log via
> SQL? We have found that we can get the sizes via dumping the control
> file. I know of two hidden tables in Oracle x$kxxxxx are there any
> others which would contain that information?

If I am not mistaken, all that Oracle RDBMS V6.0.3x does is to store the names of the REDOLOGS in the V$LOGFILE view or sys.V_$LOGFILE view.

If you are really keen on finding the size of the redolog, I would suggest the following procedure (Sorry I have not tried it out but have seen it done).

1. Run SQL*Plus to extract the names of the redolog into a spool file
2. Run your favourite UNIX utility (I know your site uses UNIX) to extract just the name of the redofile and run it thru du or ls.
3. To get the sum , use awk, nawk or expr

Tony Jambu

-- 
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Invest Mgmt,Aust (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu_at_cmutual.com.au
 \_______/                   |PHONE:  +61-3-6418448       FAX:  +61-3-6076198