Go to All Forums

Monitoring oracle database

hi,

can we able to monitor the oracle database using 24X7 and also is there any probe concept for monitoring muliple servers at a time and providing the results in single dashboard.

kindly update,
Like (4) Reply
Replies (6)

Interesting question. As you rightly hinted, we do not have this yet. Currently the best we have is an "agent software based" server monitoring. Monitor server, processes, TCP ports.

For Server Monitoring, if you do not want to allow access (outbound) to the internet for all servers, you could route the server agents via an HTTP Proxy.


That said, I would like to know a bit of context, especially for the Oracle Monitoring and Deployment scenario.

Is your usage in an MSP Context or Enterprise Context? How many different geographical locations will you have your Oracle / Server in? Any additional inputs are great to have.
Like (0) Reply

I also think an Oracle agent would be nice, interesting data could include (copied from corresponding op5 client):

- database availability (tnsping)

- login or dummy login

- cache hit ratio

- tablespace usage

- datafile usage

- total number of datafiles

- available extents per table or tablespace

- log archiving enabled or not

- backupmode

- user defined query, match for string or numeric value - locks

- broken transactions

- failed transactions

- transactions in the deferred error queue

- invalid transactions



Like (0) Reply

I realize this thread is old but figured better to bump it than to start a new thread.

Is there anything on the Site24x7 roadmap to monitor Oracle database metrics as mentioned above?
  - database availability (tnsping)
  - login or dummy login
  - cache hit ratio
  - tablespace usage
  - datafile usage
  - total number of datafiles
  - available extents per table or tablespace
  - log archiving enabled or not
  - backupmode
  - user defined query, match for string or numeric value - locks
  - broken transactions
  - failed transactions
  - transactions in the deferred error queue
  - invalid transactions

 

Like (0) Reply

Hi,

We now have plugins for monitoring your Oracle database.

With the Oracle plugin, you can now monitor your entire Oracle database using metrics like

  • buffer cache hit ratio
  • disk memory sort ratio
  • Oracle availability
  • processes usage in percentage (%)
  • response time
  • sessions usage in percentage (%)

Further, to gather more insight on knowing about the tablespace details and its usage, we have two more plugins in specific.

oracle_tablespace_details.py - The metrics that we provide for this plugin are:

  • tablespace status
  • tablespace usage in percentage (%)
  • Number of reads in the tablespace
  • Number of writes in the tablespace
  • Used space in MB
  • Free space in MB
  • Number of free blocks
  • Know whether logging is enabled or not

oracle_tablespace_usage.py - For every tablespace present in your database, you will be able to monitor their individual status and usage in percentage (%).

Follow the steps mentioned in our documentation to install the plugin and view data in the Site24x7 dashboard. Get in touch with our support ([email protected]) for any queries.

Thanks!  

Like (0) Reply

Hi,

Having got your 3 plugins working yesterday, I have a SQL script for monitoring tablespace freespace that I have cut down on the returned rows to just the tablespace name, free space as a % and the tablespace size.

The SQL is working perfectly but I am having problems with the wrapper (using your script oracle_tablespace_usage.py as a template)

If I send you my .py script with the SQL enclosed would you be able to help me and debug my wrapper please as I'm having issues with the indentation etc. ?

Is this a service you offer at all?

Thanks,

Simon

Like (0) Reply

Hi,


We have shared the plugin script after correcting the indentation errors via support. Hope it works fine now.

It would also be great if you can upload the plugin script to our GitHub repository for our other Site24x7 users to use. Do let us know if you are willing to :)

Please let us know for other issues, if any, in the thread below.

 

Regards,

Godwyn

Like (0) Reply

Was this post helpful?