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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can you query Oracle to ask how busy the server is?

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

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sat, 16 Apr 2005 07:09:22 -0400
Message-ID: <G66dnX38b-L_b_3fRVn-iw@comcast.com>

"deanbrown3d" <deanbrown3d_at_yahoo.com> wrote in message news:1113623365.900654.111970_at_f14g2000cwb.googlegroups.com...
> If it can't be done, then that's a perfectly reasonable reply and I
> appreciate it!
>
> Dean
>

Dean,

It can be done by selecting pertinent data from the V$* database views, but I think the point that some were trying to make in their own sweet way is that you will be adding to the load on the system, especially if you have the indicator run by every user/developer -- so, it is probably best to have a single process monitor the database for performance issues, which is what OEM is provided for.

Is the point a matter of convenience for the developers or are do you want something that will assist them in performance tuning?

If there is a need that cannot be satisfied by the Enterprise Manager screens, you could have one process issue periodic queries against the V$* views and issue alerts that the other processes can listen for -- which is starting to sound a lot like OEM Events. You may want to take a look there.

++ mcs Received on Sat Apr 16 2005 - 06:09:22 CDT

Original text of this message

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