Re: sql statements executing

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Wed, 15 Jan 2003 05:38:11 -0600
Message-ID: <v2ai0e5k8bosb7@corp.supernews.com>

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
Received on Wed Jan 15 2003 - 05:38:11 CST