| DML Pending queue dr$k table [message #261144] |
Wed, 22 August 2007 00:40 |
prakashpatidar
Messages: 2
Registered: August 2007
|
Junior Member |
|
|
Hi,
I have table with 20 column:19 column contains structure data and one column contains blob My application is generationg batch file for this data and I am using SQLLoader direct path loading to load this data into my table.Speed of uploading is almost 5000 Recods/Second .But when i define context (domain index) on blob column and even index is not sync at the time of insertion, speed of insertion goes down to 1000 Record/Second.When i look into problem i saw that it is maintaining pending queue in $K table to provide deferred indexing.But i want it should not maintain pending queue so that i will acchieve same insertion speed 5000 Records/second.When i will require indexing i will index whole partition instead of getting job from pendign queue .
Is there anyway through which i can say oracle that dont maintain pending queue for this domain index?
Any help will be really helpful for me....
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
