Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 16470
  • Last Modified:

Oracle 10g lockup: heap exceeds threshold only indication in alert log

Oracle 10g on AIX with 6 started databases locked up.  Users in session could continue processing but no new users could sign in.  SQLPLUS froze after password was entered even when trying to sign in as sysdba.

Alert log showed at time of lock up  a message "heap (2949) exceeds notification threshold (2048)".  Appeared to be trying to load an object into SGA with name like XDB.xx.

It is possible that an import was running updating tables that one or more users could have been accessing, but alert log indicates successful import.

In trying to resolve problem,  tried to stop listener to prevent attempted sign ins,
but "lsnrctl stop" also hung. Seemed like databases were down, but in trying to
strart databases, got messages to stop them first, so, depending on where you looked and what you did you got conflicting information as to state of databases.

Finally did brute force dbshut and dbstart.  

Why I am getting heap size exceeded messages, and what is causing them?
Could whatever caused the messages cause an apparent lock up?
1 Solution
Metalink.oracle.com (Oracle's support site) has an article regarding this.  Note: 330239.1

I suggest reading the entire note. If you are using an spfile, they suggest trying (as sysdba):
SQL> alter system set "_kgl_large_heap_warning_threshold"=8388608 scope=spfile ;
SQL> shutdown immediate SQL> startup

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now