Some Basic Scripts Used on March 23, 2021 allocation scripts +0 tablespace usage allocation scripts tablespace usage
Performance Tuning Basics on March 23, 2021 analysis explain plan instance tuning +3 monitoring oracle performance reports sqltuning Tuning analysis explain plan instance tuning monitoring oracle performance reports sqltuning Tuning
Create Database and Drop Database on February 25, 2021 create creation Database deleting + drop create creation Database deleting drop
Oracle Architecture on February 23, 2021 Architecture background process +10 Connection Database buffer cache logical structures Memory structures PGA physical Process structures session SGA Shared pool Storage structures UGA 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 +10 commands configure controlfile Cumulative Backups datafile Differential backup full backup imagecopy Incremental backups recover restore retention RMAN 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 +7 drop user grant privilege grant role granting privilages revoke privilege revoke role roles user creation user droping user management 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 +4 session sql_fulltext sql_id v$locked_object v$process v$session v$sql v$transactio deadlocks kill locks process session sql_fulltext sql_id v$locked_object v$process v$session v$sql v$transactio