Skip to Main Content

Berkeley DB Family

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!

dbxml index creation problem

652142Aug 29 2009 — edited Oct 12 2009
I've got a database container sporting DBXML_INDEX_NODES. It has about 70K documents, average
document size is 8K. To load the database I really have to create the indices and then load,
otherwise sometimes I get a out of memory error when creating them after the load of the 70K documents.
Sometimes I get another prompt and it appears to have worked, I describe below:

Anyway, I fired up dbxml and created another index, I have 7, adding:

addi "" edge-element-equality-string country

My machine pegs one of the cpus for about a minute, then the dbxml
prompt comes back. I do a 'listi' and I don't see the index in the list.
However, if I erase the database, then create it from scratch, I can create the index
and see it with listi just fine.

Obviously I am hitting some sort of limit. What can I bump? My linux box
has 4 cores, 8BG mem, all the disk space one could want. I fire up dbxml with -z 2048,
is there something I can do to increase the bdb env stuff to distance myself from these
issues? Is there a log file I can look at to see what is blowing up?

Thanks,
-g



-g
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 9 2009
Added on Aug 29 2009
4 comments
2,611 views