Use the spool command:

spool to_file
sql_stuff;
spool off

michael

-----Original Message-----
From: Johnson Shaunn
[mailto:oracledba-ezmlmshield-x96261542.[Email address protected]
Sent: Thursday, January 05, 2006 8:34 AM
To: LazyDBA Discussion
Subject: [***SPAM***] - how to capture queries? - Number of numbers in
MIME From exceeds maximum threshold


Howdy -

Running Oracle 9.2.0.4 on RedHat Linux AS 2.1

Is there any way to capture SQL (especially long running queries, full
table scans)
when a job is kicked off (or, really, when the job completes)? This
sounds like
something that would require an audit-type program to store all queries
and
keep them in a separate table.

Any thoughts?

Thanks!

-X
This electronic mail message and any attachments contain information that(a) is or may be
LEGALLY PRIVILEGED, CONFIDENTIAL, PROPRIETARY IN NATURE, OR OTHERWISE PROTECTED BY LAW FROM
DISCLOSURE, and (b) is intended only for the use of the Addressee(s) named herein. If you
are not the intended recipient, an addressee, you are hereby notified that reading, using,
copying, or distributing any part of this message or any information transmitted herewith is
strictly prohibited. If you have received this electronic mail message in error, please
contact us immediately and take the steps necessary to delete the message completely from
your computer system.


Thank you.




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page