Re: What server 9.2.0 read?

"Vadim Migunov" <migunov_at_radico.ru> wrote in message news:<1053673725.73903_at_basic.maxnet.ru>...
> Hi, All!
>
> I have two servers 8.1.7 and 9.2.0 for Win 2000. I try to
> execute query
> select * from v$lock, v$session
>
> For 8.1.7 time 16 sec, For 9.2.0 execute is continuing more 1 hour. What's
> wring? I know server 9.2.0 read many bloÓks. If I do
>
> select l.sid from v$lock l, v$session s where l.sid = s.sid - 90 sec and db
> block gets = 124992(!!!!), but for 8.1.7 db block gets = 0. What and What
> for server 9/02 read? What to do to turn? I've done it on two servers 9.2.0,
> but result is the same.
>
> I can't get idea.
>
> If you know tell me, please.

That's well known bug in Oracle 9.2. If you want to access v$lock, you should use /*+ordered */ hint. After that you'll get results in fraction of time.

Dusan Bolek Received on Fri May 23 2003 - 07:50:20 CDT