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

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

Howdy,

If it is just about the frequency, you can get that by adding ARCHIVE_LAG_TARGET=900
to your spfile - this would make your system log-switch every 15 Minutes. See Oracle Doc on that if you like: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch19.htm

hth
Steffen

-- 
... Steffen Roegner, Oracle dba
-------------------------------
http://www.sroegner.de, http://www.gagabut.de