- 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
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
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!
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
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