Dear Fellowship of the TOAD,
I used custom charts in the AWR/Statspack Browser a lot, now recently I ran the browser in a RAC environment, where there's more than one value for a metric for a given snapshot. In fact, it's one value per instance. Now I need to find out how to adapt my charts to still make sense in a RAC.
TOAD's own charts are aware of the instance id. You can choose the instance from a drop-down list at the top of the browser window and then the chart data is queried only for the chosen instance number. TOAD's very own SQL Tracker shows that the predicate "AND instance_number = <n>" is added to the query, so there should be an according placeholder defined somewhere.
But, there seems to be no documentation of the custom chart feature aside from the short hints in the dialog windows. And these only mention "&Snapshotlist" as a placeholder for the snapshots. What I need is a **placeholder like "&Instance_number"**- so I fiddled around a bit with guesswork, but to no avail.
Does anyone here know about such a variable/placeholder?