[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ulysse::rdb_vms_competition

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

1198.0. "Q: Memory usage of OARCLE?" by TKOV51::TATSUKAWA () Mon Oct 12 1992 09:01

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.RTitleUserPersonal
Name
DateLines
1198.1try VPA, SPM, DECPSTRCOA::MCMULLENKen McMullenTue Oct 13 1992 20:5515
    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