Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd7cy2so!shaw.ca!news3.optonline.net!newshosting.com!news-xfer1.atl.newshosting.com!yellow.newsread.com!netaxs.com!newsread.com!newsfeed00.sul.t-online.de!newsmm00.sul.t-online.com!t-online.de!news.t-online.com!not-for-mail From: "Jens Kutschke" Newsgroups: comp.databases.oracle.server Subject: Logging of SQL statements Date: Fri, 12 Dec 2003 14:39:58 +0100 Organization: T-Online Lines: 23 Message-ID: Reply-To: "Jens Kutschke" Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: news.t-online.com 1071236400 04 21439 fnXEGN7L3zgaBTn 031212 13:40:00 X-Complaints-To: usenet-abuse@t-online.de X-ID: GFfZf0ZJQeaygk6JphiBUeInuF+NK9Fji0Vl7VYYDiyOs4xnB331EW X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:249971 Hi, I'm pretty new to Oracle. Can anybody help me with the following problems? 1. Is there any possibility to let the database server log all incoming SQL statements for a database into a logfile and how do I do this? 2. Is there any possibility to let the database server log all incoming SQL DELETE statements for a certain table into another logfile and how do I do this? Thank you for any help! Jens -- _____________________________________________ Jens Kutschke http://www.j-dimension.com