On the 4th of June 2019, SWEOUG (Swedish Oracle User Group) & ORACLE will host a database Meetup. This FREE event will be held in Stockholm, Vasagatan 7a Centralen, room Clara 1. 13.00 -17.00. Come and meet the Master Product Manager for the Oracle Database, Dominic Giles and the Product Manager for the Oracle Optimizer, Nigel Bayliss. Here are the twitters of the speakers: https://twitter.com/vldbb https://twitter.com/dominic_giles I really would like to join but I will be travelling to Poland due to some business activities. However, feel free to join! brunorsHi! I am Bruno, a…
Year: 2019
Oracle Database 18c: Provisioning the Linux server
In the initial menu of the Oracle Cloud click on “Compute” and later on “Instances”: On the next tab, click the “Create Instance” button: In the Create Compute Instance tab, provide the requested information: Name: Choose a name for your instance. (In the example: VMLINUXmachine) Select an available domain for your instance: Choose the first available domain (In the example: ysjg: PHX-AD-1) Choose an operating system or image source: Keep the option available on Oracle. Image Operating System: Oracle Linux 7.6 Choose instance type: Choose “Virtual Machine” Shape: We will…
Oracle Database 18c: Creating the Virtual Network (Virtual Cloud Network)
In the Virtual Cloud Network tab click on the “Create Virtual Cloud Network” button: In the Virtual Cloud Networks tab click on the “Create Virtual Cloud Network” button: You will then be presented with the screen to create the Virtual Cloud Network, where it is necessary to specify all the information for the VNC configuration: In the Virtual Cloud Network tab choose the option “Create Virtual Cloud Network plus related resources” to create the VNC only with public subnets: Click the “Create Virtual Cloud Network” button and a screen with…
Oracle Database 18c: Provisioning the Oracle Autonomous Database in the Cloud
For this step you will need to create the account in the Oracle Cloud with this link, https://cloud.oracle.com/home . Before you provide the database you need to create a Compartment. If you have not yet created one click on “Identity” and later on “Compartments” under the “Governance and Administration” tab of the menu: Then click “Create Compartment” if there is none existing : The root compartment is the first compartment created. From it, it is possible to create other compartments by using them as an option in the “Parent Compartment”…
#7 DIÁRIO DE UM DBA – Oracle Code e jantar do programa Oracle ACE – Roma, Itália 2019
Fala galera! Como eu expliquei no post anterior : https://www.techdatabasket.com/oracle-code-and-oracle-ace-program-dinner-rome-italy-2019/ que estaria participando do Oracle Code e do jantar do programa Oracle Ace 2019, segue o vídeo que eu fiz sobre o evento no canal do DBA Brasil no You Tube: Segue a cobertura do site do DBA Brasil: 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…
[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…
Enabling and disabling table for the IM column store in Oracle 12c
In order to Enable or Disable the IM Column Store for Tables, your database must be with the Oracle Database In-Memory (Database In-Memory) option enabled. If not, see this post : https://www.techdatabasket.com/enabling-oracle-database-in-memory-database-in-memory-option-in-oracle-database-12c-release-1/ According to Oracle, “You enable a table for the IM column store by including an INMEMORY clause in a CREATE TABLE or ALTER TABLE statement. You disable a table for the IM column store by including a NO INMEMORY clause in a CREATE TABLE or ALTER TABLE statement.”. Then, in this post I am going to show you…