Database Tuning (MOSC)

MOSC Banner

INSERT takes forever

edited Mar 25, 2012 8:51PM in Database Tuning (MOSC) 10 commentsAnswered
Hi,
version: 11.2.0.2

The following has been running for many hours in our DEV environment:

INSERT INTO ldw.mft_satx_itm (DAY_TIME_KEY,
                              SKU_PROD_KEY,
                              STOR_LOC_KEY,
                              TOD_HOUR_KEY,
                              TX_TYPE_KEY,
                              CUID_CUST_KEY,
                              PRCE_KEY,
                              EMPL_CSHR_KEY,
                              SALE_PRCE_TYPE_KEY,
                              TX_SEQ_NO,
                              ITM_SEQ_NO,
                              TX_REV_NO,
                              LINE_NO,
                              VCHR_NO,
                              REG_NO,
                              TX_NO,
                              VLD_TX_CNT,
                              VCHR_CNT,
                              RTL_QTY,
                              RTL_VAT_AMT,
                              DISC_QTY,
                              DISC_VAT_AMT,
                              IN_PRCE,
                              COST_AMT,
                              PRCE_LST_VAT_AMT,
                              VAT_RATE,
                              ADD_VAT_FCTR,
                              RMV_VAT_FCTR,
                              CLR_FLAG,
                              LOAD_TSTM)
   SELECT DAY_TIME_KEY,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center