Xref: alice comp.databases.oracle.misc:25670
Path: alice!news-feed.fnsi.net!oleane!news-raspail.gip.net!news-lond.gip.net!news.gsl.net!gip.net!dispose.news.demon.net!demon!news.demon.co.uk!demon!firewall.tertio.com!not-for-mail
From: Robert Pritchard <robert_pritchard@tertio.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Oracle Processes Stalling Problem
Date: Tue, 02 Feb 1999 18:00:49 +0000
Message-ID: <36B73D51.826F0AAB@tertio.com>
References: <36AF228E.20B40FC8@tertio.com> <36AF8EF6.9B5281EE@club-internet.fr> <36B040DB.1249F205@tertio.com> <36B233F3.E5EF7735@club-internet.fr>
X-Trace: news.demon.co.uk 917978365 nnrp-03:17114 NO-IDENT firewall.tertio.com:194.217.240.22
X-Complaints-To: abuse@demon.net
X-Mailer: Mozilla 4.06 [en] (WinNT; I)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 31

I will try this, althought o cvlarify, do you recommend running the first
script whilst the system is functioning normally and the second once it has
stalled, or run them both periodically during the time the system is running?

Cheers
Rob


Jean-Claude Matarazzo wrote:

> Have you use the UTLBSTAT.SQL  and UTLESTAT.SQL ?
>
> Theses scripts take an image of the database activity between 2 moments :
>
> CONNECT SYS/xxxx
>
> @UTLBSTAT.SQL
>
> You run yours transactions
>
> @UTLESTAT.SQL
>
> A file REPORT.TXT would be generated.
> There is a lot of informations, you have to read it.
> Search a problem of contention, perhaps process wait on a resource of the
> database.
>
> Good luck.
>
> >