In Memory Related

Smart Scans
InMemory
Hybrid Columnar Complression


v$INMEMORY_AREA

INMEMORY_SIZE

ALTER TABLESPACE <TBS> DEFAULT INMEMORY;

ALTER TABLE <table> INMEMORY NOINMEMORY(prod_id);

V$IM_SEGEMENTS
V$IM_USER_SEGMENTS
V$IM_COLUMN_LEVEL
V$INMEMORY_AREA

Bloom Filters
Vector Group by

Auto DOP
InMemory Advisor

Small Tiny Objects < 1MB cannot be stored

concurrent users is high is better for inmemory

result is reflected after commit
speed up scan and filter operations

Advertisements

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