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].