Toad World® Forums

SQL Optimizer - Inspect SGA - currently running query - connection identity - add machine to identity choices

We have multiple application servers that run the same application program, but for different clients programs.  All the data for all the programs are loaded into the same schema and connect using the same username.  The only thing I can differentiate the 4 is their actual machine designation, which the optimizer does not offer.  This would help us tremendously in narrowing down where the bad sql originated from.