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

From: Á¶µ¿¿í <ukja.dion_at_gmail.com>
Date: Mon, 28 Jan 2008 19:34:12 +0900
Message-ID: <43c2e3d60801280234g7d89052fw7e27f30195957f5d@mail.gmail.com>


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.

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 28 2008 - 04:34:12 CST

Original text of this message