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,
Reply 1
Replies (4)

Re: Monitoring oracle database

by Gibu
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.
Reply 0

Re: Monitoring oracle database

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




Re: Re: Monitoring oracle database

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

 

Reply 1

Re: Re: Re: Monitoring oracle database

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 (support@site24x7.com) for any queries.

Thanks!  

Reply 1