HELP, HELP, HELP !!! Oracle 8.1.7

[JaCkyLL]

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

[davey23uk]

What OS? if Unix and 32 bit you can only use 1.75Gb of memory. What are your kernel parameters.

You cant change db_block_size, that is not allowed

Why dont you put things back to how things were before you screwed it up?

[JaCkyLL]

so dave ...

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:

open_cursors = 1300
db_block_buffers = 95000
shared_pool_size = 400000000
large_pool_size = 614400
processes = 350
log_buffer = 131072
db_block_size = 8192
sort_area_size = 5000000
sort_area_retained_size = 65536

and everything works but .... very bad !!!

[JaCkyLL]

hmmmm ....
now I know that 1.75 GB is for SGA and PGA. But how should I adjust parameters in init.ora to make work in our aplication more comfortable.

please, I'm waiting for your help

[mrchrispy]

Couple of metalink notes for you

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

[JaCkyLL]

yes...thanks ... I also found something in internet :
http://support.microsoft.com/default...roduct=win2000



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.

[JaCkyLL]

halooo, it's me again
I found some scripts on dbasupport.com and ...
script:
select parameter, gets, Getmisses , (getmisses/(gets+getmisses))*100 "miss ratio",
(1-(sum(getmisses)/ (sum(gets)+sum(getmisses))))*100 "Hit ratio"
from v$rowcache
where gets+getmisses <> 0
group by parameter, gets, getmisses ;

I have following results:

"dc_files" 2 1 33,3333333333333 66,6666666666667
"dc_free_extents" 4488 295 6,16767719004809 93,8323228099519
"dc_histogram_defs" 173260 3916 2,21023163408137 97,7897683659186
"dc_object_ids" 11658527 2022 0,0173405214454311 99,9826594785546
"dc_objects" 125661 5650 4,30276214483174 95,6972378551683
"dc_profiles" 782 1 0,127713920817369 99,8722860791826
"dc_rollback_segments" 3303 30 0,9000900090009 99,0999099909991
"dc_segments" 537724 2040 0,377942952846059 99,6220570471539
"dc_sequence_grants" 15 8 34,7826086956522 65,2173913043478
"dc_sequences" 1855 45 2,36842105263158 97,6315789473684
"dc_synonyms" 39904 291 0,723970643114815 99,2760293568852
"dc_tablespace_quotas" 63 9 12,5 87,5
"dc_tablespaces" 18143 14 0,0771052486644269 99,9228947513356
"dc_used_extents" 265 265 50 50
"dc_user_grants" 9142 39 0,424790327850997 99,575209672149
"dc_usernames" 48313 50 0,103384818973182 99,8966151810268
"dc_users" 109016 41 0,0375950191184426 99,9624049808816


it is quite good I think ... am I right ?

[robertbalmer]

This is a result for your dictionary cache. It really doesnt address your performance problems. If the end-user is unhappy these statistics represent absolutely nothing.

Do some more Oracle reading on tuning a database

[JaCkyLL]

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.

[davey23uk]

You havent done any tuning, all you did was add some memory, changed some random parameters and hoped things would go further.

Run a statspack report to see what you are waiting on, then find a DBA to help you