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