I have an 11i Oracle applications instance running on a single node server configuration.
The server has 4 CPU and 16 GB of RAM.
I observe that, when all users are working, my database access tends to slows down considerably (which seems quite normal), however the CPU level never goes more than 40%.
I understand that this is partly because of disk access and contention, but I also ask myself whether my SGA is not large enough.
I would like to have recommendations about the following 8i database parameters:
db_block_buffers (my db_block_size=8192)
Please note that:
1. I have 16GB RAM
2. About 30 users accessing Oracle Applications forms concurrently
3. 6 concurrent requests allowed to run concurrently
Thanks in advance for your advice.