ctx indexes and performance problem [message #353174] |
Sun, 12 October 2008 04:13 |
pmapc
Messages: 46 Registered: July 2008
|
Member |
|
|
hi,
I really have very bad performance problem with my ctx indexes.
after doing these steps I will face the problem:
1-I clean the database and remove all of my test data.
2-recreate(drop and create) the indexes (normal and domain) on my main table.
3-export the schema(user) using expdp tool.
4-import the dump file (schema) to production server this.
5-insert 50000 records to the main table.
6-execute CTX_DDL.SYNC_INDEX command to synchronize its 8 domain indexes.
the step 6 takes 3 hours on my production server just for the first time that I execute the CTX_DDL.SYNC_INDEX and it mainly uses CPU(it is really too slow) whereas performing step 6 in my development server just take 3 min, but if I make my dump file with 50000 records in the main table and continue the other steps and then executing CTX_DDL.SYNC_INDEX it works fine without taking too much time on production server.
I really don't know is there something wrong with my export process or is it normal,any idea about what is wrong?
thanks,
|
|
|