-
Cache memory lock
Dear All,
Recently we had migrated BI Application from Oracle version 8.1.7.0.0 to 9.2.0.5.0 but we had Cache memory lock issues in production after smoothly going through acceptance (for two months), that was attributed to bug in Oracle version 9.2.0.5.0 and a patch was applied as 9.2.0.6.0. But similar kind of issues can be still noticed (3 times in last 5 months). It happens right at the beginning of the batch, to be more specific, database goes to cache memory lock while most of my jobs are running integrity violation checks.
Any inputs on this would be highly appreciated.
Regards,
Mahesh
-
Does this problem manifest as an error returned to the client, or through the server log, or what?
-
It is manifested through server log, no info on client, client doesn't even through any error message:(
Thanks,
Maheswar
Thanks,
Mahesh
-
What errors in the server log?
Can you be a bit clearer on the errors you are seeing? By server log you mean what? alert log? Trace files? The server messages file?
Mike
Michael R. Ault
Senior Consultant
Burleson Consulting
-
Hi,
I am sorry, I am not from Oracle support, I am from Application team hence could not be clear. It is Trace files, please let me know if it still not clear.
Many thanks,
Mahesh
Thanks,
Mahesh
-
And the error is?
Can you put an extract of the trace file for us to look at?
Mike
Michael R. Ault
Senior Consultant
Burleson Consulting
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|