I have added to my blog a banner about the OraWorld magazine. This magazine is free and technical about Oracle contents. To get this magazine you only have to go through this link http://www.oraworld.org/home/, click on the “Subscribe to Newsletter” tab and fill in your information like e-mail, name, last name, user group (if you a part of one), accept all terms and then submit your subscription. Once this is done, you will receive an e-mail in your e-mail box. If you don’t find the e-mail from the magazine, take…
Day: May 12, 2020
#8 DIÁRIO DE UM DBA – GUORS: I Encontro de Usuários Oracle do RS 2020
Faz exatamente 1 ano e 6 dias desde que eu escrevi o meu últigo post sobre essa série que eu criei no meu blog para escrever em português e escrever sobre eventos e notícías do universo Oracle no Brasil. Pois é meus amigos… 1 ano e 6 dias mas isso não quer dizer que o blog ficou parado não. Desde então, teve vários outros posts mas na língua inglesa e não sobre esta série. Por isso, me desculpem ! 🙂 Voltamos com tudo e agora para falar do evento GUORS:…
Digging the STAR_TRANSFORMATION_ENABLED parameter on Oracle database 12cR1 inside a PDB
When you think of a parameter that can help you out with star queries, this parameter is the STAR_TRANSFORMATION_ENABLED. According to the Oracle official documentation, it is described as the difference between a typical query and a star query, “A typical query in the access layer is a bond between the fact table and some number of dimension tables and is often referred to as a star query. In a star query, each dimension table is joined to the fact table using a primary key to foreign key join. Normally…