Shared pool error
Hi team,
I have problem with shared pool, since i got this error in our UAT 12.1.0.2.0 database (Oracle Linux 7):
SQLException java.sql.SQLException: ORA-04031: unable to allocate 40 bytes of shared memory ("shared pool","SELECT TABLE1.APPLICATION_I...","KGLH0^5bf9a083","kglHeapInitialize:temp")
I have tried to allocate more memory to shared pool but it seems that its not enough. This error is throwed by EBS concurrent program and I hope that you can guide me since it is database related error.
My parameters are as follows:
show parameter sga;
I have problem with shared pool, since i got this error in our UAT 12.1.0.2.0 database (Oracle Linux 7):
SQLException java.sql.SQLException: ORA-04031: unable to allocate 40 bytes of shared memory ("shared pool","SELECT TABLE1.APPLICATION_I...","KGLH0^5bf9a083","kglHeapInitialize:temp")
I have tried to allocate more memory to shared pool but it seems that its not enough. This error is throwed by EBS concurrent program and I hope that you can guide me since it is database related error.
My parameters are as follows:
show parameter sga;
lock_sga boolean FALSE
pre_page_sga boolean TRUE
sga_max_size integer 2734686208
Tagged:
0