ORA-04030 while running jobs through dba_jobs
Hello All,
I am getting ORA-04030 errors daily with jobs that are scheduled to run through dba_jobs using dbms_sql. The same jobs complete without errors when they are run manually.
I have tried to work with Oracle but I have not got any success , even I tried lots of things ……(using Oracle notes and my own experience) but without success, I hope you guys can help me to resolve this error….
Here are the details of my server .
OS AIX5L Based Systems (64-bit / Memory 16GB
Oracle - Oracle Server - Enterprise Edition 10.1.0.5
Oracle user has unlimited ulimit
/optware/oracle$ ulimit -Ha
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 4194304
memory(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) unlimited
Some of the important parameters from init.ora
resource_limit = TRUE
sga_max_size = 4194304000
__shared_pool_size = 1895825408
shared_pool_size = 1895825408
__large_pool_size = 318767104
large_pool_size = 318767104
__java_pool_size = 419430400
java_pool_size = 419430400
shared_pool_reserved_size= 50677721
sga_target = 4194304000
db_block_size = 8192
__db_cache_size = 1543503872
db_cache_size = 838860800
compatible = 10.1.0.4.0
job_queue_processes = 25
cursor_sharing = SIMILAR
parallel_min_servers = 0
parallel_max_servers = 5
hash_area_size = 1310720
sort_area_retained_size = 0
open_cursors = 500
pga_aggregate_target = 3145728000
Please let me know if you need any more details.
Santo