Our Domains

littlecode.in

littlecodework.wordpress.com

sites.google.com/view/oracle19c

Blog Posts

• List of DBA Views in Oracle 19c

• Oracle – Shrink LOB columns

• Oracle Schema export using Datapump API

• Oracle Redaction details in the database

• Oracle index in UNUSABLE state

• Oracle object locked by a session (v$locked_object, dba_hist_active_sess_history)

• Oracle tablespace – add space / resize / check autoextend / set autoextend off

• Oracle SGA – System Global Area

P2 Wordpress (littlecodework.wordpress.com)

Oracle-Base youtube videos

Oracle Explain plan

Monitoring parallel chunks

Connect as SYSTEM user and start listener

CDB PDB

Oracle – unlock account and reset its password

CDB PDB

Connecting as SYSTEM user & Listener start

Oracle Database 2-Day DBA

https://apexapps.oracle.com/pls/apex/f?p=44785:50:1497497889766:::50:P50_EVENT_ID,P50_PREV_PAGE,P50_COURSE_ID:6362,175,458