Re: Help with intermittant slow down

DA Morgan wrote:
<Big snip>
>
> And the Oracle version number is?
>

Dang! I'm sorry, I should have had the presence of mind to say that we're running Oracle 9i (9.2) on a Unix box (not sure what flavor, assume Sun Solaris)

> Assuming 9i you want to pull a baseline StatsPack when things are normal
> and then keep pulling them every 15-20 minutes through a slow period.
>

> And the operating system is?
>
> Assuming UNIX pull sar, iostat, vmstat, etc. when things are normal as
> a baseline and again periodically including when things slow down.
>

Thanx. That all sounds very sensible.

> Lack of facts makes it impossible to fix anything.
For sure!

>
> <RANT>
> If management will not support you with training, and will not support
> you with a consultant, and will not support you with sufficient money
> to hire what you need.
>
> Then management is being abusive and you need to polish up your resume
> and leave them with 2 weeks notice and nothing more. You are being set
> up for failure. And likely unpaid overtime, headaches, high blood
> pressure and then failure.
> </RANT>

<MODIFIED RANT>
I cant say you're all wrong, but the situation is somewhat complicated. We're a "Non Profit" and squeezed for funds on all ends. The management structure evolved (if thats the word) in the 19th century and shows the effects of being highly tuned for last centuries problems and technical/social environment. A confluence of unlucky stars (this one's on vacation, that one had a death in the family, etc) combined with very shallow depth of support (nobody has an assistant that can do or "almost" do everything the primary actor can do) leaves us vulnerable to a Murphy's law attack. Since I do have some Oracle experience as a developer (not DBA) and some techy background (I can spell Unix, and am buzz word compliant) I'm trying to "rise to the occasion" by hitting the books and by shamelessly begging for a boost from anyone who actually knows something. This is not my usual beat!
</MODIFIED RANT>

Thanx again for the advice. Received on Sat Jun 25 2005 - 09:26:50 CDT