Abdul Hafeez Kalsekar -- Oracle database tuning case studies

Have  documented earlier  steps for TDE in below Blog    however  in this Blog we  will document steps for configuring TDE   on  OKV https://abdul-hafeez-kalsekar.blogspot.com/2024/03/tde-and-tls-encryption-for-oracle.html   Steps of  moving TDE  to  OKV  [oracle@okvcli oracle]$ mkdir -vp ${WALLET_DIR}/okv [oracle@okvcli bin]$ export JAVA_HOME=/u01/app/oracle/product/21.0.0/dbhome_1/jdk [oracle@okvcli bin]$ echo "export JAVA_HOME=/u01/app/oracle/product/21.0.0/dbhome_1/jdk" >> $HOME/.bashrc   [oracle@okvcli oracle]$ mkdir /u01/app/oracle/okvapi [oracle@okvcli oracle]$ cd okvapi/ [oracle@okvcli okvapi]$ curl -O -k https://172.168.0.41:5695/okvrestclipackage.zip   % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current                                ...

col username for a12 col module for a10 trunc col state for a20 col "QC SID" for A6 col SID for a10 col "QC/Slave" for A10 col "ReqDOP" for 999 col "ActDOP" for 999 col "slave set" for  A10 col event for a25 trunc col action for a20 trunc col p1text for a20 trunc col secwait for 99999 col state for a10 trunc col object for a25 trunc col command for a15 trunc set pages 300  lines 300 select      s.inst_id,      decode(px.qcinst_id,NULL,s.username,            ' - '||lower(substr(s.program,length(s.program)-4,4) ) ) "Username",      decode(px.qcinst_id,NULL, 'QC', '(Slave)') "QC/Slave" ,      to_char( px.server_set) "Slave Set",      to_char(s.sid) "SID",      decode(px.qcinst_id, NULL ,to_char(s.sid) ,px.qcsid) "QC SID",      px.req_degree "Requested DOP",     px.degree "Actual DOP",s.module,s.sql_id,s.event,s.status   from   ...

oracle script to  list database parameter difference between 4 rac instances SELECT p1.inst_id AS instance_id_1,        p2.inst_id AS instance_id_2,        p1.name AS parameter_name,        p1.value AS value_instance_1,        p2.value AS value_instance_2 FROM gv$parameter p1 JOIN gv$parameter p2 ON p1.name = p2.name AND p1.inst_id != p2.inst_id WHERE p1.value != p2.value ORDER BY p1.name, p1.inst_id, p2.inst_id; SELECT parameter_name,        COUNT(DISTINCT parameter_value) AS distinct_value_count,        LISTAGG(instance_id || ': ' || parameter_value, ', ') WITHIN GROUP (ORDER BY instance_id) AS values_per_instance FROM (     SELECT p.inst_id AS instance_id,            p.name AS parameter_name,            p.value AS parameter_value     FROM gv$parameter p     WHERE p.inst_id...