Re: statpack feedback

On Fri, 16 Jul 2004 11:05:21 -0700, Azar wrote:

> Hi guys,
> I am pasting a copy of a statspack report. Just need some feedback on
> what you all see in it.

The only thing that deserves the 2nd look is this wait:

enqueue                                 2          1         372  

You had two waits, 1 timed out, and the total waiting time for two locks was almost 4 seconds, which means almost 2 seconds per wait. Either somebody is locking many records simultaneously (select for update, Forms application that uses default blocks) or something substantial is being done before a commit issued (PL/SQL, 3GL). If the application needs high concurrency, that might become a problem. It would be much easier to tell if you told us what is the purpose of the database? Is it DW, OLTP or something else?

-- 
A city is a large community where people are lonesome together.