| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> anyone running ctxsrv program?
Hi:
8173 running on Solaris 2.8.
Does any one have experience running oracle's "ctxsrv" as background process to alleviate some locking issues? We are experiencing session piling up when sometimes Oracle Intermadia index is being built (when two sessions were updating different rows in the same table). When it happened, I ran a query and saw something like this:
SID OBJECT USERNAME
---------- ---------- ------------------------------
IMAGE LOCK_TYPEMODE_HELD
------------------------------------------------ --------------------------
29 DR$WAITING ISI
(TNS V1-V3) DML
Row-X (SX)
SID OBJECT USERNAME
---------- ---------- ------------------------------
IMAGE LOCK_TYPEMODE_HELD
------------------------------------------------ --------------------------
29 TEMPTEXT ISI
(TNS V1-V3) DML
Row-X (SX)
SID OBJECT USERNAME
---------- ---------- ------------------------------
IMAGE LOCK_TYPEMODE_HELD
------------------------------------------------ --------------------------
29 DR$TEMPTEX ISI
(TNS V1-V3) DML
Row-X (SX)
...
Usually after a few minutes, everthing is back to normal. My guess is that Oracle is somehow trying to build context index and it takes long time to do that (don't know why). I saw from the oracle doc perhaps running ctxsrv at the background would help. So what is your experience of running ctxsrv?
TIA. Guang
 |
 |