SQL Performance (MOSC)

MOSC Banner

DB file sequential read

edited May 23, 2013 5:34AM in SQL Performance (MOSC) 9 commentsAnswered
Hi,We have a simple program the code is given below. It simply truncates and then inserts a table. It was working fine. Only since the last few days the program started taking huge amount of time. We observed it is doing too much of db file sequential reads. There was no change in the code anywhere during this time. Any idea on how this can happen?

truncate table xxia.xxrpt_ship_carton_hist_s;

INSERT      /*+ APPEND */INTO xxia.xxrpt_ship_carton_hist_s
   SELECT *
     FROM xxeul.carton_hist_shipped;

Also the program runs fine in dev and test instance but hangs in prod.

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