Skip to Main Content

select count from table not running. Only Queue

AhmetMelihApr 12 2016 — edited Apr 14 2016

Hello. I have oracle database 12c RAC system with Inmemory option. I took a table to INMEMORY.

select v.owner, v.segment_name, v.bytes orig_size, v.inmemory_size in_mem_size, v.bytes/v.inmemory_size comp_ratio from v$im_segments v;

OWNER

--------------------------------------------------------------------------------

SEGMENT_NAME

--------------------------------------------------------------------------------

ORIG_SIZE IN_MEM_SIZE COMP_RATIO

---------- ----------- ----------

IMS

VALUES

1943011328   176488448 11.0092833

IMS

VALUES

OWNER

--------------------------------------------------------------------------------

TABLE_NAME

--------------------------------------------------------------------------------

IM IM_PR  IM_DIS  IM_COMP    IM_DUP

-------- -------- --------------- ----------------- -------------

ENABLED  CRITICAL AUTO  FOR QUERY LOW     NO DUPLICATE

We send "select count(*) from ims.values" but it doesn't show any result. I see ony Enterprise Manager, It is on "queue" . What should I do? I waited 20 minutes. Is it reason 'InMemory Enabled' ?

SQL> show parameter inmemory

NAME     TYPE VALUE

------------------------------------ ----------- ------------------------------

inmemory_clause_default     string

inmemory_force     string DEFAULT

inmemory_max_populate_servers     integer 36

inmemory_query     string ENABLE

inmemory_size     big integer 64G

inmemory_trickle_repopulate_servers_ integer 1

percent

optimizer_inmemory_aware     boolean TRUE

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on May 12 2016
Added on Apr 12 2016
1 comment
691 views