Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sql statements executing

Re: sql statements executing

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Wed, 15 Jan 2003 14:58:32 -0800
Message-ID: <3E25E798.755A5C85@exesolutions.com>


Steve Ashmore wrote:

> Look in v$sqlarea.
> Or run some statspack snapshots. (Which will take pictures of v$sqlarea)
>
> Stephen C. Ashmore
> Brainbench MVP for Oracle Administration
> http://www.brainbench.com
> Author of: 'So You Want to be an Oracle DBA?'
>
> "Amit Kaushal" <amit_at_billdesk.com> wrote in message
> news:4c63c8fc.0301150248.442532a_at_posting.google.com...
> > HI,
> >
> > i want to find out that over a period of time (say about a couple of
> > days) which sql staements are being executed regularly so that i can
> > work on them and optimise them.
> >
> > I am using oracle 8.0.6 on solaris 2.6
> >
> > If possible pls reply to this email id also : amit_at_billdesk.com
> >
> > Thanks in Advance
> > amit kaushal
> > www.billdesk.com

And if the application involves procedures, functions, and triggers look at the DBMS_PROFILES built-in package. It does a lot more than tell you which ones ... it identifies which ones are taking the most time and more.

Daniel Morgan Received on Wed Jan 15 2003 - 16:58:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US