Control file Size
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Control file Size

  1. #1
    Join Date
    Aug 2001
    Location
    cuddapah
    Posts
    145

    Red face Control file Size

    !hello

    Can any on tell me how can i find the size of my CONTROLFILE .
    Is there any view to find out.
    Or I have to check by using OS command.

  2. #2
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Using OS command will help as well...

    For more info... Here
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    You may use record_size and records_total columns in v$controlfile_record_section to get the size of the controlfile. But for accurate size it is always advisable to see the size in OS.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by SANJAY_G
    You may use record_size and records_total columns in v$controlfile_record_section to get the size of the controlfile. But for accurate size it is always advisable to see the size in OS.
    Well Sanjay, IMHO those column values are in number (records) and not in bytes (size). So even if you want to calculate the controlfile size from the record_size or records_total, you cannot.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by adewri
    Well Sanjay, IMHO those column values are in number (records) and not in bytes (size).
    I think you may want to look at defination.

    V$CONTROLFILE_RECORD_SECTION
    This view displays information about the control file record sections.

    TYPE VARCHAR2(17) Identifies the type of record section: DATABASE, CKPT PROGRESS, REDO THREAD, REDO LOG, DATAFILE, FILENAME, TABLESPACE, LOG HISTORY, OFFLINE RANGE, ARCHIVED LOG, BACKUP SET, BACKUP PIECE, BACKUP DATAFILE, BACKUP REDOLOG, DATAFILE COPY, BACKUP CORRUPTION, COPY CORRUPTION, DELETED OBJECT, or PROXY COPY
    RECORD_SIZE NUMBER Record size in bytes
    RECORDS_TOTAL NUMBER Number of records allocated for the section
    RECORDS_USED NUMBER Number of records used in the section
    FIRST_INDEX NUMBER Index (position) of the first record
    LAST_INDEX NUMBER Index of the last record
    LAST_RECID NUMBER Record ID of the last record
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by abhaysk
    I think you may want to look at defination.
    Hmmm I think i learned something new today . BTW i was trying to addup those but its always different than the actual size at OS level, may be some more information is needed other that record_size to addup to the actual sie . Or may be... Im not so good in mathematics..
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  7. #7
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Yes Amar, I too tried that before but it never gives you accurate size. Looking at OS size is the best way.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  8. #8
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    V$Controlfile_Record_Section, will give you actual size used in the allocted space by OS. So, with OS perspective this is not the size as the allocated size > the sum of the (sizes*used)
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  9. #9
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by abhaysk
    V$Controlfile_Record_Section, will give you actual size used in the allocted space by OS. So, with OS perspective this is not the size as the allocated size > the sum of the (sizes*used)
    Abhay,
    FRom your previous post
    RECORDS_TOTAL NUMBER Number of records allocated for the section
    I was using the no of records allocated and record size. But it always comes lesser that the actual cf size.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  10. #10
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by SANJAY_G
    Abhay,
    I was using the no of records allocated and record size. But it always comes lesser that the actual cf size.
    Yes sanjay, this is the reason why i didnt post that v$controlfile_record_section can be used as alternative to OS command.

    Have to dig up some docs to see, if there are any other TYPE's which get recorded in Control File apart from listed types.

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

Posting Permissions

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


Click Here to Expand Forum to Full Width