SQL tracing in Oracle
"Kevin Hands" <[email protected]> Tue, 14 Jan 2003 18:02:38
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Message-ID | <LYRIS-1796914-832876-2003.01.14-17.49.22--gcdod-oracle#[email protected]> |
I am trying to monitor SQL requests made to my Oracle DB I can use SQL trace and it gives me the basic SQL request sent in and the stats on it. But the information is not detailed enough, the log shows a "select" request returning zero rows but the "where" contains variables and not the actual match requested. Does anybody know a way of getting the exact SQL request with all its parameters displayed or does anybody know of another app that can do this. The application/client I am trying to monitor has no source so this is the only way to see what is happening, and why it returns zero rows. --- Change your mail options at http://p2p.wrox.com/manager.asp or to unsubscribe send a blank email to [email protected].