| 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 17: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
 | |||||