anyone running ctxsrv program?
- From: "Guang Mei" <gmei@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 9 Jun 2004 15:44:09 -0400
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_TYPE
------------------------------------------------ --------------------------
MODE_HELD
----------------------------------------
MODE_REQUESTED
----------------------------------------
29 DR$WAITING ISI
(TNS V1-V3) DML
Row-X (SX)
None
SID OBJECT USERNAME
---------- ---------- ------------------------------
IMAGE LOCK_TYPE
------------------------------------------------ --------------------------
MODE_HELD
----------------------------------------
MODE_REQUESTED
----------------------------------------
29 TEMPTEXT ISI
(TNS V1-V3) DML
Row-X (SX)
None
SID OBJECT USERNAME
---------- ---------- ------------------------------
IMAGE LOCK_TYPE
------------------------------------------------ --------------------------
MODE_HELD
----------------------------------------
MODE_REQUESTED
----------------------------------------
29 DR$TEMPTEX ISI
(TNS V1-V3) DML
Row-X (SX)
None
...
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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
- » anyone running ctxsrv program?
