Re: Please help with performance problem

From: Muli Koppel <mkoppel_at_barakitc.co.il>
Date: 1997/11/23
Message-ID: <3477DF09.B2604315@barakitc.co.il>#1/1

Gina,

You didn't mention your db_block_buffers parameter. It has a great significance as well.
If you are doing mass deletes, do notforget to rebuild the indexes, otherwise you'll have performance problems.
If you are running your database under ARCHIVELOG pay a special attention to the seperation of redologs from the archive logs disks.
Check the number of extents of your table and your table's indexes. if there are more than five extents - rebuild the object.
shared_pool_size is a bit low. try increasing it to 30m

and there's much more.

Yours,

Muli Koppel Received on Sun Nov 23 1997 - 00:00:00 CST