Re: ORA-04031: unable to allocate 312 bytes of shared memory ("shared pool","unknown object","CCursor","kglob")

From: 조동욱 <>
Date: Mon, 28 Jan 2008 19:34:12 +0900
Message-ID: <>

PCursor = Parent Cursor
CCursor = Child Cursor

SQL text(statement) is stored as parent - child cursor combination. They have one to many relationship. PCursor : CCursor = 1 : M

For instance, let's assume that ...
User A submits "select * from tab_a".
User B submits "select * from tab_a".
Same sql text, but different sql cursor.

In this case, we have one parent cursor whose sql text is "select * from tab_a",
and 2 child cursors whose execution plans are different.

The area that execution plan is stored is called "sql area".

Hope this clarifies the terms.

Received on Mon Jan 28 2008 - 04:34:12 CST

Original text of this message