control file growing
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: control file growing

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    245
    could anyone give me all possible reasons to make control file growing.

    I have a snapshot instance (only one schema being snapshot) and only activity is user query the data and snapshot refresh job.
    I realized the control file is growing slowly, why?
    the db structure never change, no backup, archilve log off, how is possible insert more data into control file?

    any input will be helpful, thanks

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Check related docs on Metalink. It may have something to do with the init parameter: CONTROLFILE_RECORD_KEEP_TIME

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    See there are many reasons for control file growing.Though u dont have any structural changes or backup or archived logs Oracle updates the controlfile and the database files with the checkpoint (SCN).
    Also when there are log switches Oracle updates the controlfile with the log sequence number.
    In order to trim ur controlfile....change the init.ora parameter CONTROL_FILE_REUSE_TIME=3.by default the parameter is set to 7 days.If u keep the no of days to less than Oracle will keep the information for 3 days and then overwrite it.
    In case of any doubts please be free to write to me at rohitsn@altavista.com

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com

  4. #4
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    See there are many reasons for control file growing.Though u dont have any structural changes or backup or archived logs Oracle updates the controlfile and the database files with the checkpoint (SCN).
    Also when there are log switches Oracle updates the controlfile with the log sequence number.
    In order to trim ur controlfile....change the init.ora parameter CONTROLFILE_RECORD_KEEP_TIME=3.by default the parameter is set to 7 days.If u keep the no of days to less than Oracle will keep the information for 3 days and then overwrite it.
    In case of any doubts please be free to write to me at rohitsn@altavista.com

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com

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