[Oracle] Where is the In-memory join Group located in memory?

Source: Internet
Author: User

Where is the data dictionary of the In-memory join Group located in memory?

A customer asked if the Join Group was used when using Oracle's In-memory function,
So where are these join Group, located in memory?

According to the results of colleagues ' execution, the following are organized:

1.prepare Test env.
CREATE TABLE T1 as select * from Dba_tables
CREATE TABLE t2 as SELECT * from Dba_tables
Create InMemory join Group T_join (T2 (table_name), T1 (table_name))
Create InMemory join Group T_join1 (T2 (owner), T1 (owner))

ALTER TABLE T1 InMemory
ALTER TABLE T2 InMemory
Alter system set Inmemory_size =300m


==run SQL
SELECT T1.owner,t2.table_name
from T1, T2
WHERE T1.table_name = T2.table_name

==check GD
Select O.object_name table_name, C.column_name column_name, gd.head_address as "GD address"
From User_objects O, user_tab_columns C, V$im_segdict GD
WHERE GD.OBJN = o.object_id
and o.object_name = C.table_name
and gd.column_number = c.column_id;


T1 table_name 000000008A8B10F0
T2 OWNER 000000008a8310f0


Dump the Memory:

==dum SGA Memory
Heap DUMP heap Name= "IMCA_RW" desc=0x60001178 ***<<<<Extent sz=0x1040 alt=336 het=32767 rec=0 flg=0x2 opc=0
Parent= (nil) owner= (nil) nex= (nil) xsz=0x3bfffd0 heap= (nil)
FL2=0XA4, nex= (nil), idx=0, Dsxvers=1, dsxflg=0x0
DSX First ext=0x89800030
DSX Empty ext bytes=0 subheap RC link=0x898000a0,0x898000a0
PDB id=1, SRC PDB id=1
EXTENT 0 addr=0x89800030
Chunk 089800040 sz= Perm "Perm" alo=112
Dump of memory from 0x0000000089800040 to 0x00000000898000b0
.............
Chunk 08a7e10d8 sz= 46137368 freeable "Cimadrv"
Dump of memory from 0x000000008a7e10d8 to 0x000000008d3e10f0 ***<<<<<this chunk cover these address.

Repeat 3489 Times
08a8b10f0 0a0a0a0a 00011e8e 00000001 00000836 [.....] 6 ...]
08a8b1100 8a8c10f0 00000000 00000000 00000000 [.........]
08a8b1110 00000000 00000000 00000000 00000000 [.........]

Repeat 3489 Times
08a8310f0 0a0a0a0a 00011e8f 00000000 00000014 [.........]
08a831100 8a8410f0 00000000 00000000 00000000 [.........]
08a831110 00000000 00000000 00000000 00000000 [.........]

It can be concluded that it is located in memory's Clumn store.

[Oracle] Where is the In-memory join Group located in memory?

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.