SQL select * from v$asm_diskgroup order by free_mb asmcmd asmcmd lsdg|awk ‘{sub(/\//,””,$14);print}’|tr -dc ‘[:print:]\n’|awk -v date=”$(date +”%Y-%m-%d %r”)” ‘{print $14 “\t\t” $9″\t\t”$8″ : ” date}’|sort -k 2 -n

Also see: Troubleshoot high cpu usage – Java Thread OVM Manager consists of a MySQL database and a Weblogic Server. I have found that the cpu usage is at nearly 100% on the OVMM Linux… 

Find username, db_name etc. from sqlplus session select sys_context (‘USERENV’, ‘SESSION_USER’) from dual; select sys_context (‘USERENV’, ‘DB_NAME’) from dual;

See article by Mike Dietrich: Security change in Oracle Database 12.2 with login.sql

PDB Local Undo Flashback PDB Character Set (CDB must be AL32UTF8)

select username from dba_users where username like '%\_J' escape '\';

From MOS, search for patch 13390677 (it’s a full install) p13390677_112040_platform_1of7.zip (Oracle Database, including Oracle RAC components) p13390677_112040_platform_2of7.zip (Oracle Database, including Oracle RAC components)        

sqlplus username/pwd@//host[:port]/service prompt for password: sqlplus username@\”//host/[:port]/service\”

Determine connections that have been idle for more than a certain amount of time (be aware that last_call_et also shows number of seconds active also) Examples — Connections idle for > 60 minutes select s.sid,s.serial#,s.username,s.status,…