jump to navigation

Oracle Database In-Memory Test Drive Workshop: Canberra 28 April 2015 March 30, 2015

Posted by Richard Foote in 12c, In-Memory.
trackback

I’ll be running a free Oracle Database In-Memory Test Drive Workshop locally here in Canberra on Tuesday, 28th April 2015.

Just bring a laptop with at least 8G of RAM and I’ll supply a VirtualBox image with the Oracle Database 12c In-Memory environment. Together we’ll go through a number of hands-on labs that cover:

  1. Configuring the Product Easily
  2. Understanding Fast Table Scans (with none of those pesky indexes)
  3. Understanding Query Optimisation
  4. Understanding Transactional Consistency

It’s sure to be a fun morning. It’s also sure to fill up really quickly so please register ASAP to avoid disappointment.

For all the necessary details including how to register click here.

Hope to see you then🙂

UPDATE: This event is now officially FULL. Sorry to disappoint if you haven’t yet enrolled.

Comments»

1. Martin - March 31, 2015

Are you likely to be recording this event? Will you make your image available to the public?

Richard Foote - April 15, 2015

Hi Martin

As it’s primarily a hands-on lab, recording a room full of folk playing with the In-Memory option for a few hours is not likely to be the most stimulating of recordings🙂

2. Rajeshwaran, Jeyabal - April 2, 2015

Richard,

I was reading through 12c concepts guide.

https://docs.oracle.com/database/121/CNCPT/schemaob.htm#CNCPT89298

“Before Oracle Database 12c, an exchange partition operation required a physical update of an associated global index to retain it as usable. Starting with Oracle Database 12c, if the partitions involved in a partition maintenance operation are not part of a partial global index, then the index remains usable without requiring any global index maintenance.”

That means don’t I need to have “update global indexes” as part of PMO on partitions that are not the part of partial global index? My test result show indexes were moved to unusable state.

rajesh@PDB1> create table t
2 indexing off
3 partition by list(id)
4 ( partition p1 values(1) indexing off,
5 partition p2 values(2) indexing off ,
6 partition p3 values(3) indexing on)
7 as
8 select a.*, mod(rownum,3)+1 id
9 from all_objects a ;

Table created.

rajesh@PDB1> create index t_idx on t(object_id) indexing partial;

Index created.

rajesh@PDB1>
rajesh@PDB1> select index_name,num_rows,leaf_blocks,
2 indexing,last_analyzed,status
3 from user_indexes
4 where table_name =’T’;

INDEX_NAME NUM_ROWS LEAF_BLOCKS INDEXIN LAST_ANALYZED STATUS
———- ———- ———– ——- ———————– ——–
T_IDX 29782 83 PARTIAL 02-APR-2015 12:39:58 PM VALID

1 row selected.

rajesh@PDB1> create table t1
2 as
3 select * from t
4 where 1 = 0 ;

Table created.

rajesh@PDB1>
rajesh@PDB1> alter table t
2 exchange partition p2
3 with table t1 ;

Table altered.

rajesh@PDB1> select index_name,num_rows,leaf_blocks,
2 indexing,last_analyzed,status
3 from user_indexes
4 where table_name =’T’;

INDEX_NAME NUM_ROWS LEAF_BLOCKS INDEXIN LAST_ANALYZED STATUS
———- ———- ———– ——- ———————– ——–
T_IDX 29782 83 PARTIAL 02-APR-2015 12:39:58 PM UNUSABLE

1 row selected.

rajesh@PDB1>

3. Richard Foote - April 14, 2015

Update: This event is now officially full. Sorry to disappoint if you haven’t yet enrolled.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: