RE: Import Question

From: Gogala, Mladen <MGogala_at_allegientsystems.com>
Date: Thu, 18 Aug 2005 16:59:17 -0400
Message-ID: <D42C14B2E3F2B74DB41D5B6B2E2B992F019320A2@pegasus.lawaudit.com>

No, I don't have anything better, but I do have something to add: you should also create multiple database writers (ideally, one per disk channel, but I never went above 4) and make sure that asynchronous I/O is enabled. Turn off all other unnecessary services, especially various XDM-related stuff, like font servers. If you really have memory to throw around, you can create a RAM disk and put redo logs on that disk. Do not forget to explicitly disable statistics with "statistics=none".

--

Mladen Gogala
Ext. 121
-----Original Message-----

... and for the truly daring ...

unmultiplex the online redo logs (one member per log group) unmultiplex the controlfiles (one controlfile for the database)

... and for the clinically insane ...

disable writes to the online redo logs via an underscore parameter.

got anything better than that, Mladen?

Paul

--

http://www.freelists.org/webpage/oracle-l Received on Thu Aug 18 2005 - 16:00:31 CDT