Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Processes Stalling Problem

Re: Oracle Processes Stalling Problem

From: Jean-Claude Matarazzo <jcmata_at_club-internet.fr>
Date: Fri, 29 Jan 1999 23:19:31 +0100
Message-ID: <36B233F3.E5EF7735@club-internet.fr>


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 Fri Jan 29 1999 - 16:19:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US