Lee wrote:
> 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.
Given that you are a non-profit contact your local Oracle rep and
see if they know anyone willing to donate some time: If not hands-on
at least as a mentor to you. Also check, if you have one, your local
Oracle user group.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sat Jun 25 2005 - 10:03:51 CDT
