problems after a Database rebuild Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: problems after a Database rebuild

  1. #1
    Join Date
    Nov 2003

    problems after a Database rebuild

    We recently decided to export/import our database so it would rebuild the tablespaces and eliminate fragmentation. We also increased the size of some DB files(and tablespaces). Everything seemed to go smooth but then the locks started.
    We have been getting several locks on one table during high DB activity -sometimes lasting for 20 - 30 min. This is a 5.5 million row table and seems to be the only spot of trouble. We have examined everything we could think of and are running out of ideas.
    Has anyone heard of a similar problem ??
    timeouts in - Library Cache pin and Latch free waits
    DBWR scan depth is bit high
    logical I/O consistent reads are high

  2. #2
    Join Date
    Mar 2002
    Mesa, Arizona
    Is the application doing anything different?

    How big is your library cache?
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #3
    Join Date
    Jan 2001
    Did you do an analyze?
    I remember when this place was cool.

  4. #4
    Join Date
    Nov 2003
    Just a hint...
    I guess u already would have looked at ur INITRANS and FREELISTS
    Might be those would have change when u import them.

    Amish Chudasama

  5. #5
    Join Date
    Nov 2003

    still on 8.15

    I have looked at the analyze, initrans and appication changes - it is none of those. We are still on 8.15 and I hear there is a bug in the full import command of that release that causes users to lock on their own transactions - I will need to explore metalink to find that info.
    Has anyone tried disabling dml locks on a table ?? what are the consequences??

  6. #6
    Join Date
    Aug 2002
    Colorado Springs

    Re: still on 8.15

    Originally posted by steveb
    Has anyone tried disabling dml locks on a table ?? what are the consequences??
    How would you do that? Sounds like a terrible idea.

    Incidentally, that whole export/import defrag thing sucks.
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

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