Database Software

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!

Oracle text and locking issue

orausernSep 12 2013 — edited Sep 13 2013

Hi Experts,

I am on Oracle 11.2.0.3 on Linux. I have implemented Oracle text in my database. My production dba was telling me today that there are some locking issues in production and he has sent me an ASH report. I can post that ASH in a seperate email thread, but first in this post wanted to ask that are there any known problems with Oracle text that it causes locks or locking related waits? I read somewhere that oracle text indexes get defragmented over time. My text indexes are defined as sync on commit. Do they, for example, need to be rebuilt over time - by say dropping and recreating them? What should be the frequency of doing this?

I will be most thankful for any pointer on this.

regards,

OraserN

This post has been answered by Barbara Boehmer on Sep 12 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 11 2013

Added on Sep 12 2013

#database-key-features, #text

6 comments

3,538 views