Hello, Hello, As I announced a few weeks ago, I confirmed that I will join the Workshop: Become a Hero with Oracle Autonomous Database in Stockholm, Sweden ( March 6, 2019) . Besides the knowledge I gained attending this event I would really like to highlight Jan Tjernberg for his participation in my Youtube video regarding this event. The language spoken is Portuguese but from the minutes 3:22, it is possible to see my interview in English with him. The video is below: I hope everybody likes it and I…
Oracle Code and Oracle ACE program dinner – Rome, Italy 2019
Hello, I am glad to announce that I am going to attend the Oracle Code Rome 2019 and I will join as a guest in the Oracle ACE dinner. The dinner will be on the 03rd of April and the conference on the 04th of April. This will be my first dinner as a guest at the Oracle ACE Program after my award in Hungary. I am excited for this and I hope to see all of you guys in Rome, Italy on the 04th of April. If you have…
Managing partitioned tables
Partition: Range Partition Interval Partition (extension of Range Partition) List Partition Hash Partition Reference Partition Range-Hash Partition (Subpartition) USER_TAB_PARTITIONS USER_SEGMENTS USER_PART_TABLES DBA_TAB_PARTITIONS USER_LOB_PARTITIONS Database VLDB and Partitioning Guide -> 4 Partition Administration https://www.youtube.com/watch?v=VBkpI4Ki49Q – Range Partition https://www.youtube.com/watch?v=0YYXfFcbC-A – List Partition https://www.youtube.com/watch?v=PrjI-aZrNZE – Hash Partitionhttps://www.youtube.com/watch?v=TT7aDwNFzC4 – Reference Partition https://www.youtube.com/watch?v=BESXA-k5EJU – Virtual column
Workshop: Become a Hero with Oracle Autonomous Database in Stockholm, Sweden ( March 6, 2019)
Hej, I was invited to join in the workshop “Become a Hero with Oracle Autonomous Database” on March 06th at Sheraton Stockholm Hotel (Tegelbacken 6 101 23 Stockholm Sweden ) from March 6, 2019 – 09:00 – 16:30 . Here is the official link to this event: : https://eventreg.oracle.com/profile/web/index.cfm?PKwebID=0x614233abcd Here is the agenda: Besides this, I was selected for an Oracle Cloud promotion in complimentary credits, valid for 30 days where I will be testing the Cloud Platform and Infrastructure services. After this event I’m going to write another post…
Novo portal do GPO – Grupo de Profissionais Oracle
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:
#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!”
[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 :
#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:
[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