I set up the following tests:
In a RAC environment, User A connects on instance 3. User B connects on instance 4. User C connections on instance 4 as well.
User A opens a session browser, looks at User C's current statement's explain plan. I get the following queries from SQL Monitor. Note that for the explain plan, it queries TOAD_PLAN_TABLE:
----------------------------
select sql_text
from GV$sqltext_with_newlines where inst_id = 4 AND
address = (select DECODE(RAWTOHEX(sql_address), '00', prev_sql_addr, sql_address)
from GV$session
where username = :uname
and inst_id = 4
and sid = :snum)
ORDER BY piece
uname = 'MATHEW'
snum = 133
Select *
From TOAD_PLAN_TABLE
Where statement_id = :STATEMENT_ID
order by id
STATEMENT_ID = 'MPHAN:082207090903'
----------------------------
User B opens a session browser, looks at User C's current statement's explain plan. I get the following queries:
----------------------------
select sql_text
from GV$sqltext_with_newlines where inst_id = 4 AND
address = (select DECODE(RAWTOHEX(sql_address), '00', prev_sql_addr, sql_address)
from GV$session
where username = :uname
and inst_id = 4
and sid = :snum)
ORDER BY piece
uname = 'MATHEW'
snum = 133
Select *
From TOAD_PLAN_TABLE
Where statement_id = :STATEMENT_ID
order by id
STATEMENT_ID = 'MPHAN:082207090944'
----------------------------
User B opens a session browser and looks at User B's current statement's explain plan. I get the following queries:
----------------------------
Select *
from v$sql_plan
Where hash_value = :sqlhv
and child_number =:cn
order by id
sqlhv = '3302259605'
cn = 3
SELECT SQL_TEXT FROM GV$SQLTEXT_WITH_NE
STATUS:
Fixed in Toad for Oracle 9.5.0.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center