Database cache percentage
2000-01-10 16:10:11
I've got a database cache problem. My cache hit percentage is way too
low -
Page Size (bytes): 4,096
Total Usable Pages: 7,827,456
Used Pages: 6,047,439
Pct Util: 77.3
Max. Pct Util: 77.7
Physical Volumes: 12
Buffer Pool Pages: 32,768
Total Buffer Requests: 1,033,521,610
Cache Hit Pct.: 79.88
Cache Wait Pct.: 0.00
Backup in Progress?: No
The dsmserv.opt file has the following -
BUFPoolsize 131072
The bufpoolsize was set months ago. Are there changes I can make to get
the percentage in the 99% range? The server level is 3.1.2.40 running
on AIX 4.3.2 with 2 gb's of main memory.
Thanks.
--
Cordially,
Cordially,
Bill Zehnder
ITCC
972-431-8733 Fax 972-531-8733
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Database cache percentage,
William R Zehnder <=
- Re: Database cache percentage, Laura G. Buckley
- Re: Database cache percentage, Keith A. Crabb
- Re: Database cache percentage, Laura G. Buckley
- Re: Database cache percentage, Russell Street
- Re: Database cache percentage, Sheelagh Treweek
- Re: Database cache percentage, Mauro M. TINELLI
- Re: Database cache percentage, Joshua S. Bassi
- Re: Database cache percentage, Phil Scarr
- Re: Database cache percentage, Joshua S. Bassi
- Re: Database cache percentage, Richard Sims
|
|
|