Re: Two users, one query, two optimizer plans

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Tue, 17 Jan 2006 15:21:41 -0800 (PST)
Message-ID: <20060117232142.20558.qmail@web52808.mail.yahoo.com>

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_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 17 2006 - 17:21:57 CST