This content has been marked as final. Show 8 replies
Hi, This is because the shared pool is full. For it, you will to do it:
SQL> alter system flush shared_pool;
Thanks for helpful brunors.
Hi,1 person found this helpful
Is not that due to small sga?
Can you increase shared_pool_size (or SGA_TARGET)?
Hi, my SGA is big; But the operation in this moment was large. But I will see with the parameters in the environment.
For to do it is alter system set parameterName = value;1 person found this helpful
But, before that ckeck the enviroment.
Kind regards, Bruno Reis.
Ok, I will see with de DBA more experient.
Sorry, ORA-4030 is due to memory from OS, not SGA.
SGA is ORA-4031..