Dear jlakhani, 15th April 2001 15:11 hrs chennai

I would like to know the DB size and nature of DB activity etc.

As DBAtrix has said there is much can be done with the prameters you have provided.

The only thing you can do is using NOLOGGING options for some transactions.

Cheers

Padmam