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: Polling SQL Queries

Re: Polling SQL Queries

From: KJD <kjdama_at_yahoo.com>
Date: 13 Sep 2003 07:03:49 -0700
Message-ID: <8c907343.0309130603.4fe1a516@posting.google.com>


>
>
> v$sqlarea captures the number of executions.
> The problem with your approach is that tools like you propose to
> develop usually impose a significant overhead on the database.
> You would also better use statspack as it is already capable of
> tracking sql.
>
>

At any one point in time can I query Oracle for what SQL queries it is executing at this very point in time. There must be a way to tell me what Oracle is busy doing at any point in time. Received on Sat Sep 13 2003 - 09:03:49 CDT

Original text of this message

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