Sadan's Oracle dba Blog

  Top 10 queries from v$active_session_history select * from ( select SQL_ID , sum(decode(session_state,'ON CPU',1,0)) as CPU, sum(decode(session_state,'WAITING',1,0)) - sum(decode(session_state,'WAITING', decode(wait_class, 'User I/O',1,0),0)) as WAIT, sum(decode(session_state,'WAITING', decode(wait_class, 'User I/O',1,0),0)) as IO, sum(decode(session_state,'ON CPU',1,1)) as TOTAL from v$active_session_history where SQL_ID is not NULL group by sql_id order by sum(decode(session_state,'ON CPU',1,1)) desc ) where rownum <11 This query return top queries by resources consumed, you can easily return the top I/O, WAITS or CPU queries by changing the order by clause. -- Active Sessions (in ASH) including BACKGROUND processes in Last 1 Hour. SET LINESIZE 200 SET PAGESIZE 200 COLUMN sample_time FORMAT a19 COLUMN stat_name FORMAT a15 ALTER SESSION SET nls_date_format = 'yyyy-mm-dd hh24:mi:ss'...

 Sql Softwares Link https://drive.google.com/drive/folders/1essEiNdXP5XHI408t3Otjy5n2SwiWdfO?usp=sharing Windows Server Software Link https://drive.google.com/drive/folders/18eTgIdJkRX2wIoDBBGJcC3VARgGjW4w8?usp=sharing Oracle Virtual Box(Select Windows Hosts once you open the below link) https://www.virtualbox.org/wiki/Downloads Sql Server 2017 https://drive.google.com/file/d/1PIjG--Avx-OQslrGfkluGoFpRs7mz6bp/view?usp=sharing Sql Server 2019 https://drive.google.com/file/d/1Eq6BDPj9l5dM0zLL7HNzwttZLuSHQVrV/view?usp=sharing SSMS Download https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 SSMS ISO https://drive.google.com/file/d/1bxvqcbdt-hY_J5unT1FGKbZCRQXvG7dD/view?usp=sharing

  Servers configured  on lab server. Cluster Name Node Names Vip Private Ip Public Ip Scan IP Scan Name 21c RAC 21c rac01,21crac02 192.168,56,170 192.168.56.105 clu-po-atl-scan 192.168,56,170 192.168.56.106 192.168.56.107 Cluster Name Node Names Vip Private Ip Public Ip Scan IP Scan Name 12c RAC 12c rac01,12crac02 10.10.10.110 192.168.56.150 192.168.56.154 prod-scan 10.10.10.120 192.168.56.151 192.168.56.155 192.168.56.156

 https://www.perforce.com/blog/spr/oracle-native-network-encryption https://monin-it.be/how-to-activate-encryption-in-transit-in-oracle-databases-for-free/ https://questoraclecommunity.org/learn/blogs/oracle-database-network-encryption-native-vs-tls-ssl/ https://oracle-base.com/articles/misc/native-network-encryption-for-database-connections select network_service_banner from v$session_connect_info  where sid in (select distinct sid from v$mystat); Oracle Database Network Encryption

  https://infraxpertzz.com/step-by-step-oracle-grid-rac-database-upgrade-from-12-2-0-1-to-19c-in-silent-method/#google_vignette https://www.rackspace.com/blog/upgrade-oracle-grid-from-12c-to-19c https://www.luxoug.org/oracle-restart-database-upgrade-12c-to-19c-using-autoupgrade/

============================= 19C RAC INSTALATION ================================== [root@rac02 oracle]# cat /etc/selinux/config [root@rac02 oracle]# sed -i --follow-symlinks 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config [root@rac02 oracle]# cat /etc/selinux/config https://docs.google.com/document/d/15GTD9Wogr4fUg0iPnoKY2S89kbQ_h4-9HxPd2EQ1AVw/edit# Things need to select: export CV_ASSUME_DISTID=OEL7.6 https://youtu.be/-zynUdIFW6w rac01 first machine name rac02 second machine name 1 NAT. Internet purpose 2 HOSTONLY ADAPTER Public network 3.INTERNAL NETWORK Private Nerwork. 8 optios we need to select. system administrator tools devolopment tools compatability libraries remote management for linux performance Tolls KDE java platform Hardware monitoring utilitis. 6 mount points ... / 30 gb /home 5 gb swap 10 gb /boot 1 gb biosboot 1gb /u01 60 gb /u02 50 gb hostname: rac01.oracle.com rac01#] cat /etc/system-release #systemctl stop firewalld systemct...