How to fetch Query wait state information while creating a dashboard

[Biswajit.Mohanty]

Hi,

I am creating a dashboard with various database metrics like Time Spent in Database and Executions, Average Number of Active Connections, Query Wait States, etc.

I am able to see "Query Wait States" in the Database Dashboard section but when I am trying to create a dashboard, I am not able to find the metrics "Query Wait States".

Can someone please suggest how to fetch "Query Wait States" metrics information?

Thanks,

Biswajit

[Nawaz Ali.Mohammad]

 Query wait state is of type event data, we can only create a dashboard for the metric data type, which is data under "metric browser" in UI. There has been a feature request already in place for event data to be part of the dashboard and alert which could address this scenario as well.