Re: need your help in physical design

zvika wrote:

> my plan is:
> 146 GB disk for archive and backup

Sounds fair. If all else comes to worse, you can also put the temporary tablespace(s) here.

> 2 X 72GB disks for dbf

Make the sector size on partition format same as database block size.

> 1 X 72 GB disk for online redo logs

Make sector size on partition format 512 bytes (or whatever you get from
doing "select max(lebsz) from sys.x$kccle;" in your current database). See here: http://www.ixora.com.au/notes/log_block_size.htm if you want to know why. It's not so bad if you set sector size to 1024, IME: active lgwrs will string together more than one single 512 byte chunk in a single write request.

> oracle software on system drive

Yup, sounds like a good idea.

> control files multiplexed across 3 drives

Not so good. Each time the db commits it has to write to all three control files. Use just two copies in redo logs disk with each multiplex of the redo logs. That's all you really need.

HTH Received on Mon Dec 05 2005 - 21:12:24 CST