Is it possible to view the contents of bind variables on queries from another session in v$sqlarea?
Sorry, it is not possible. The V$ views query those areas of shared memory for all Oracle processes. Since all Oracle process have the ability to reuse queries, you can see the queries in V$SQLAREA. However, bind variable values are specific to a session. Those values are stored in session-specific memory.
Your best bet is to start a 10046 trace with level 4 or 12 or higher to get bind variable values.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.