# How to monitor core usage metrics on Oracle 19c when multiple SIDs on a host **URL:** \ **Category:** Beats\ **Tags:** docker, metricbeat\ **Created:** [March 30, 2023, 3:44pm UTC](https://discuss.elastic.co/t/how-to-monitor-core-usage-metrics-on-oracle-19c-when-multiple-sids-on-a-host/328957 "2023-03-30T15:44:38Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![James\_Whittington](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/james_whittington/32/118075_2.png) [@James\_Whittington](https://discuss.elastic.co/u/James_Whittington)\ **Post date:** [March 30, 2023, 3:44pm UTC](https://discuss.elastic.co/t/how-to-monitor-core-usage-metrics-on-oracle-19c-when-multiple-sids-on-a-host/328957/1 "2023-03-30T15:44:38Z")
I have a delima on how to approach monitoring some key usage based metrics on a Oracle Database server where multiple SIDs reside. We use elastic cloud, version at 8.6, currently just using fleet managed elastic agents. There is an Oracle integration however those docs state environment variables must be in place for Oracle SID and Oracle Home which seems to indicate they are expecting 1 SID to be in use per host. Oracle integration seems to rely on instaclient libraries as well. Also see metricbeat has a sql feature where you can run a query against a database Was wondering if I could just create a docker image with both Oracle instaclient and either metricbeat or elastic agent and create a monitoring instance per monitored SID. Really just interested in things like tablespace so it might be easier to just write something to do that but curious how others may have approached the issue. ---
**Author:** ![Agi\_K\_Thomas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/agi_k_thomas/32/130842_2.png) [@Agi\_K\_Thomas](https://discuss.elastic.co/u/Agi_K_Thomas)\ **Post date:** [April 19, 2023, 4:41pm UTC](https://discuss.elastic.co/t/how-to-monitor-core-usage-metrics-on-oracle-19c-when-multiple-sids-on-a-host/328957/2 "2023-04-19T16:41:14Z")
It is not mandatory that you have to set the environment variable ORACLE\_SID. The latest version of Oracle integration supports additional Oracle DSN formats, using which you can connect to multiple databases ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [May 17, 2023, 6:41pm UTC](https://discuss.elastic.co/t/how-to-monitor-core-usage-metrics-on-oracle-19c-when-multiple-sids-on-a-host/328957/3 "2023-05-17T18:41:38Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.