sybrandb wrote:
> On Apr 5, 3:43 pm, "Bobby" <bobby.ow..._at_talktalk.net> wrote:
>> On 5 Apr, 14:38, "gazzag" <gar..._at_jamms.org> wrote:
>>
>>
>>
>>
>>
>>> On 5 Apr, 14:30, "Bobby" <bobby.ow..._at_talktalk.net> wrote:
>>>> Hi,
>>>> Yes, I know you're probably all fed up of newbie questions and
>>>> vagueness regarding checking health of an Oracle server/database. But
>>>> hopefully you'll forgive me for this one.
>>>> I've been tasked with writing a generic component for doing an "Oracle
>>>> Health Check" as well as a "SQL Server Health Check". The purpose of
>>>> this is to add to our SLA system so that DBAs are informed when there
>>>> are performance issues, or other "potential" problems. I am fine with
>>>> SQL Server as i am very familiar with it, but have only just started
>>>> looking at Oracle.
>>>> Yes, this is very vague also and I apologise. I've looked through
>>>> various documentation and there seems to be an overwhelming amount of
>>>> information in places such as v$stat, v$lock. Loads of information
>>>> regarding cache hit ratios, CPU time, etc.
>>>> What i've decided to to is ask all of you expert DBAs in this posting
>>>> for a recommendation of the top (possibly about 5 to 10) most common
>>>> and useful stats/performance checks I can do on an Oracle database (or
>>>> server). This will be generic as we cannot really build in
>>>> functionality for all database schemas, usages, etc. Could anyone
>>>> possibly let me know which figures may be useful in most installations
>>>> of Oracle.
>>>> Many thanks in advance.
>>>> Regards
>>>> Bobby
>>> Why didn't the person who has tasked you with this work spoken to the
>>> Oracle DBA's themselves? The best person to monitor your Oracle
>>> databases would be the DBA's. I'd suggest that they have the tools
>>> and ability to do this.
>>> HTH
>>> -g- Hide quoted text -
>>> - Show quoted text -
>> Hi,
>>
>> We don't have any Oracle DBAs. Some of our customer use Oracle backend
>> databases for certain applications, but again do not have DBAs onsite.
>> By us implementing this feature in our software, we can alert certain
>> people within their company before problems arise and users start to
>> suffer. I know this doesn't sound an ideal scenario, but thats why I
>> thought it best to ask the oracle experts in their own news groups
>>
>> Regards
>>
>> Bobby- Hide quoted text -
>>
>> - Show quoted text -
>
> I like this approach. You sell a product, probably database neutral,
> you don't have any Oracle DBAs (you want to build something, not using
> any of the many products already available, which you obviously don't
> know), and now you come here for *free* advice on reinventing the
> wheel.
> Software vendors get more and more lack of scruples nowadays!
> If you don't have any inhouse Oracle knowledge I would recommend
> hiring a consultant, instead of misusing this newsgroup.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
Hi bob
Actually there is Grid Control with is quite nice an gives a lot of
information regarding what's going on , what potential problem you may
encounter ...
a lot of adviser and comes with Oracle
have a look at www.oracle.com
patrick
Received on Thu Apr 05 2007 - 21:47:25 CDT
