Database Memory & 4030/4031 (MOSC)

MOSC Banner

11.2.0.3 ORA-04030: out of process memory (initSubHeap:qk,travElemP:qkspmTravCreate) errors

edited Apr 28, 2014 11:07AM in Database Memory & 4030/4031 (MOSC) 2 commentsAnswered ✓

Hello,

For the past couple of days we're receiving ORA-04030: out of process memory (initSubHeap:qk,travElemP:qkspmTravCreate) errors during the maintenance window. It seems to be trying to sql tune the same large query at least 3 times. Below is a snip-it from the trace file.  I found note 1541769.1 which says to set _optimizer_fast_pred_transitivity=false. I wanted to verify with anyone that this is what I should do. Or should I open an SR?

Thanks,

Terri

*** 2014-04-23 22:32:05.269
*** SESSION ID:(163.62123) 2014-04-23 22:32:05.269
*** CLIENT ID:() 2014-04-23 22:32:05.269
*** SERVICE NAME:(SYS$USERS) 2014-04-23 22:32:05.269
*** MODULE NAME:(DBMS_SCHEDULER) 2014-04-23 22:32:05.269

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center