Title: | DEC Rdb against the World |
Moderator: | HERON::GODFRIND |
Created: | Fri Jun 12 1987 |
Last Modified: | Thu Feb 23 1995 |
Last Successful Update: | Fri Jun 06 1997 |
Number of topics: | 1348 |
Total number of notes: | 5438 |
I have a question for ORACLE's memory usage. Our customer uses 100% of CPU on VAX6610 and 8-9 process is waiting CPU. I heard ORACLE uses many memory in order to make I/O fast. Anyone has ORACLE memory guideline or recommendation for SYSGEN PARAMETER about buffering ? regards, Tatsukawa/Sales support for Mutinational Busienss Sales division in Japan.
T.R | Title | User | Personal Name | Date | Lines |
---|---|---|---|---|---|
1198.1 | try VPA, SPM, DECPS | TRCOA::MCMULLEN | Ken McMullen | Tue Oct 13 1992 20:55 | 15 |
TATSUKAWA, Are those 8-9 processes waiting in a COM state? If so you most likely need more CPU power. What is the CPU doing: paging, swapping, application I/O, compute bound, are there disk channel/drive I/O queues, is there any free memory (if get more)? Do you have a local capacity planning expert? A CPU that is 100% used is not the best practical way to run a system. The last time I saw ORACLE manuals, they did have some guidelines for setting SYSGEN PARAMETERS on VMS. regards, Ken |