home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle.server      Oracle Sysadmins question their careers      44,300 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 43,039 of 44,300   
   Mladen Gogala to All   
   Re: How to increase the CPU cores allowe   
   03 Sep 17 01:55:59   
   
   From: gogala.mladen@gmail.com   
      
   On Thu, 31 Aug 2017 18:44:05 -0700, dostertag wrote:   
      
   +AD4 We have a Linux server with 48 CPUs running Oracle 12EE, but we have a   
   +AD4 licensed agreement only to use 8 cores in parallel processing.   
   +AD4   
   +AD4 Does anyone know where this limit is set within the database?  Is it a   
   +AD4 parameter or is it kept in a configuration file of some sort?  We'd like   
   +AD4 to do temporary testing with more cores with the idea of increasing our   
   +AD4 licensed limit if testing proves worth it, but we don't know where to   
   +AD4 make the parameter/config change.  We are told though that it is a   
   +AD4 setting and it can be modified.   
   +AD4   
   +AD4 Does anyone know how to change this?   
      
   The parameter is CPU+AF8-CONT, which can be modified by ALTER SYSTEM. Have   
   you checked the online documentation? There is nothing preventing you   
   from using Oracle on more than 4 CPU cores, but if Oracle audits you,   
   they will charge you for the difference. My advice would be to include   
   Oracle rep from the beginning.   
      
      
      
   --   
   Mladen Gogala   
   The Oracle Whisperer   
   http://mgogala.byethost5.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca