Small addition

From: Vsevolod Afanassiev <vafanassiev_at_aapt.com.au>
Date: 4 Feb 2003 23:21:39 -0800
Message-ID: <4f7d504c.0302042321.2251719b@posting.google.com>

Additions:
1. I increased JAVA_POOL_SIZE to 100 MB, SHARED_POOL_SIZE to 160 MB, DB_BUFFERS to 30,000 - this had no effect. 2. I monitored session that was doing 'alter java class ... resolve' via V$SESSION_EVENT - it had small number of following waits

undo segment extension
log buffer space
log file switch completion
log file sync

I created two large (500 MB) rollback segments without OPTIMAL and took existing rollback segments offline. I also increased the number of online redo groups to 9 and size of online redo logs to 50M, and LOG_BUFFER to 1.6 MB. This led to a small improvement...

Main wait events are

SQL*Net message to client
SQL*Net message from client

Why??? Received on Wed Feb 05 2003 - 01:21:39 CST