” 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…
Author: brunors
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.
[OCM 12C] Managing extended statistics
Oracle Database Online Documentation 12c Release 1 (12.1) -> Database Administration Database -> SQL Tuning Guide Part -> V Optimizer Statistics brunors*The views expressed here are my own and do not represent those of my employer.* Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence,…
[OCM 12C] Capturing performance statistics
Oracle Database Online Documentation 12c Release 1 (12.1) -> Database Administration Database -> SQL Tuning Guide Part -> V Optimizer Statistics brunors*The views expressed here are my own and do not represent those of my employer.* Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence,…
[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 brunors*The views expressed here are my own and do not represent those of my employer.* Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I…
[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 brunors*The views expressed here are my own and do not represent those of my…
#5 DIÁRIO DE UM DBA – Terças de Dados #39 – Exportando Profissionais! Mitos e fatos sobre os profissionais expatriados
brunors*The views expressed here are my own and do not represent those of my employer.* Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and…
[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 brunors*The views expressed here are my own and do not represent those of my employer.* Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by…
[OCM 12C] Configuring recovery catalog
Database Backup and Recovery User’s Guide -> 13 Managing a Recovery Catalog brunors*The views expressed here are my own and do not represent those of my employer.* Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and…