topic Re: Oracle 9i on HP-UX 11i in Operating System - HP-UX

Oracle 9i on HP-UX 11i

B S_1 — Wed, 22 Oct 2003 07:59:35 GMT

Hi,
we allready installed Oracle 9i with the
Option "General Purpose".
Now we need to customize the init*.ora values for best performance.

We need a TEMP Tablespace of 1000 MB,
a Rollback size of 500 MB, Indizes 500 MB

Thank you in advance for any help.

Re: Oracle 9i on HP-UX 11i

Graham Cameron_1 — Wed, 22 Oct 2003 08:25:59 GMT

Your short questions could have many many answers, and there are many places to go to for help.

http://www.orafaq.com/navdba.htm
http://asktom.oracle.com/

are 2 of my favourites.

Specifically
create tablespace temp_01 datafile
'[PATH TO YOUR DATAFILE]' size 1024M
default storage(
initial 8M
next 8M
pctincrease 0
);
alter tablespace temp_01 temporary;

and so on
-- Graham

Re: Oracle 9i on HP-UX 11i

Steven E. Protter — Wed, 22 Oct 2003 08:54:50 GMT

I would install the oracle stats pack(otn.oracle.com) so you can take some measurements and figure out how to tune your init.ora files.

SEP

Re: Oracle 9i on HP-UX 11i

Brian Crabtree — Mon, 27 Oct 2003 20:05:10 GMT

create temporary tablespace temp tempfile '' size 1001m extent management local uniform size 5m;

create undo tablespace undo datafile '' size 500m extent management local autoallocate segment space management auto;

Hope this helps,

brian