Re: Is there a limit of rows in V$ARCHIVED

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Thu, 25 Jan 2001 14:26:23 GMT
Message-ID: <3A70378F.4F6F6DC3@edcmail.cr.usgs.gov>

> I suppose you wouldn't like to complete the experiment -
> for use and change CONTROL_FILE_RECORD_KEEP_TIME
> to 21, and see if v$archived_log extends to about 4,500 rows,
> or sticks at 3,630. That's if your control file can grow safely,
> of course and you don't mind bouncing your database.

I have set the KEEP_TIME parameter to 21 days. Since the parameter is SYSTEM MODIFIABLE, I was able to change it without bouncing the database. I'll let you know in a couple of weeks how things turned out!!!

Thanks,
Brian Received on Thu Jan 25 2001 - 08:26:23 CST

Re: Is there a limit of rows in V$ARCHIVED_LOG