AnySQL (d.c.b.a) wrote:
> 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.
I'd suggest you get a copy of Orale Insights Tales of the Oak Table
with respect to querying some of the Oracle information you seem to
be going after.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sat Sep 24 2005 - 14:26:13 CDT
