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