cancel
Showing results for 
Search instead for 
Did you mean: 

HPUX 11.0 Oracle 9.2 ORA-27102

HPUX 11.0 Oracle 9.2 ORA-27102

The following error occurs upon using SQL*Loader:
---------------------------------------
EXEC_FAILD SQL*Loader-128: Session can not be startedORA-27102: out
of memoryHP-UX Error: 12: Not enough spaceAdditional information:
103Additional information: 33554432Additional information: 1776760

SQL*Loader: Release 9.2.0.1.0 - Production on Di Dez 10 15:45:35 2002

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Could this be relates to the fact that we have two instances on the same server, so we are running out of RAM.

Or is this a Disk Space Problem related to Space assigned to the Oracle Database Tablespaces.
3 REPLIES
harry d brown jr
Honored Contributor

Re: HPUX 11.0 Oracle 9.2 ORA-27102

memory/swap.

oracle 9.x, being the PIG that it is, requires 2.5 times more memory than 8.x did!

live free or die
harry
Live Free or Die

Re: HPUX 11.0 Oracle 9.2 ORA-27102

Which Parameters should be tuned specifically ?

Could this also be related to:

- Listener Service Type: Dedicated versus MTS
- Rollback Size
- Tablespace Space
- SGA Settings

Can we quickly fix this by changing the SGA in the init.ora ?
harry d brown jr
Honored Contributor

Re: HPUX 11.0 Oracle 9.2 ORA-27102

Immediately, change these

dbc_max_pct 50 - - -
dbc_min_pct 5


TO dbc_max_pct = 10, and dbc_min_pct = 5

live free or die
harry
Live Free or Die