12c, hash partitions and hints

Hi all,

DB version:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

OS version:

RHEL 6.7

Server specs:

2 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz (virtual cores)

47G memory, 22.5G sga_max_size

As of recent, I have been testing EE. We are a small shop and have been using SE1 exclusively. I have one particular piece of code that does the following:

1. Truncate table

2. Join an item table (250M records) to a customer table (25M records) and insert into truncated table. Key is customer_id.

3. Gather statistics on newly inserted table

Using EE, I have hash partitioned both tables (8) by customer_id.