Re: Can you query Oracle to ask how busy the server is?

On 15 Apr 2005 08:16:16 -0700, "deanbrown3d" <deanbrown3d_at_yahoo.com> wrote:

>I want to query a database every few seconds to tell me how busy it is
>right now, so that I can give a visible indicator. This would help the
>users of our program see why their processes may or may not be taking a
>long time, or let them know why its all working slowly right now.
>
>Any ideas?

You are reinventing the wheel. Oracle Enterprise Manager comes with Topsessions.
Apart from that firing a query every few seconds, especially on the v$ tables, only adds to the already existing load on the system. That's not very smart, isn't it.
Apart from that your 'indicator' is really meaningless, because end-users don't have the knowledge to derive anything from it, and judge the performance of the system by their own subjective criteria anyway.

--
Sybrand Bakker, Senior Oracle DBA