Issue ORA-04030
- From: "Eriovaldo Andrietta" <ecandrietta@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 18 Jan 2009 19:59:44 -0200
Hi Friends.
I am facing problem running a PL/SQL that uses Oracle Spatial. I am getting
the error ORA-04030.
Oracle cannot allocate resource when try allocate 123404 bytes (QERHJ
hash-joi,kllcqas:kllsltba) and others kinds or ORA-04030.
Is there anything wrong ?
Is there anymore parameter that Oracle Spatial uses and I need to set it ?
Regards
Eriovaldo
Here are parameters of my database
Total System Global Area 1577058304 bytes
Fixed Size 1293092 bytes
Variable Size 864027868 bytes
Database Buffers 704643072 bytes
Redo Buffers 7094272 bytes
SQL> show parameter pga
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
pga_aggregate_target big integer 800M
SQL> show parameters sort
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
nls_sort string
sort_area_retained_size integer 65536
sort_area_size integer 1048576
SQL> show parameters hash
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
hash_area_size integer 2097152
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 1504M
sga_target big integer 1000M
Other related posts:
