Re: Two users, one query, two optimizer plans

  • From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>
  • To: paul.baumgartel@xxxxxxxxx, Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 17 Jan 2006 15:21:41 -0800 (PST)

Is it possible to look at the V$SQL - PLAN_HASH_VALUE
for the 2 SQL sessions?

By using the PLAN_HASH_VALUE in the V$SQL view you can
track when new access paths to data have been used.

--- Paul Baumgartel <paul.baumgartel@xxxxxxxxx> wrote:

> When both sessions are running the query, the SQL
> IDs (from v$session)
> 
> SQL_ADDR SQL_HASH_VALUE SQL_ID
> -------- -------------- -------------
> B8E1D068     1036950108 95qchfhywx6kw
> 
> are identical.
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2006