Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » suse oracle »

Re: [suse-oracle] Help 10g Vs MSSql

Anton Dischner

2006-05-31

Replies:

Hi Enrique, suse-list,

this is what id do to enable async i/o:
Oracle 10.1.0.5 and SLES9 SP3, same on SLES9-64

install package libaio-devel
startup parameter
 filesystemio_options=asynch

sqlplus <<EOF
connect / as sysdba
shutdown immediate
EOF

 cd $ORACLE_HOME/rdbms/lib
 make -f ins_rdbms.mk async_on
 make -f ins_rdbms.mk ioracle

sqlplus <<EOF
connect / as sysdba
startup
EOF

Yast2:
Productivity/Databases/Tools/Oracle
 System /IO
   AIO_max_size=1048576

regards,

Toni

PS: You can get a big speed improvement in enabling write cache for
your RAID/disc
If you do this, be aware of power failure damages to your filesystem
and data.

> First, thank you all, this list rocks!!.


--
+-----------------------------------------------------------------+
| Anton Dischner, Unix admin, Oracle-DBA   Phone: +49 89 70953202|
| Institut fuer Klinische Chemie        Fax : +49 89 70958888|
| Klinikum Grosshadern               Home : +49 89 69708766|
| Ludwig Maximilians Universitaet Muenchen Mobil: +49 172 8388880|
| 81366 Muenchen Germany                            |
| Marchioninistr. 15   Anton.Dischner"at"med.uni-muenchen.de   |
+-----------------------------------------------------------------+



--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.