Home » RDBMS Server » Performance Tuning » Oracle 8.1.7.0 - How to find BIND Variable values ?
icon5.gif  Oracle 8.1.7.0 - How to find BIND Variable values ? [message #163383] Thu, 16 March 2006 09:29
deadpoet
Messages: 17
Registered: August 2005
Junior Member
Dears,

I'm looking for reducing number of GETS inside the SGA by tuning top 10 worst queries.
But I'm facing one SQL, with 3 BIND VARIABLES used to deploy a tree (...START WITH ISID = :V00003...) Embarassed

I want to know, if there's a way to find the exact value ?
I've tryed, TOAD 8.5.6, Db tuner or directly in SGA but I only get the ":V0000x"

Is there a table in the SID_database ?

Thank you for any help
G
Previous Topic: Difference in location of the hint
Next Topic: Materialized view vs Table
Goto Forum:
  


Current Time: Sat Nov 23 14:44:56 CST 2024