SQL Performance (MOSC)

MOSC Banner

Very slow full table scan

edited Jul 12, 2016 5:01AM in SQL Performance (MOSC) 5 commentsAnswered

Hi,

We are using Release: Oracle 12.1.0.2 with Red Hat Linux.

There is an update operation with very slow full table scan.

The session is 4198 minutes active.

The amount of blocks to read in the full table scan is 81598.

The session had started 3 days ago.

Right now ONLY 1957 blocks were read. The problem is: few blocks read (1957) in 3 days.

Its very stranger this behaivor.

The operation is:

UPDATE CRM_APP.TB_CUSTOMER C SET C.UP_DT = ':p_up_dt'

WHERE EXISTS

(

    SELECT * FROM CRM_APP.TB_CUSTOMER_TMP U

    WHERE   U.CUST_ID = C.CUST_ID

    AND     U.ACC_ID  = C.ACC_ID

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