Home » RDBMS Server » Server Administration » question regarding recovery parameters
question regarding recovery parameters [message #178360] Tue, 20 June 2006 15:45 Go to next message
alanm
Messages: 284
Registered: March 2005
Senior Member
I have a system that is configured with the following parameters, it is an 8i database.

log_checkpoint_interval integer 5000000
log_checkpoint_timeout integer 0
fast_start_io_target integer 314568
fast_start_mttr_target integer 0
db_block_max_dirty_target integer 15000

the database is going to be upgraded to 9i
the parameter db_block_max_dirty_target is obsolete in 9i.
to my mind a figure of 5000000 for log check point interval is very excessive. The documentation for the db_block_max parameter just says it is obsolete in 9i yet it is used in the existing application to help smooth out excessive very high bursts of oracle writing to disk. I would appreciate peoples views on the above parameters.

regards

Alan.

Report message to a moderator

Re: question regarding recovery parameters [message #178369 is a reply to message #178360] Tue, 20 June 2006 19:02 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
I'm not sure I'm familiar enough with 8i specific params to help you, but I take it you have an overwhelmingly good reason for going from 8i to 9i rather than from 8i to 10g?

Report message to a moderator

Re: question regarding recovery parameters [message #178466 is a reply to message #178360] Wed, 21 June 2006 04:10 Go to previous message
alanm
Messages: 284
Registered: March 2005
Senior Member
the application that runs on the database has not yet been ported to 10g which is a bit of a problem.

Report message to a moderator

Previous Topic: identify the current SCN ?
Next Topic: Oracle Server License Software cost
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:21:46 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.