Oracle 9i on HP-UX 11i

[B S_1]

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.

[Graham Cameron_1]

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

[Steven E. Protter]

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

[Brian Crabtree]

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