Re: Why query v$latch is unusual slow?

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Mon, 18 Sep 2000 16:29:46 GMT
Message-ID: <39c64293.401301831@nsw.nnrp.telstra.net>

Hello Chuan,

Have a look at the top of the Ixora Q&A page on "Latches" at http://www.ixora.com.au/q+a/latches.htm.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
@
@ Going to OpenWorld?
@ Catch the Ixora performance tuning seminar too!
@ See http://www.ixora.com.au/seminars/ for details.

-----Original Message-----
From: "Chuan Zhang" <chuan_at_asiaonline.net>

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 Mon Sep 18 2000 - 11:29:46 CDT