Re: Access v$system_event so slowly.

From: AnySQL (d.c.b.a) <anysql_at_gmail.com>
Date: 21 Sep 2005 20:43:27 -0700
Message-ID: <1127360607.354525.62180@g14g2000cwa.googlegroups.com>

Mark D Powell wrote:
> 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 --

How ever, when access v$sysstat, v$sql, v$latch, all of these are very quickly.

I know we have no way to get it faster because event access the base table x$kslei, it's still very slow here, we have about 4000 concurrent sessions. Received on Wed Sep 21 2005 - 22:43:27 CDT