Very Long Parse Time for Queries in In-Memory Database

Very Long Parse Time for Queries in In-Memory Database (Doc ID 2102106.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Problem is exposed after upgrading the database to 12.1.0.2 with the IMDB feature configured or enabled
High long parse time for queries in 12.1.0.2 In-Memory Database (IMDB)

The EXPLAIN PLAN for takes hours to complete, however, it executes in less than a minute with INMEMORY_QUERY=DISABLE.

Upgrade to 12.1.0.2.0 Database with IMDB configured or enabled

	Sign In with your My Oracle Support account
	Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms