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 …
-
Check 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 …
-
Check 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 …
-
For 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 …
-
Script of Logon Trigger for restrict the access of application with Oracle User. AS an example, following script show the restrict of SQLPLUS.EXE application to access for normal user. I …
-
Supplemental logging is generate or add extra logging information for the change data capture process which is used for capturing the changes like insert/update/delete operation with unique identified a row …
-
Find the Session/ program / module / SQL Query using high temp tablespace usages Find the session using high temporary tablespace: col inst_id format 999 col sid format 99999 col …