” B-tree indexes: the default and the most common B-tree cluster indexes: defined specifically for cluster Hash cluster indexes: defined specifically for a hash cluster Global and local indexes: relate to partitioned tables and indexes Reverse key indexes: most useful for Oracle Real Application Clusters applications Bitmap indexes: compact; work best for columns with a small set of values Function-based indexes: contain the precomputed value of a function/expression Domain indexes: specific to an application or cartridge. “ Tips: Bitmap indexes: suitable to complex WHERE clause in SQL statements. “LONG and…
[OCM 12C] Managing extended statistics
Oracle Database Online Documentation 12c Release 1 (12.1) -> Database Administration Database -> SQL Tuning Guide Part -> V Optimizer Statistics
[OCM 12C] Capturing performance statistics
Oracle Database Online Documentation 12c Release 1 (12.1) -> Database Administration Database -> SQL Tuning Guide Part -> V Optimizer Statistics
[OCM 12C] Configuring parallel execution
Oracle Database Online Documentation 12c Release 1 (12.1)-> Database Administration -> 15 Process Architecture Oracle Database Online Documentation 12c Release 1 (12.1) -> Data Warehousing and Business Intelligence -> Database VLDB and Partitioning Guide -> 8 Using Parallel Execution
[OCM 12C] Setting up Fine-Grained Auditing
views: AUDIT_UNIFIED_ENABLED_POLICIES CDB_UNIFIED_AUDIT_TRAIL UNIFIED_AUDIT_TRAIL Oracle Database Online Documentation 12c Release 1 (12.1) -> Database Security Guide -> Part VI Monitoring Database Activity with Auditing Oracle Database Online Documentation 12c Release 1 (12.1) -> Database Security Guide -> 21 Introduction to Auditing Oracle Database Online Documentation 12c Release 1 (12.1) -> Database Security Guide -> 22 Configuring Audit Policies Oracle Database Online Documentation 12c Release 1 (12.1) -> Database Security Guide -> 23 Administering the Audit Trail
#5 DIÁRIO DE UM DBA – Terças de Dados #39 – Exportando Profissionais! Mitos e fatos sobre os profissionais expatriados
[OCM 12C] Configuring and monitoring Flashback Database
Database Backup and Recovery User’s Guide -> 7 Using Flashback Database and Restore Points Database Backup and Recovery User’s Guide -> 18 Performing Flashback and Database Point-in-Time Recovery Database Backup and Recovery User’s Guide -> 21 Performing RMAN Tablespace Point-in-Time Recovery (TSPITR) Database Administration -> Database 2 Day DBA -> 9.8.2 Recovering a Dropped Table Using Oracle Flashback Drop – V$UNDOSTAT – DBA_RECYCLEBIN SQL> select CURRENT_SCN from v$database; “Creating a normal restore point assigns a restore point name to an SCN or specific point in time. Thus, a restore point…
[OCM 12C] Performing a full database backup
Database Backup and Recovery User’s Guide -> 4 Starting and Interacting with the RMAN Client Database Backup and Recovery User’s Guide -> 9 Backing Up the Database – Backing Up the Root with Oracle Enterprise Manager Cloud Control – Backing Up PDBs with Oracle Enterprise Manager Cloud Control Database Backup and Recovery User’s Guide -> 10 Backing Up the Database: Advanced Topics Database Backup and Recovery User’s Guide -> 11 Reporting on RMAN Operations Database Backup and Recovery User’s Guide -> 15 Diagnosing and Repairing Failures with Data Recovery Advisor…
Configuring RMAN
Database Backup and Recovery User’s Guide -> 5 Configuring the RMAN Environment Database Backup and Recovery User’s Guide -> 6 Configuring the RMAN Environment: Advanced Topics Database 2 Day DBA -> Performing Backup and Recovery -> Configuring Your Database for Basic Backup and Recovery -> Configuring Backup Settings Enabling the Fast Recovery Area – DB_RECOVERY_FILE_DEST_SIZE – DB_RECOVERY_FILE_DEST
[OCM 12C] Configuring recovery catalog
Database Backup and Recovery User’s Guide -> 13 Managing a Recovery Catalog