HPUX 11.0 Oracle 9.2 ORA-27102

[Wolfgang Niefert]

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.

[harry d brown jr]

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

[Wolfgang Niefert]

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]

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