Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Finding slow executing statements
"Daniel A. Morgan" <damorgan_at_exesolutions.com> wrote in message news:<3C5AC8C6.D3FFD3AC_at_exesolutions.com>...
> I like DBMS_PROFILER better.
How exactly does one use DBMS_PROFILER on a production machine with OCI or ODBC applications written elsewhere?
>
> Daniel Morgan
>
>
>
>
> Joel Garry wrote:
>
> > mngong_at_yahoo.com (michael ngong) wrote in message news:<ecf365d5.0202011045.22e07f73_at_posting.google.com>...
> > > "Steven Pannell" <steven.pannell_at_gmx.net> wrote in message news:<a3ecne$17otsn$1_at_ID-82797.news.dfncis.de>...
> > > > Hi,
> > > >
> > > > I am wondering if there anyway that I can retrieve slow executing statements
> > > > from the oracle database without switching on the trace files. Or is the
> > > > only way to find out how long SQL statements take is with tkprof. Basically
> > > > I just want to find out which statements are taking a long time to execute
> > > > on the database. is there a v$ table I can get this information??
> > > >
> > > > Thanks for any help,
> > > > Steve,
> > > This might give a pointer to the sql statement that is consuming the
> > > most resource in the most cases the slow statement
> > >
> > > select sql_text,executions,disk_reads,buffer_gets, from v$sqlarea
> > > where executions>5000 ;
> > > YOU could use this to find the sql statements with the greatest disk
> > > reads,buffer gets etc,
> > > Change your where clause accordingly
> > > Michael Tubuo Ngong(Oracle DBA)
> >
> > I kinda like http://www.jlcomp.demon.co.uk/guilty.html
> >
> > jg
> > --
> > What is happening to my conn!^$%!$@~~+++AT
jg
-- "Placing applications on the internet will make systems integration unnecessary... The more information is integrated, the more valuable it becomes." Ron Wohl, in Oracle Magazine. "Why were Compaq Proliant servers used for the introduction of Oracle9i?" Back cover of same magazine.Received on Mon Feb 04 2002 - 13:04:15 CST