969224 wrote:Above should have only impacted a single process; not the whole DB
Is there any way to find out what objects or sqls are using up most of the shared_pool memory in 18.104.22.168.0. One of my databases just crashed due to the error "ORA-04031: unable to allocate 32 bytes of shared memory ".
So I had to bounce the database.Really?
969224 wrote:it appears somebody hit the Panic Button & shutdown the DB for no good reason.
Wed Dec 19 15:03:52 2012
License high water mark = 79
USER (ospid: 31131774): terminating the instance
Instance terminated by USER, pid = 31131774
Wed Dec 19 15:03:58 2012
TNS-12535: TNS:operation timed outabove is symptomatic of FireWall issue.
969224 wrote:somebody did SHUTDOWN the DB.
do you mean to say that somebody shutdown the database, and that is why the errors occured?