cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 9i on HP-UX 11i

B S_1
Occasional Advisor

Oracle 9i on HP-UX 11i

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.
geht nicht, gibts nicht!
3 REPLIES
Graham Cameron_1
Honored Contributor

Re: Oracle 9i on HP-UX 11i

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
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
Steven E. Protter
Exalted Contributor

Re: Oracle 9i on HP-UX 11i

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Brian Crabtree
Honored Contributor

Re: Oracle 9i on HP-UX 11i

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