Providing the same level of monitoring for Oracle as SAM has for MSSQL via AppInsight for SQL. Table Sizes, index fragmentation, individual database statuses, connections, most expensive queries, etc.
You can use the Oracle APM template in SAM described here Oracle Database (Updated)
For deeper monitoring and for a better view into database performance you can also use SolarWinds Database Performance Analyzer (DPA). DPA supports Oracle, SQL Server, Sybase and IBM DB2. Oracle Performance Monitoring & Analyzer | SolarWinds
With DPA you get database health metrics and wait-time analysis, which gives you visibility into historical and detailed view into how the database engine is servicing an application request and how the wait times correlate with supporting resources including host OS, virtualization and storage I/O.
gerardodada I find this isn't enough. DPA is great for database performance and "Oracle Database" lets you see predefined metrics, but in the middle you have "making queries to pull data from tables" and nothing in SAM or DPA appears to fit the bill for that.
Aka, I want to perform custom query X, which tells me Y.
My users want to monitor databases that have dozens of tablespaces, and which may have new tablespaces added or deleted without notice. I would like a tool that can detect when tablespaces are added or dropped so I don't get yelled at by DBAs when they discover that the new tablespace that they didn't tell me about isn't being monitored
Unfortunately you cannot do this with DPA but you can with Log and Event Manager (LEM) There is a KB for configuring Oracle auditing for LEM which you can use to be alerted for changes in tablespaces among many other things
http://knowledgebase.solarwinds.com/kb/questions/2830/Integrating+your+Oracle+database+with+SolarWinds+LEM
Very nice
Anything ever come about with this? I see the oracle performance monitor has since been taken down...
I wonder how long this will take before solarwinds starts looking into it as an actual feature. Bump I suppose.
I'm pretty sure they're just after their "maintenance renewals"...
Voted +1.
We just stood up SAM a couple weeks back. Just ran into the "problem" with the default Oracle template and the ability to check the disk space on multiple Tablespaces. Kinda bummed about this limitation.
Please
Such a limitation of OOB Solarwinds NPM/SAM. really need to be able to monitor whatever tables are returned in a query assuming this list of tables will be rather dynamic.
Always the same request for Oracle, we need more...
Customer buy SAM to have package for Oracle too, currently it is many component...
Voted & bump, it's been 7years since this request was created yet nothing was done to implement the feature. I hope this would come in soon, please make SAM for Oracle with the same capability as SAM for SQL that's all I'm asking. DPA is for performance related matters but not for monitoring Oracle DB in general.