Would this help? It looks like your trying to see the bind variables.

http://www.dbasupport.com/oracle/ora10g/watching0202.shtml


Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546

-----Original Message-----
From: Loukota Amy
[mailto:oracledba-ezmlmshield-x99037932.[Email address protected]
Sent: Thursday, November 30, 2006 12:20 PM
To: LazyDBA Discussion
Subject: actual sql ...

Does anybody know how to get the actual sql from the database?

I'm looking for what comes out of the logminer but I don't want to do
logminer.

I do NOT mean the sql_text info. EX ... select * from sometable where
x=:b1;

I'm looking for ... select * from sometable where x=5;




Amy Loukota
Oracle Certified DBA
TriWest HealthCare Alliance
15451 N. 28th Ave.
Phoenix, AZ 85053
[Email address protected] <mailto:[Email address protected]
work: 602-564-2452

Smile! It's another day under the big top
and there is no shortage of clowns!




The information contained within this transmission is proprietary and
protected pursuant to federal regulations; it is intended only for the
use of the individual or entity to which it is addressed.
If you are not the intended recipient, you are hereby notified that any
distribution, copying, disclosure, use of, or reliance on, the contents
of this transmission is strictly prohibited.
If you have received this communication in error, please notify the
sender immediately by telephone and permanently delete the original
message, attachments and all copies. Thank you.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page