Forgot your password?    
+ Reply to Thread
Results 1 to 2 of 2

Thread: how to know the size of cf,df,rf?

  1. #1
    Oracle Administrator
    Join Date
    Apr 2012
    Posts
    53

    how to know the size of cf,df,rf?

    how to know the control file size?datafiles sizes and redolog file sizes??individually as well as groups

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Posts
    120
    Issue ls -l command on the directory where your controlfile resides.
    ============================================
    Check V$DATAFILE for datafile size
    ============================================
    select l.bytes,g.member from v$log l,v$logfile g
    where l.group# = g.group#

+ Reply to Thread

Similar Threads

  1. Finding size and automating it in CRON
    By dbaANKIT in forum OS for Oracle Administration
    Replies: 0
    Last Post: 12-26-2012, 06:02 PM
  2. How we can find out the size of database and when the database bounced last time ???
    By swapan in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 05-11-2012, 04:42 PM
  3. Calculating the UNDO SIZE and Sizing the Undo Tablespace
    By Pradeep in forum Core Database Administration and Monitoring
    Replies: 1
    Last Post: 01-09-2012, 05:02 PM
  4. Calculate Total Size of an Oracle Database
    By imran in forum Core Database Administration and Monitoring
    Replies: 3
    Last Post: 11-03-2011, 01:15 PM

Posting Permissions

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

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics