jul 25

GUOBTECHDAY 2020 está chegando!

Com grande sucesso, o GUOB prepara mais uma edição de seu evento nacional: o GUOBTECHDAY 2020! No dia 15/08/2020 (Sábado), totalmente ONLINE, gratuito e em português o qual proporcionará um grande encontro de usuários de tecnologia Oracle do Brasil. Este ano teremos a presença de 30 palestrantes que compartilharão conhecimento nas trilhas de Database, Java, …

Continue lendo

maio 06

Exporting all usage and cost report from your Oracle Cloud at once

To track your tenancy cost and usage reports, Oracle made available from the OCI portal the capability of downloading files that are generate daily and uploaded to the bling storage bucket. However, it lack the feature to download all files at once for a specified timeframe. Note: To enable this, you require some policies in …

Continue lendo

abr 17

Dissecting 200414 BP, PSU, RU and RUR

I am quarterly writing a post dissecting the changes implemented by Oracle CPUs so we can understand better the modifications implemented by Oracle in our Databases. The following patches were analyzed: 11.2.0.4 11.2.0.4.200414 DB PSU 11.2.0.4.200414 Exadata Bundle Patch 11.2.0.4.200414 OJVM PSU 12.1.0.2 12.1.0.2.200414 DB PSU 12.1.0.2.200414 Exadata Bundle Patch 12.1.0.2.200414 OJVM PSU 12.2.0.1 12.2.0.1.200414 …

Continue lendo

abr 17

Oracle April 2020 Critical Patch Advisory - PL/SQL detailed changes

Oracle April 2020 Critical Patch Advisory changed objects performed by each database patch. For more details and the catalog, check the main post: Dissecting 200414 BP, PSU, RU and RUR What exactly changed for each? (click to see detailed line changes) 12.1.0.2 DVSYS.DBMS_MACADM - PACKAGE 12cR1 (BP) DVSYS.DBMS_MACADM - PACKAGE BODY 12cR1 (BP) DVSYS.DBA_DV_PREPROCESSOR_AUTH - …

Continue lendo

mar 18

OCI "manage database-family" policy not working

On OCI, sometimes you may want to restrict the capability of a given group to only manage databases in a given compartment. Let's say your compartment name is NPRD and the group name is DBAs. Usually you would end-up with something like this on your policies: allow group DBAs to manage database-family in compartment NPRD …

Continue lendo