trace (get) sql script

From: <Ukrit.K_at_ayudhyaallianzcp.co.th>
Date: Wed, 26 Feb 2003 00:33:50 -0800
Message-ID: <F001.00559ADF.20030226003350@fatcity.com>

Dear All,

         Here we have about 14 Oracle devlopers and some times they run a sript which down grade the database performance. I nicely asked for a script that a developer has run for testing but sometimes they won't give away it so easily. So I would like to know that is it possible to get the script the develper is running from Oracle v$ views or table ? so I can be on top of the problem and provide a good answer to other.

        I believe that in each site, there is a developer who not easily to tell DBA what he/she is doing until they really cause a problem. Thanks you for help.
Ukrit K.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
  INET: Ukrit.K_at_ayudhyaallianzcp.co.th

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Feb 26 2003 - 02:33:50 CST