Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2002
    Location
    Shanghai , China
    Posts
    63

    Unanswered: Which View display the control file/redolog file size ?

    Which View display the control file size ?
    Which View display the redolog file size ?
    Oracle is an ocean . I am just a little fish

  2. #2
    Join Date
    Sep 2002
    Location
    Quebec
    Posts
    5

    Re: Which View display the control file/redolog file size ?

    Originally posted by ligang
    Which View display the control file size ?
    check manually with the OS

    Which View display the redolog file size ?
    select l.bytes,g.member from v$log l,v$logfile g
    where l.group# = g.group#

  3. #3
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    The control files are OS files, not DB files, so you have to use OS command from SQL*Plus to get this info:

    SQL> !ls -l /data/db01/oradata/db50/control*
    -rw-r----- 1 oracle dba 2998272 Sep 16 10:18 /data/db01/oradata/REMA/control01.ctl

    SQL> !ls -l /data/db01/oradata/db50/control* | awk '{ print $5 }'
    2998272


    Hope that helps,

    clio_usa
    OCP - DBA

    .
    .
    .

  4. #4
    Join Date
    Sep 2002
    Location
    ITALY
    Posts
    53

    Re: Which View display the control file/redolog file size ?

    Hi.

    The size of online redolog groups, and other information as the number of members for each thread is found in this way:
    select * from v$log;

    The name of member files partecipating in the group is found using:
    select * from v$logfile;

    Some information about the control files can be found in this v$ views:
    select * from v$controlfile;
    select * from v$controlfile_record_section;

    Why are you interested in the size of controlfiles?
    Usually is small compared with the size of the database (but leave space in the disks to let them grow if they need so).

    see you.
    Franco Ceotto
    SIPTI srl
    OnSite Services
    9i OCP DBA, Performance Engineer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •