Using DATAPUMP utility to import tables with In-Memory Column Store in Oracle 12c

brunors

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

brunors

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…

Enabling Oracle Database In-Memory (Database In-Memory) option in Oracle Database 12c Release 1

brunors

According to Oracle documentation “Oracle Database In-Memory (Database In-Memory) is a suite of features, first introduced in Oracle Database 12c Release 1 (12.1.0.2), that greatly improves performance for real-time analytics and mixed workloads”. Therefore, in this post I will explain how to enable your Oracle Database to use the In-Memory option : 1- Be sure that your database is running on version level 12.1.0 or higher: 2- Set the parameter INMEMORY_SIZE to any value at about 100M (minimum setting): 3- Restart the database:

[OCM 12C] Managing SQL Plan Baselines

brunors

“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

[OCM 12C] Configuring the Resource Manager

brunors

Good to user with Enterprise Manager Cloud Control. “Oracle Database Resource Manager (the Resource Manager) enables you to manage multiple workloads within a database that are contending for system and database resources.” “You can examine these statistics using real-time SQL monitoring and the Resource Manager dynamic performance views (the V$RSRC_* views).” “Oracle Database provides a procedure (CREATE_SIMPLE_PLAN) that enables you to quickly create a simple resource plan.” Views: V$SESSION V$RSRC_* views) Steps to create a complex plan: Step 1: Create a pending area. Step 2: Create, modify, or delete consumer…

Retrieving a dropped table on Oracle 12c

brunors

Sometimes developers need to recover some tables and we as Oracle DBAs are asked to recover them. So in this post I am going to show you how do to that. I will be creating the table named TECHDATABASKET under the SH user using the dba_tables as example and afterwards I am going to use the syntax “FLASHBACK TABLE SH.TECHDATABASKET TO BEFORE DROP;” in order to recover this table. In the meantime, we need to execute a SELECT key on the table dba_recyclebin or simply the usage of the command…

How was the Workshop: Become a Hero with Oracle Autonomous Database in Stockholm, Sweden ( March 6, 2019) ?

brunors

Hello, Hello, As I announced a few weeks ago, I confirmed that I will join the Workshop: Become a Hero with Oracle Autonomous Database in Stockholm, Sweden ( March 6, 2019) . Besides the knowledge I gained attending this event I would really like to highlight Jan Tjernberg for his participation in my Youtube video regarding this event. The language spoken is Portuguese but from the minutes 3:22, it is possible to see my interview in English with him. The video is below: I hope everybody likes it and I…

Oracle Code and Oracle ACE program dinner – Rome, Italy 2019

brunors

Hello, I am glad to announce that I am going to attend the Oracle Code Rome 2019 and I will join as a guest in the Oracle ACE dinner. The dinner will be on the 03rd of April and the conference on the 04th of April. This will be my first dinner as a guest at the Oracle ACE Program after my award in Hungary. I am excited for this and I hope to see all of you guys in Rome, Italy on the 04th of April. If you have…