foalabs

Standard Value to set SGA and PGA Memory in Oracle Setting the appropriate values for SGA (System Global Area) and PGA (Program Global Area) is crucial for optimizing Oracle database performance. If you have 64 GB of total memory available on your server, you need to allocate memory to SGA and PGA wisely to balance between database cache, session management, and overall performance. Below are some guidelines for setting SGA and PGA values: Recommended Allocation Strategy For a server with 64 GB of total memory, consider the following strategy: SGA and PGA Distribution: Typically, allocate about 60-70% of the total memory to Oracle, leaving some for the OS and other processes. For example, if using 60% of 64 GB , then about 38 GB can be allocated to Oracle memory (SGA + PGA). SGA and PGA Breakdown: SGA (System Global Area) : Allocate about 75-80% of Oracle's allocated memory. PGA (Program Global Area) : Allocate about 20-25% of Oracle's allocated memory. Memory Settings Calc...

How to Check the Usage of SGA in Oracle Check the Usage of SGA select round(used.bytes /1024/1024 ,2) used_mb , round(free.bytes /1024/1024 ,2) free_mb , round(tot.bytes /1024/1024 ,2) total_mb from (select sum(bytes) bytes from v$sgastat where name != 'free memory') used , (select sum(bytes) bytes from v$sgastat where name = 'free memory') free , (select sum(bytes) bytes from v$sgastat) tot ; Find the Total Size of SGA SELECT sum(value)/1024/1024 "TOTAL SGA (MB)" FROM v$sga; Check size of different pool in SGA Select POOL, Round(bytes/1024/1024,0) Free_Memory_In_MB From V$sgastat Where Name Like '%free memory%'; Please do like and subscribe to my youtube channel: https://www.youtube.com/@foalabs If you like this post please follow,share and comment

Fail to Start Global Heartbeat for OCFS2 Cluster: o2cb: heartbeat region could not be found region UUID Error: When starting the OCFS2 cluster service, a "region could not found" error is shown: # /sbin/o2cb.init online checking debugfs... Setting cluster stack "o2cb": OK Registering O2CB cluster "cluster-name": OK Setting O2CB cluster timeouts : OK Starting global heartbeat for cluster "cluster-name": Failed o2cb: Heartbeat region could not be found XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX Stopping global heartbeat on cluster "cluster-name": OK Solution 1) List the available OCFS2 volumes and select one as the Global Heartbeat # mounted.ocfs2 -d Device Stack Cluster F UUID Label /dev/sdX o2cb cls G XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX lab-1 /dev/sdY o2cb cls G YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY lab-2 2) Edit the file /etc/ocfs2/cluster.conf and change the region to the new UUID (Ex: YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY).  region =YYYYYYYYYYYYYYYYYYYYYYYY...