gv$service_stats data - any way to clear before a change
Hello community,
I have an 11.2.0.4 RAC database running a service pinned to a single instance and I would like to spread service that across all instances instead. I would like to monitor wait events before and after with this query:
select inst_id, service_name, stat_name, value from gv$service_stats where service_name='&statname' and value > 0 order by value desc;
I was wondering if there is any way to clear out the statistics for this service alone before I make any changes. I see in the RAC admin and deployment guide that DBMS_MONITOR is used to setup gathering data on services but I don't see a way to clear out or initialize that data again. Does anyone know of a way to clear this before making changes?