Re: Basic SQL Question, re. logging costly sql

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Wed, 19 Oct 2005 20:57:57 GMT
Message-ID: <4356b301.793755562@localhost>

On 19 Oct 2005 13:14:43 -0700, "BD" <bobby_dread_at_hotmail.com> wrote:

>Hey, all.
>
>This is actually more of a SQL question than an Oracle question - but,
>since it's Oracle-specific, I'll risk a mild slapping about by posting
>here.

If this is an Oracle database, use STATSPACK In order versions there was an utlbstat utlestat, although I don't recall if it includes expensive sql statements. Statspack will show you expensive sql.
.......
We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4 remove NSPAM to email Received on Wed Oct 19 2005 - 15:57:57 CDT