Increase Oracle Process

-

Increase Oracle Process 


select 

  resource_name, 

  current_utilization, 

  max_utilization, 

  limit_value 

from v$resource_limit 

where resource_name in ('sessions', 'processes');



editing


RESOURCE_NAME

--------------------------------------------------------------------------------

CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALUE

------------------- --------------- ------------------------------

processes

                106             117        350


sessions

                113             135        548





alter system set processes=750 scope=spfile; 

alter system set sessions=1152 scope=spfile;

shutdown immediate 

startup


RESOURCE_NAME

--------------------------------------------------------------------------------

CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALUE

------------------- --------------- ------------------------------

processes

                137             160        750


sessions

                138             195       1152


Comments

Post a Comment

Popular posts from this blog

Crypto Domains

-
Image
Building decentralized digital identities for the world Use blockchain domains as your: Universal username across apps and websites Website URL Payment address for wallets and much more! Register :  https://unstoppabledomains.com/r/mohinders To send cryptocurrency,  all you need to know is the recipient’s blockchain domain Send bitcoin, ethereum, and any other cryptocurrency  with just one domain No more worrying about sending to the wrong address Replace cryptocurrency addresses with a human readable name To send cryptocurrency,  all you need to know is the recipient’s blockchain domain Send bitcoin, ethereum, and any other cryptocurrency  with just one domain No more worrying about sending to the wrong address
Read more
-
IPFS powers the Distributed Web A peer-to-peer hypermedia protocol designed to preserve and grow humanity's knowledge by making the web upgradeable, resilient, and more open. The web of tomorrow needs IPFS today IPFS aims to surpass HTTP in order to build a better web for all of us. Today's web is inefficient and expensive HTTP downloads files from one server at a time — but peer-to-peer IPFS retrieves pieces from multiple nodes at once, enabling substantial bandwidth savings. With  up to 60% savings for video,  IPFS makes it possible to efficiently distribute high volumes of data without duplication. Today's web can't preserve humanity's history The average lifespan of a web page is 100 days  before it's gone forever. The medium of our era shouldn't be this fragile. IPFS makes it simple to set up resilient networks for mirroring data, and thanks to content addressing, files stored using IPFS are automatically versioned. Today's web is centralized, limit...
Read more