hello
I have "the small" problem with the base in oracle 8 version. We had on our server installed 2 GB RAM and init.ora parameters are:
db_block_buffers = 95000
shared_pool_size = 400000000
open_cursors = 1300
processes = 350
area_size sort = 5000000

Total area of the memory: 1199564828 bytes
fixed: 75804
variable: 42110976
database: 778240000

We have added RAM up today and we have 4 GB now.
First I increased the shared_pool parameter. The application, is operating more slowly effects of the change are terrible. When I changed shared_pool parameters much and db_block_size even the instance didn't want to start:
ORA-27102: out of memory
When I reduced a little bit both parameters the error appeared:
ORA-00443: PRMON didnt take-off
When I still more reduced both parameters the instance gets up however users aren't able to do nothing , aplication works very slowly and the attempt at logging sometimes ends in information:
ORA-12500: TNS. the process of the monitoring didn't manage to start the dedicated process of the server

Perhaps somebody from you will help me in the question of the configuration of these parameters. The matter is urgent.
Thanks very much !!! by, by