Steps to increase the size of SGA memory in Oracle Check the SGA parameter which show the size of SGA allocated in Oracle SQL> show parameter sga_ NAME TYPE VALUE …
-
-
Configure SSH keys connectivity for RAC Environment Oracle Install the yum package. (Run on both nodes) yum install openssh-server Start the SSH service. (Run on both nodes) service sshd start …
-
Cause: An attempt was made to create a common user or role with a name that was not valid for common users or roles. Error: While creating a user in the …
-
OraclePerformance Tuning
Check the number of CPU & cores with SQL statement in Oracle
by tuanlpby tuanlpCheck the count of CPU count with SQL in Oracle SQL> SELECT value CPU_COUNT FROM v$system_parameter2 WHERE LOWER(name) = ‘cpu_count’; CPU_COUNT ———— 8 Check the count of CPU present with …
-
OraclePerformance Tuning
Count the number of sessions from the application in Oracle
by tuanlpby tuanlpCheck which application cause more number of sessions and processes in Oracle —Check the count of session for particular applications SELECT s.program,count(*) “noofsessions” from v$session s group by s.program; –Check …
-
OraclePerformance TuningTroubleshoot
Check maximum utilization of open cursor in Oracle
by tuanlpby tuanlpFor error: ORA-01000: maximum open cursors exceeded ORA-00604: error occurred at recursive SQL level 1 Check the session which causes the issue: select a.value, s.username, s.sid, s.serial# from v$sesstat a, …
-
Monitor and manage the Memory Usage of PDBs databases in Oracle. Check the memory usage of PDB databases COLUMN PDB_NAME FORMAT A10 SELECT r.CON_ID, p.PDB_NAME, r.SGA_BYTES, r.PGA_BYTES, r.BUFFER_CACHE_BYTES, r.SHARED_POOL_BYTES FROM …
-
Find the uncommitted or incomplete transaction in Oracle Query with V$transaction give result which transaction is not commited yet. set lines 250 column start_time format a20 column sid format 999 …