Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P File: ./project/webodbcaccess/odbcstatementimpl.cpp, Line: 186 State: S1000. Code: 10058. [NQODBC] [SQL_STATE: S1000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 4030, message: ORA-04030: out of process memory when trying to allocate 246284 bytes (hash-join subh,kllcqas:kllsltba) at OCI call OCIStmtFetch. [nQSError: 17012] Bulk fetch failed. (S1000) |
This is caused by a shortage of RAM on a dedicated (non shared server) environment. Depending on the Oracle version, the options for DBAs are: - Increase pga_aggregate_target.
- Decrease sort_area_size and/or hash_area_size.
- Move to multi-threaded server (a.k.a. MTS or shared servers).
|