Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
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