CODEWITHSUNDEEP
databaseoracle-databaseoracle12c
Glavryba
Glavryba

Reputation: 19

How to monitor, that data is retrieved from INMEMORY?

I'm tuning INMEMORY COLUMN STORE in Oracle 12c DB. How to understand, that data collects from INMEMORY, not from general DB?

I can't get this information from Plan in SQL Developer.

Upvotes: 0

Views: 78

Answers (1)

Lalit Kumar B
Lalit Kumar B

Reputation: 49092

To determine if a SQL statement is scanning data in the IM column examine the execution plan.

For example :

TABLE ACCESS INMEMORY FULL

The keyword, INMEMORY in the Operation proves that it is an IM table scan.

In SQL Developer, use the EXPLAIN PLAN tool or press F10 to generate the execution plan.

Upvotes: 1

Related Questions