Enable metrics (e.g. Total Parse Count) for DBA_HIST_SESSMETRIC_HISTORY
699693May 4 2009 — edited Feb 15 2011Hi,
We are changing our application to improve the performance of accessing Oracle database. We expect the parse count to be reduced as a result of the tuning project. But in the benchmark testing, we see no remarkable improvement of performance. So I want to do some analysis to Oracle metrics to find out the reason.
We have many test cases running for several hours. I want to get such information like how many total/hard parses for given time period (I hope the granularity of the sample time for the metrics to be about 1 minutes).
It looks like DBA_HIST_SESSMETRIC_HISTORY can provide the information I need. But I find in this view, there are only one metrics collected (Blocked User Session Count). Does anybody knows how to enable other session metrics like Total Parse Count (Session), Hard Parse Count (Session) etc for DBA_HIST_SESSMETRIC_HISTORY?
Many thanks.