Performance Tuning Basics on March 23, 2021 analysis explain plan instance tuning monitoring oracle performance reports sqltuning Tuning +
Oracle Architecture on February 23, 2021 Architecture background process Connection Database buffer cache logical structures Memory structures PGA physical Process structures session SGA Shared pool Storage structures UGA +
Back up and its Types - Some of RMAN Commands on January 24, 2021 archivelogfile backup backupset commands configure controlfile Cumulative Backups datafile Differential backup full backup imagecopy Incremental backups recover restore retention RMAN +
User Management on January 21, 2021 alter user altering user create user drop user grant privilege grant role granting privilages revoke privilege revoke role roles user creation user droping user management +
Session Debugging on January 20, 2021 deadlocks kill locks process session sql_fulltext sql_id v$locked_object v$process v$session v$sql v$transactio +