Re: Cusror: Pin S wait in X

On Mon, 18 Dec 2017 21:59:36 +0000 (UTC) "Sanjay Mishra" <dmarc-noreply_at_freelists.org> (Redacted sender "smishra_97" for DMARC) wrote:

> Can some one suggest what can be done to stop these wait as it coming as topmost event for multiple SID ?�I tried to following 786507.1 doc to identify the session but if I kill one session another one comes up. I even bounced the Instance one by one but this still continues. Any suggestion as else had to open Oracle ticket due to slowness been reported. Ashtop�shows all top 20 listed process with same Waiteven and with one same SQL id
> TIASanjay

CURSOR_SPACE_FOR_TIME is probably your best bet. However, there may be some issues with that parameter. You may need few additional KB of RAM.

-- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
--
http://www.freelists.org/webpage/oracle-l