Re: session_cached_cursors and ora-07745

Ross,

Yes, there are other issues with this particular db and I'm investigating them. Primarily, there's been a 'Ioctl ASYNC_CONFIG error, errno = 1' in the trace files and I've sent a request to our sys admin to make sure the dba group has the proper system privs. Based on note Note:139272.1, I suspect that it does not.

1. The production databases that are using SCC are 9.2.0.5 or 9.2.0.3.
2. SCC has been in use since this database was created in Jan, but it's only set to 100.
3. SCC is currently turned off, and the 7445 errors did stop (and the db started)
4. If I turn it on again, the errors do return, sometimes the database starts
5. This instance is not under a heavy load - it's being used to test AQ and message load is very light right now.
6. I haven't set up statspack or debugging on this one - didn't expect to keep it around much longer. Then these errors started and it's my favorite sandbox today.

I'm primarily wondering if I need to consider removing the SCC parameter from the production 9.2.0.6 databases; I'm going to be patching 4 of them this weekend and I'd hate to see this happen on next Monday morning.

I'm afraid I've never installed the OHPO and my holster of silver bullets ran out a long time ago ... :)

Robyn  

On Tue, 15 Mar 2005 22:36:08 -0000, Mohan, Ross <RMohan_at_arbinet.com> wrote:
> test/dev instance...7445...."other 920 databases" (which full versions?)...due to....what?
>
> Usually there's *something* in the u/bdump traces that indicates root cause. Is there some
> reason you've assumed the cursor caching is causal (as opposed to coincident)?
>
> Some questions that come to mind.
>
> - what are full versions of other DBs?
> - any other trace files concurrent?
> - when was session_cached_cursors changed on the test/qa box?
> - how long was parameter in play before the 7445?
> - was the instance under steady, sporadic, episodic (i.e. "rollout") or unusual load?
> - have you set the parameter down or off (assuming, since this is test/qa, you have that
> option)
> - can you 'instrument' your apps to track cursor usage?
> - is statspack running in there, and can you tracked current/cumulative open cursors
> over time?
>
> I'd say "try truncating the URL_PAGES table" but I don't know if you have the Oracle
> High Performance Option (OHPO) installed. :-)
>
>

--
http://www.freelists.org/webpage/oracle-l