Re: Access v$system_event so slowly.

AnySQL, first with and without the hints the query runs in about 28/100 of a second to return 328 rows on my system.

Second, querying some of the v$ dynamic performance views is a latch intensive operation so I suggest you only query any v$ view only when necessary rather than set up anything that runs all the time. With version 10g Oracle already keeps tabs on much of the most important data in the v$ views for you so make sure anything you are working on serves a real need and will not be soon obsoleted by an upgrade if you are on a lower version than 10g.

HTH -- Mark D Powell -- Received on Wed Sep 21 2005 - 09:25:01 CDT