Database Administration (MOSC)

MOSC Banner

Buffer Insert

edited Dec 10, 2013 11:31PM in Database Administration (MOSC) 4 commentsAnswered
Hi,

I am using the concept of Buffer Insert for performance issue, I have taken the count variable and if the count is equal to 99 then it will clear the buffer by using the Table I/O FlushInsertBuffer and insert the 100 records at a time into the table.

But i have a problem when implementing this like if the Buffer have less than 99 records then it is not inserting the records into the table.

Can anyone give me the solution that how to identify the records which are there in the buffer and how to insert them into the table.

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