Oracle – RMAN – Clean datapump job
SELECT ‘drop table ‘ || owner_name || ‘.’ || job_name || ‘;’ FROM dba_datapump_jobs WHERE state=’NOT RUNNING’ and attached_sessions=0; exec the sql
Oracle – Using ASH to Monitor Temporary Tablespace Usage
Using ASH to Monitor Temporary Tablespace Usage To use ASH (Active Session History) to monitor temporary tablespace usage use SQL similar to the query below. Detect the space used by queries.
Oracle – Identify Locked Objects
Identify Locked Database Objects – Oracle
Oracle – 18c XE Flashback Pluggable Database Session
18c XE Flashback Pluggable Database Session
Oracle – Install Clusterware – Test udp multicast on Private Interconnect (and get maximum MTU)
Test Multicast on Private Interconnect (and get maximum MTU) There are several ways to test multicast communication using udp. I was debugging an oracle Clusterware installation – the clusterware on the second node would not…
Oracle – Monitor TEMP Tablespace
Monitor TEMP Tablespace with a DBMS_SCHEDULER job I was faced with a situation in which a process (Oracle pl/sql procedure within a package, scheduled outside Oracle in the evenings) was exhausting the TEMP tablespace. In…
Oracle – Automatic Workload Respository AWR
AWR, Automatic Workload Respository The Oracle AWR, Automatic Workload Respository, is tored in the SYSAUX tablespace. This post conatians information useful for purging/cleaning the AWR when it becomes large due to failure of cleanup jobs…
Linux – Oracle – Display Environment Variables Associated to a Process
Find the process id – Example : Oracle Listener Display the Environment Variables