Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Polling SQL Queries
>
>
> 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