What server 9.2.0 read?

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 Fri May 23 2003 - 02:11:47 CDT