Oracle Database

Created by Kristaps Felzenbergs, Modified on Mon, 4 Dec, 2023 at 12:20 PM by Kristaps Felzenbergs

Please contact sales@codenotary.com to receive information about the Metrics & Logs Oracle Feature Pack. You will receive a feature patch that needs to be applied.


Add your Oracle Databases

  • The SID is used to connect to the database server. It is commonly of the format hostname/servicename, using the hostname where the database is running, and the service name of the Oracle Database instance. The dsn (data source name) is the TNS entry (from the Oracle names server or tnsnames.ora file). So Performance Analyzer connects to the host with the name (or ip) hostname, this host serves the database with the name servicename.

  • You can specify a custom TCP port for the connection with the syntax hostname:port/servicename

  • The User needs Select-Privileges for the following dynamic Views: 

    gv$instance , gv$containers, gv$database , gv$sysstat , gv$con_sysstat , gv$waitclassmetric , gv$system_wait_class , gv$sysmetric , gv$parameter , gv$con_sysmetric , gv$eventmetric , gv$event_name, gv$sql 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article