Re: cursor: pin S wait on X
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: smishra_97@xxxxxxxxx, Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>, sacrophyte@xxxxxxxxx
- Date: Fri, 6 Oct 2006 10:30:57 -0700 (PDT)
I have found that there lots of objects belongs to SYSTEM are invalid
and they are MAterialized view. I also have application view which become
invalid at each refresh while it is not the case on QA server but only on the
Prod server. Is there any setting that are responsible that Materialized view
are not working. I am running a job every 5 minute that is atleast compiling
the Application MV but SYSTEM are still invalid. If I run utlrp , all become
VALID and after next refresh become INVALID
As Jonathan pointed that Compilation/Invalidation can cause it and so is this
the case here
TIA
Sanjay
Sanjay Mishra <smishra_97@xxxxxxxxx> wrote:
Thanks Jonathan,Deepak, charles
I will also work on it with Support and currently will see if FALSE will work
with it
Thanks
Sanjay
Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx> wrote:
We have 2 SRs currently open for this same issue, and
ever since we set the param to FALSE, we haven't seen
the issue repeat (so, yes it's mutex related). We saw
a case where 1 session blocks another, we have also
seen this happening with parallel process, where
parent and child get locked on each other.
5737552.993 - SESSION WAITING VERY LONG ON 'LATCH:
LIBRARY CACHE'
5703409.993 - SESSION HANGS DUE TO WAITS ASSOCIATED
WITH ENQ: PS - CONTENTION
HTH,
Deepak
--- Charles Schultz wrote:
> 10.2 turns on mutexes by default. The short-term
> workaround is to turn off
> mutexes (_kks_use_mutex_pin = FALSE). There are
> several related bugs,
> notably:
> 5184776 10.2.0.2.0 RDBMS 10.2.0.2.0 PRODID-5
> PORTID-23
> Abstract: HIGH 'CURSOR: PIN S WAIT ON X'
>
> We had one database that blocked on some dictionary
> objects, prohibiting all
> logins (even as sysdba). Unfortunately, since we
> were not able to reproduce,
> we had to close the case as Oracle wanted a
> hanganalyze. If you can get more
> information from various mutex related views, I
> strongly advise you open a
> case with Oracle.
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------------
Want to be your own boss? Learn how on Yahoo! Small Business.
---------------------------------
Want to be your own boss? Learn how on Yahoo! Small Business.
Other related posts:
