Database Administration (MOSC)

MOSC Banner

Single row INSERT do many many blocks read!

edited Dec 6, 2017 4:22AM in Database Administration (MOSC) 25 commentsAnswered ✓

Hi all,

    We have migrated 10T data use sql*loader. Then there need twenty seconds for responsing of insert one rows. We trace insert operation with 10046 and find the operation of inserting one rows need access thousands of blocks .  We have find one document  "INSERT slow on ASSm (document 1263496.1)"  match our issue.  So we have the following question:

1、which batch insert operation will resulting in that issue?

2、We have set pctfree is 10,why all block have not free space?

Thanks & Regards

Ryan

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