Re: Do missing binds prevent creation of baseline?

From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Mon, 15 Apr 2013 09:42:32 -0500 (CDT)
Message-ID: <1aada97fc54e3156a14d02d332bc9b5e.squirrel_at_society.servebeer.com>

Nigel writes:

> Is the PK index status UNUSABLE? could the DB crash have happened at an
> inconvenient point in a batch data load, for example?

Sorry, I should have included an assumption that all objects are fine.

While I do have some workarounds (e.g. stats) in play, I'm more concerned with the fact that I can't use this particular solution or determine why it doesn't work.

Support had me use their SQLT tool. It's much more "intrusive" than I'd normally like to use on a critical production DB, but the output it generates is impressive.

Thanks!
Rich

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Apr 15 2013 - 16:42:32 CEST

This message: [ Message body ]
Next message: Jeffrey Beckstrom: "how to determine number of chained rows"
Previous message: Hans Forbrich: "Re: Query does not work in RAC"
Maybe in reply to: Rich Jesse: "Do missing binds prevent creation of baseline?"
Next in thread: Dominic Brooks: "RE: Do missing binds prevent creation of baseline?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message