Re: Oracle Processes Stalling Problem

From: Robert Pritchard <robert_pritchard_at_tertio.com>
Date: Tue, 02 Feb 1999 18:00:49 +0000
Message-ID: <36B73D51.826F0AAB@tertio.com>

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.
>
> >
Received on Tue Feb 02 1999 - 12:00:49 CST