Pessoal, O GPO – Grupo de Profissinais Oracle está com cara nova no ano de 2019. Sérgio Willians que é o administrador do grupo comunicou a notícia há algumas semanas e que está aceitando novos articulistas. Segue o link do portal novo: https://www.profissionaloracle.com.br/swillians/ Segue o link caso você queira se tornar um articulista do grupo: 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…
Year: 2019
#6 DIÁRIO DE UM DBA – Vem aí o DBA BRASIL 4.0
No dia 4 de maio de 2019 , às 8 horas, começa a 4ª edição do evento anual DBA BRASIL 4.0, o maior evento sobre Data Platform do Brasil. Segundo publicado na página oficial do site : https://dbabrasil.net.br/vem-ai-o-dba-brasil-4-0/ “Nesta edição, além das tradicionais palestras, teremos alguns hands-on conduzidos por profissionais renomados do mercado. As inscrições para palestrantes serão abertas em breve!” 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…
[Oracle 12c]How to remove and add databases from Oracle cluster
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 : brunors*The views expressed here are my own and do not represent those of my employer.* Hello, I’m Bruno — a…
#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: brunors*The views expressed here are my own and do not represent…
[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 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…