DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: library cache lock while exchanging the partition

  1. #1
    Join Date
    Sep 2008
    Posts
    10

    library cache lock while exchanging the partition

    While exchanging the partition, I am observing significant wait on "Library Cache lock". Is it a bug? is anyone there who experienced the same issue?


    Database release 10.2.0.3

    ALTER TABLE PSALESREG EXCHANGE PARTITION P123
    WITH TABLE PBKPSALESREF WITHOUT VALIDATION


    call count cpu elapsed disk query current rows
    ------- ------ -------- ---------- ---------- ---------- ---------- ----------
    Parse 1 0.00 0.00 0 0 0 0
    Execute 1 0.11 6684.73 2 9 2 0
    Fetch 0 0.00 0.00 0 0 0 0
    ------- ------ -------- ---------- ---------- ---------- ---------- ----------
    total 2 0.11 6684.73 2 9 2 0

    Misses in library cache during parse: 1
    Optimizer mode: ALL_ROWS

    Elapsed times include waiting on following events:
    Event waited on Times Max. Wait Total Waited
    ---------------------------------------- Waited ---------- ------------
    library cache lock 2274 3.12 6681.32


    Rgds

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Are you trying to exchange partition at a time the affected partition is in use?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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