Search

OakieTags

Who's online

There are currently 0 users and 53 guests online.

Recent comments

Affiliations

Which PLAN_HASH_VALUE Appears in V$SQLAREA?

March 28, 2012 A recent question on the OTN forums asked which PLAN_HASH_VALUE appears in V$SQLAREA when there are multiple child cursors for a single SQL_ID value, when some child cursors have a different execution plan.  Certainly, this bit of information must be in the Oracle Database documentation.  Let’s check the V$SQLAREA documentation for Oracle Database 11.2: [...]