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>
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-lReceived on Mon Jan 28 2008 - 04:34:12 CST