my platform: HP-UX 64 11i (2 processor 800M, 1 G memory,mirror disk 73G) , OS block size is 8192.
My progress Rev: V8.3e (SP05)
My applications: 20 concurrent MFG/pro 9.0 users , character !
Now DB size: 4.2G , 1024 (default blocksize)
I want to now how to improve the DB performance ? I read some documents about the blocksize, they suggest: blocksize = 1 or 2 times of OS blocksize, Can I use the 8192 as my DB blocksize?
I found 1 Excel tools in PEG(by Bill Landin), but after the tabanalys cacluate : It's best to use 2048 as my DB blocksize ?
Anyone can tell me whick suggestion is right? thanks!
My progress Rev: V8.3e (SP05)
My applications: 20 concurrent MFG/pro 9.0 users , character !
Now DB size: 4.2G , 1024 (default blocksize)
I want to now how to improve the DB performance ? I read some documents about the blocksize, they suggest: blocksize = 1 or 2 times of OS blocksize, Can I use the 8192 as my DB blocksize?
I found 1 Excel tools in PEG(by Bill Landin), but after the tabanalys cacluate : It's best to use 2048 as my DB blocksize ?
Anyone can tell me whick suggestion is right? thanks!