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:
- Configuring the Product Easily
- Understanding Fast Table Scans (with none of those pesky indexes)
- Understanding Query Optimisation
- 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.
Richard Foote's Oracle Blog 
Are you likely to be recording this event? Will you make your image available to the public?
LikeLike
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 🙂
LikeLike
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>
LikeLike
Update: This event is now officially full. Sorry to disappoint if you haven’t yet enrolled.
LikeLike