All Apps and Add-ons

Can I tie Oracle DBID to Oracle Instance name?

New Member

The Oracle audit records include the DBID, but not the instance name. Is there any way to include the instance name on a report instead of the DBID?

0 Karma


The instance name is available in the v$instance table. I would recommend creating a view with the instance name either hard-coded or joined from v$instance as a separate column along with the audit data columns. Then have Splunk select from your view instead of the audit trail table or view.

0 Karma