Database Administration (MOSC)

MOSC Banner

Number of rows to commit

edited May 8, 2010 11:03AM in Database Administration (MOSC) 1 commentAnswered ✓
 Informatica is processing via a batch job on a 1 Terabyte database. The deletes are in a 260 gb tablespace (sum of data+ index tablespace) and the inserts are on a 300 gb tablespaces (sum of data + index tablespace).

The undo tablespace is 54 gb with undo_retention of 36000.

The Informatica employees told me that there is a parameter in Power center (informatica)  that controls the commits and that the default is 10,000 rows. They ask me to provide a number of rows in which the commits can be performed.  This I don't know.


 

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