Owner:oracle (Oracle software owner) Database: techdb Instances: techdb1, techdb2 Servers/Node: basket-techdb01, basket-techdb02 To remove and later add the cluster Oracle database, follow these steps: It is important to know the previous configuration for a possible backup: Stop the database: Remove the database from cluster configuration: Add the database in the cluster configuration: (For all nodes) Start the database: Check the configuration again : Check the status of the database : brunorsHi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a…
Month: January 2019
#5 DIÁRIO DE UM DBA – Terças de Dados #39 – Mesa Redonda com os “Fugidos do Brasil
Foi convidado para compartilhar no “Terças de Dados #39 – Mesa Redonda com os “Fugidos do Brasil” um pouco sobre minha experiência anteriormente na Hungria (2 anos) e atualmente na Suécia.O evento contou com vários outros profissionais de outros países como Fernando Simon (Luxemburgo), Marcelo Fernandes (Alemanha), Christian Gebert (Índia), Dennes Torres (Malta), Lucas de Lima (Portugal), Nilton Pinheiro (Portugal) e Bruno Carvalho (Austrália). Agradeço ao Fabio Cotrim pela oportunidade! Aqui está o vídeo: Aqui a divulgação no GPO: brunorsHi! I am Bruno, a Brazilian born and bred, and I…
[OCM 12C] Creating and managing partitioned indexes
” 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 brunorsHi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil,…
[OCM 12C] Capturing performance statistics
Oracle Database Online Documentation 12c Release 1 (12.1) -> Database Administration Database -> SQL Tuning Guide Part -> V Optimizer Statistics brunorsHi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil,…
[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 brunorsHi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten…
[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 brunorsHi! I am Bruno, a Brazilian born and bred, and I am also a…
#5 DIÁRIO DE UM DBA – Terças de Dados #39 – Exportando Profissionais! Mitos e fatos sobre os profissionais expatriados
brunorsHi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in…