2022 was an odd year. I started running in 2021, but only in 2022 I began to compete seriously as an amateur. Therefore, I competed in 12 official races where 9 of which were 10km races and three half-marathon (21 km each). However, using gadgets that helped me to record my results, I ended with 98 unique records, which counted all the official races and all the training. Bearing this in mind, what can we do with this whole amount of saved data? The answer is simple: analyzing and visualizing…
Category: Uncategorized
#sweoug #oracle #meetup – Feb 18 – 2020
Hello, I invite you all to attend my presentation in Stockholm, Sweden about “ORACLE DATABASE ON ORACLE AWS RDS” this Tuesday, 18th of February. Come to have the opportunity to check out Oracle engine in other vendors and compare with Oracle OCI ED2. We will also have Göran Paues speaking about “London OOW highlights”. Don’t miss this opportunity. Sign up here: https://www.meetup.com/Stockholm-Oracle/events/ctmzlrybcdbxb/ 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…
Presentation LUXOUG: Oracle Database on Oracle AWS RDS
“Oracle Database on AWS RDS “ to the LUXOUG (Luxembourg Oracle User Group) 🇱🇺 on February . Here are the details: – Oracle Database on AWS RDS. – How to migrate the On-prem Oracle to AWS RDS (Oracle LogMiner) – Pros x Cons of using DMS tool (According to my experience) Link: https://lnkd.in/dyEjvrd Speaker: Bruno Reis – 02/13/2020 19:00 (CEST) Please subscribe to the portal for free. Youtube link : https://www.youtube.com/watch?v=Ud3CGT4B1Io Pdf of the presentation below: brunorsHi! I am Bruno, a Brazilian born and bred, and I am also a…
Palestra: Oracle Database on AWS RDS
Hello, I will be giving a presentation in Brazil. The lecture topic will be, the Oracle Database on AWS RDS at IBM Brazil and on Tuesday, January 14th, 2020, for IBM employees and the language of the presentation will be Portuguese.The lecture will be presented in Portuguese at 10 am. Topics of the session: – How to migrate your Oracle Database on-prem to AWS RDS – DMS limitation and my experience (Pros X Cons) to migrate your Oracle database On-prem to AWS RDS Bruno Reis is an Oracle Database Administrator…
[OCM 12] Managing an encrypted tablespace
E.g: CREATE TABLESPACE securespace DATAFILE ‘/u01/app/oracle/oradata/techdatabasket/secure01.dbf’ SIZE 100M ENCRYPTION USING ‘AES256’ DEFAULT STORAGE(ENCRYPT); VIEWS: V$ENCRYPTED_TABLESPACE DBA_TABLESPACES USER_TABLESPACES Database Administration -> Database Administrator’s Guide -> 13.2.5 Encrypted Tablespaces Oracle Database Administrator’s Guide -> 20 Managing Tables -> 20.2.13 Consider Encrypting Columns That Contain Sensitive Data 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…
[OCM 12C] Managing additional buffer cache
“The In-Memory Column Store (IM column store) is an optional portion of the system global area (SGA) that stores copies of tables, table partitions, and other database objects. In the IM column store, data is populated by column rather than row as it is in other parts of the SGA, and data is optimized for rapid scans. The IM column store is included with the Oracle Database In-Memory option.” Configure the database to use IM Column Store; (https://www.techdatabasket.com/enabling-oracle-database-in-memory-database-in-memory-option-in-oracle-database-12c-release-1/) Setup some tables to use the IM Column Store; (https://www.techdatabasket.com/enabling-and-disabling-table-for-the-im-column-store-in-oracle-12c/) Datapump from…
[OCM 12C] Managing a fast refreshable materialized view
“Performing a refresh operation requires temporary space to rebuild the indexes and can require additional space for performing the refresh operation itself.” “Not all materialized views may be fast refreshable. Therefore, use the package DBMS_MVIEW.EXPLAIN_MVIEW to determine what refresh methods are available for a materialized view.” Refresh methods: Incremental : Two types: logg-based refresh and partition change tracking (PCT). “The incremental refresh is commonly called FAST refresh as it usually performs faster than the complete refresh.” Complete refresh DBMS_MVIEW package DBMS_MVIEW.REFRESH DBMS_MVIEW.REFRESH_ALL_MVIEWS DBMS_MVIEW.REFRESH_DEPENDENT Traditional methods: FAST (‘F’), COMPLETE (‘C’), PCT…
Using DATAPUMP utility to import tables with In-Memory Column Store in Oracle 12c
In this post I am going to show you how to perform an import using Datapump utility from one database to another with the purpose being to use IM Column Store through the export and import of one table called TECHDATABASKETBLOG under the schema SH. Therefore, the first step is to have your database configured to use IM Column Store (if not, check out : https://www.techdatabasket.com/enabling-oracle-database-in-memory-database-in-memory-option-in-oracle-database-12c-release-1/) and the second step is to have some table configured to use it (if not, check out: https://www.techdatabasket.com/enabling-and-disabling-table-for-the-im-column-store-in-oracle-12c/) . After this you are ready…
[OCM 12C] Tuning SQL statements
DBMS_STATS.CREATE_EXTENDED_STATSDBMS_STATS.GATHER_TABLE_STATS PARAMETER OPTIMIZER_MODE Database SQL Tuning Guide -> 14 Influencing the Optimizer 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…
[OCM 12C] Managing SQL Plan Baselines
“SQL plan management is a preventative mechanism that enables the optimizer to automatically manage execution plans, ensuring that the database uses only known or verified plans.” SPM has three main components: • Plan Capture: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES = TRUE (Automatic Initial Plan Capture), OPTIMIZER_USE_SQL_PLAN_BASELINE=TRUE • Plan Selection • Plan Verification/Evolution dba_sql_plan_baselines DBA_SQL_PLAN_BASELINE Database Administration -> Database SQL Tuning Guide -> 23 Managing SQL Plan Baselines 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…