Re: Is there a pain-less method to change log file size?

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Wed, 29 Sep 2004 20:25:08 GMT
Message-ID: <415b19e4.876579674@localhost>

create new log, drop old log
repeat for X logs
alter database switch log might help.

On 29 Sep 2004 12:49:19 -0700, rhugga_at_yahoo.com (Keg) wrote:

>Can the redo logfile size be changed w/o creating the database? Our
>logs are currently set to 100M which gives us a log switch every 2
>hours or so. I would like to increase the frequency to at least 30
>minutes, maybe even 15. We are running 9.2.0.4 64-bit on Solaris 9
>64-bit.
>
>Please advise,
>rhugga

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Wed Sep 29 2004 - 15:25:08 CDT