Setting the filesystem with Oracle

[RogerVI]

Hi,
I have Oracle 8.1.7 32 bits running in HP-UX 11i V1 64 bits.
The system uses cooked files.
I don't have Online JFS, then I cannot set minchache and convosync options in the filesystem. This means that I use double buffering.
I notice that when running some queries, the performance is slow (the reads are slow).

The following kernel parameters are configured:

dbc_min_pct = 10
dbc_max_pct = 10

(Total physical memory = 12 GB)

My question is:
Do you recommend rise the value of that parameters ?
Please, provide any clues according your experience.
Thanks in advance

Peternt

[Steven E. Protter]

Shalom,

I think you have set the parameters just right.

I ran oracle databases on 11.11 systems for a number of years as System Administrator. While not my exact parameter settings, you look good.

On 11.11 Oracle 8.17 which is way out of support will not benefit from increasing the buffer pool, which those two parameters control.

To tune Oracle increase the SGA. Talk to your database administrators about that.

SEP

[Shibin_2]

Hi Peternt,

There is a similar discussion in this forum. You may read this:

http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=230807

Btw, if you can increase the dbc_max_pct value to some 30 will be good. Default value is 50.

[RogerVI]

Thanks