view counter

Which PLAN_HASH_VALUE Appears in V$SQLAREA?

Thanks to Charles Hooper for this story

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: [...]

view counter

Read the entire article at its source

view counter