Re: Why wait?

From: Greg Moore <sqlgreg_at_pacbell.net>
Date: Wed, 24 Apr 2002 18:38:21 -0800
Message-ID: <F001.0044EBE4.20020424183821@fatcity.com>

Anjo,

You wrote:

The problem in Oracle is that wait events are not broken down per SQL statement (only on the instance and session level). There are products that out there that do this for you, but that would be completely different post ;-)

I'll bite. Which products do this?

Do they rely on a 10046, level 8 trace file for each SQL statement in the system to allow wait events to be broken down per SQL statement? If not, how in the world do they accomplish this?

--

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

Author: Greg Moore
  INET: sqlgreg_at_pacbell.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Apr 24 2002 - 21:38:21 CDT