Operating System - HP-UX
1754014 Members
7476 Online
108811 Solutions
New Discussion

Re: oracle database 8.1.7.2 with HP-UX 11

 
Wodisch
Honored Contributor

Re: oracle database 8.1.7.2 with HP-UX 11

Hello,

if you do not find any patches from Oracle or so, you could try to increase
- sort_area_size and
- sort_area_retained_size to something like 4MB, and 1MB, resp.,
- shared_pool_size to some 300MB or more,

HTH,
Wodisch
Kaminiarz
Occasional Advisor

Re: oracle database 8.1.7.2 with HP-UX 11

my SGA is 2,2 GB large.
1024 MB shared_pool_size,
50 MB shared_pool_reserved_size,
20 MB sort_area_size, i think, this is anouth!