Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to make Oracle ignore the APPEND hint?

169178Jul 23 2008 — edited Jul 23 2008
We are using Oracle Business Intelligence 10.1.3.3 product (old name Siebel Analytics).
The database is Oracle Database 10g EE 10.2.0.3.0 database.
When using Segment Designer tool, we notice that it generates INSERT statements with APPEND hint.
Our DBA is saying this is causing bottlenecks as it requires table level locks. This is making processes run serially, instead of concurrently.

My question is : Can we do some setting changes in the database so it ignores the APPEND hint in INSERT statements ? (at least for the sessions of a particular user).

regards,
Sumant
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 20 2008
Added on Jul 23 2008
#general-database-discussions
13 comments
1,799 views