Re: statpack feedback

Hi guys,
thanks for all your help. Ron, It just confirms what I was telling my developers but they continue to argue with me on the sql.

VC,thanks how can i further investigate "7.5% of your transactions were aborted"

Mladen, thanks how can i further investigate this enqueue issue.

More info:
Total System Global Area 1171832992 bytes

Fixed Size                    73888 bytes
Variable Size             751656960 bytes
Database Buffers          409600000 bytes
Redo Buffers               10502144 bytes

OLTP some batch environment and about 130 to 140 users.

Mladen Gogala <gogala_at_sbcglobal.net> wrote in message news:<pan.2004.07.18.07.27.25.261573_at_sbcglobal.net>...
> 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?
Received on Mon Jul 19 2004 - 09:47:09 CDT