Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What server 9.2.0 read?
Many thanks to all
"Vadim Migunov" <migunov_at_radico.ru> сообщил/сообщила в новостях следующее:
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.
>
>
>
>
>
Received on Tue May 27 2003 - 01:36:23 CDT