May 23, 2012
Kill LOCAL=NO Processes at one go
2.7K

Kill LOCAL=NO Processes at one go

Kill LOCAL=NO Processes at one go Whenever you are trying to shutdown the database, sometimes it will hang up in the process of shutdown. At that time, open another terminal and grep for LOCAL=NO processes “ps -ef|grep LOCAL” Output oracle 3747948 1 0 Apr 27 – 0:00 INSTANCENAME (LOCAL=NO) oracle...
May 23, 2012
ORA-04031: unable to allocate 4080 bytes of shared memory
916

ORA-04031: unable to allocate 4080 bytes of shared memory

ORA-04031: unable to allocate 4080 bytes of shared memory This is very common error in Oracle Whenever you get below error, try to flush the shared pool with this command “alter system flush shared_pool”. ¬†It doesn’t have any impact on performance of the database. “java.sql.SQLException: ORA-04031: unable to allocate 4080...