Re: HELP! 8i performance Weirdness

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 9 Jan 2001 19:18:58 -0000
Message-ID: <979068269.22040.0.nnrp-10.9e984b29@news.demon.co.uk>

can you get any connection (e.g. running sqlplus on the servers) whilst this happens, and run:

select * from v$session_wait;

to see if that gives you any clues - look first for STATE = 'WAITING' and see what the
EVENT is.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



ran wrote in message <93djvo$ii0$1_at_nntp9.atl.mindspring.net>...


>I have 3 Solaris machines with the same problem. When connecting via MTS

>(multi threaded server) the data base will "hang" for 61.5 seconds then

>continue normally! This happens with JBDC and OCI drivers. Has anyone seen

>this? I happens on all three systems. It appears to be independent of

 system


>load and is within a few milliseconds of 61.5 every time.

>

>Any help is greatly appreciated.

>

>RP

Received on Tue Jan 09 2001 - 13:18:58 CST