Database - RAC/Scalability (MOSC)

MOSC Banner

gv$service_stats data - any way to clear before a change

edited Mar 16, 2019 12:26PM in Database - RAC/Scalability (MOSC) 5 commentsAnswered

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center