Stats$idle_event

How am I going to solve this ? Up to 10R1 a table PERFSTAT.STATS$IDLE_EVENT is created within the PERFSTAT schema containing names of all idle events. This can be used only get the true wait events out of STATS$SYSTEM_EVENT by doing a ‘WHERE EVENT NOT IN STATS$IDLE_EVENT’. In 10R2 this table is gone, this is because the information can be retrieved by filtering on the a column: WAIT_CLASS’Idle’.

It’s easy to create an extra view in the PERFSTAT schema:

CREATE OR REPLACE VIEW perfstat.STATS$IDLE_EVENT
AS
   SELECT event
   FROM   v$event_name
   WHERE  wait_class = 'Idle'

But how am I going to put this in the create scripts without having to maintain seperate ones for both 10R1 and 10R2 ? Don’t know yet, maybe I have to make two 10g create scripts.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: