| Oracle text and locking issue [message #595663] |
Thu, 12 September 2013 12:21  |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
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,
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
