I observed, while selecting oracle related counters/parameter(say V$SESSSTAT or V$RSRC_SESSION_INFO), the counters shows SID="<value>".
For session, which will start after running the schedule, a unique SID will be generated and based on same the results, Resources must be obtained but we found that the results were based on SID selected
initially (Add/remove Performance Counters>Resource Monitoring Counters).
I would like to know how RPT is capturing SID="<value>" during selection of Resource monitoring data source. Any inputs on the correct procedure on how to retrieve the oracle counters data and interpret these counter data in RPT reports ?
Thanks in advance