Database Tuning (MOSC)

MOSC Banner

Request for an advisory on best practice and possible performance pitfalls

edited Feb 6, 2015 1:16AM in Database Tuning (MOSC) 1 commentAnswered

Scenario:

Given a table that continually has rows added, we want to purge entries fulfilling a certain criteria. However, we want to persist entries before purging and we want to ensure that only persisted entries are purged.

Solution (so far):

We do this as a scheduled Job, that executes 3 steps implemented as separate procedures:

  • Step 1:
    Copy entries from source table that meets the criteria to a structurally identical table (henceforth: the buffer table). The buffer table is only accessed by the Job.
  • Step 2:
    Save rows from the buffer table to the file system.
  • Step 3:
    Delete rows from the source that are present in the buffer table. Rows are deleted in chunks in order to avoid long locking.

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