Re: session_cached_cursors and ora-07745
- From: Robyn <robyn.sands@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 15 Mar 2005 18:17:22 -0500
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@xxxxxxxxxxx> 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. :-)
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
