Re: How to capture SQL

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 18 Aug 2004 07:29:05 -0400
Message-ID: <woqdndXNo6gfoL7cRVn-jw@comcast.com>

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:Xns9548BB2C8447BSunnySD_at_68.6.19.6...
| "Randy Harris" <randy_at_SpamFree.com> wrote in
| news:TrxUc.2712$ZC7.249_at_newssvr19.news.prodigy.com:
|
| > Is there a simple means of capturing an SQL statement sent from an
| > application to an Oracle 9i server (on the server end)?
|
| No, there is not.
| I am not saying it is impossible, just not simple.
| It depends on a number of factors none of which you specified

simplest way? use the V$SQL_AREA (and related) dynamic dictionary tables (typically accessible only to a DBA) Received on Wed Aug 18 2004 - 06:29:05 CDT