Home » Server Options » Text & interMedia » DML Pending queue dr$k table
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....
Previous Topic: create index on clob field as indextype ctxcat does not seem to work
Next Topic: CTXCat
Goto Forum:
  


Current Time: Thu Mar 28 09:13:57 CDT 2024