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
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
now I turned back all parameters and oracle works, but very very slowly , all users are very irritated.
My OS is MS Windows 2000 server - I think that in this version it can easy use 4 GB of ram memory. Server has 5 GB ( in BIOS is 5 ), but system can use only 4 GB.
my parameters are now:
Note.156797.1 - What Is The Maximum Memory (RAM) Size Oracle Can Use on MS Windows 2000
Note.225349.1 - Implementing Address Windowing Extensions (AWE) or VLM on Windows Platforms
Note.231159.1 - How to configure Windows to improve performance database oracle
Note.46001.1 - Oracle Database and the Windows NT memory architecture.
Note:46053.1 - Windows NT Memory Architecture Overview
Note:1036312.6 - Utilizing Up to 3GB Virtual Memory on Windows NT
but more interesting for me is how to change parameters on my oracle for his better work. maybe I should change shared_pool_size, or db_block_buffers ???
The seller of my aplications says that this parameters should be changed. But how ... now is:
db_block_buffers = 95000
sharedPool_size = 400000000
If I change this oracle and aplications works badly.
halooo, it's me again
I found some scripts on dbasupport.com and ...
select parameter, gets, Getmisses , (getmisses/(gets+getmisses))*100 "miss ratio",
(1-(sum(getmisses)/ (sum(gets)+sum(getmisses))))*100 "Hit ratio"
where gets+getmisses <> 0
group by parameter, gets, getmisses ;
ok, so where I can find some interesting things about tuning database ?? You think that after tuning my database should work much better.
Somebody told me that perhaps I have to do export and then import of the data. Perhaps this operation help me - defragmentation or something like that.