Re: Why query v$latch is unusual slow?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 15 Sep 2000 12:17:04 +0200
Message-ID: <969014378.23226.4.pluto.d4ee154e@news.demon.nl>

Forget about it.
How often do you query v$latch? Daily?
all v$ views represent *virtual* views on memory structures, provided by Oracle. You can't do anything except log an ITAR on this issue, and they will probably get back to you with the message, it will be resolved in the next version.

Regards,

Sybrand Bakker, Oracle DBA

"Chuan Zhang" <chuan_at_asiaonline.net> wrote in message news:IXiw5.5$6c1.887914_at_news.interact.net.au...
> Dear all,
>
> Does anyone happen to know the following "problem"?
>
> On our production, everything as I know is running ok. But when I used
> "utlbstat/utlestat", the query "select count(*) from v$latch or select *
> from v$latch" is unusual slow. V$latch only has 80 rows. This only happen
> to v$latch. It's out of my knowledge about Oracle.
>
> Could anyone tell me how to figure out this problem?
>
> Many thanks,
>
> Chuan
>
>
>
Received on Fri Sep 15 2000 - 05:17:04 CDT