Cache memory lock
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Cache memory lock

  1. #1
    Join Date
    Apr 2005
    Posts
    3

    Angry 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

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Does this problem manifest as an error returned to the client, or through the server log, or what?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Apr 2005
    Posts
    3
    It is manifested through server log, no info on client, client doesn't even through any error message:(

    Thanks,
    Maheswar
    Thanks,
    Mahesh

  4. #4
    Join Date
    Apr 2005
    Posts
    17

    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

  5. #5
    Join Date
    Apr 2005
    Posts
    3
    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

  6. #6
    Join Date
    Apr 2005
    Posts
    17

    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
  •  


Click Here to Expand Forum to Full Width