topic Re: Oracle monitoring tools for OpenVMS? in Operating System - OpenVMS

Oracle monitoring tools for OpenVMS?

roose — Thu, 27 Sep 2007 11:42:13 GMT

Hi Folks,

I would just like to get some information from those of us here using Oracle on OpenVMS, what are the tools that they are using and/or would recommend in monitoring and gathering statistics? We have been recently hit with some database incidents and would like to gather statistics regularly so that we can go back to examine these data everytime that we will have an incident. By the way, we are currently using Oracle 9i and OpenVMS v7.3-2 on an AlphaServer ES80.

Thanks in advance for your help!

Re: Oracle monitoring tools for OpenVMS?

Hoff — Thu, 27 Sep 2007 15:05:33 GMT

Do consider asking this of Oracle, the folks that best know the Oracle database and its tools, as they will undoubtedly have tools and related recommendations.

Re: Oracle monitoring tools for OpenVMS?

Hein van den Heuvel — Thu, 27 Sep 2007 22:58:20 GMT

Oracle is Oracle is Oracle.
On Unix, OpenVMS or Windoze.
Use its STATSPACK!

The similarities are much larger than the differences.
Admittedly the stats for a particully platform are one of the areas where there are slightly more differences than say the SQL language, but it is still minimally different

The Only OpenVMS specific trick I can think about is really the T4 oracle module

Cheers,
Hein.

If, and only if, Statspack does not appear to fullfill the need, then by all means come back and articulate what seemed to be missing.

Re: Oracle monitoring tools for OpenVMS?

roose — Fri, 28 Sep 2007 00:25:58 GMT

Thanks for the replies. Of course, it would really be best to go to Oracle for this, but I was thinking that it will be much better to get this information from the end users like us with their experiences on these products.

Re: Oracle monitoring tools for OpenVMS?

Kumar_Sanjay — Mon, 01 Oct 2007 05:39:33 GMT

Roose chua,

Do you only Process Monitoring.?
or some other thing...pls explane.

Sanjay Kumar