Hello all, I have become a collaborator for the LUXOUG – Luxembourg Oracle User Group which is the first Oracle user community in Luxembourg, whose founding members are: Andre Luiz Dutra Ontalba, Fernando Simon, Leonardo Santos Lopes and Rodrigo Mufalani (OCM). This is a group for anyone interested in sharing knowledge about Oracle Technology, focused on database administration, engineered systems, cloud, development and more. The group will hold presentations mostly in English, French and Portuguese but as it is written in their website they “are welcome to propose sessions in…
AWS Summit Stockholm on Wednesday, May 22, 2019 in Stockholm.
Hello, I would like to inform you all that I will be attending the AWS Summit on Wednesday, May 22, 2019 in Stockholm, Sweden. The main reason for attending this event is to understand better the AWS Cloud architecture for databases such as Oracle, MongoDB and MySQL. Here are the details for the event: There are still some places left to register for this event, so feel free to join: https://pages.awscloud.com/Stockholm-Summit-Register.html
On the 4th of June 2019, SWEOUG (https://www.sweoug.se/) & ORACLE will host a database Meetup.
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!
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:
[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
[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…