RE: Oracle and Unix Performance

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Mon, 11 Dec 2000 11:29:00 -0800
Message-Id: <10707.124227@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C063A8.9CDE4E10
Content-Type: text/plain

to be honest, it's hard to take a proactive approach on performance tuning in a diverse database environment. I basically look at what queries the users usually execute on a frequent basis and see if I can improve the performance of those queries any. I also run BSTAT and ESTAT every two weeks to see what it recommends. I watch the alert log and walk around and speak with the users and basically see what they see.

Regards,
Satar

> -----Original Message-----
> From: Viraj Luthra [SMTP:viraj999_at_lycos.com]
> Sent: Sunday, December 10, 2000 8:26 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle and Unix Performance
>
> Hello all,
>
> I sent 1 message before on this mailing list but not sure where it
> disappeared.
>
> Any way folks I need your help. I need to know what parameters you DBA's
> and System Administrators(SA) would like to see in a performance
> monitoring tool. Specifically what parameters does a DBA or a SA look for
> each morning so as to confirm that there systems are working properly or
> are tuned properly.
>
> What performance metrics do you look for day in and day out so that you
> are always aware that the systems are working to the desired levels of
> performace. Please I need a speedy reply.
>
> Thanks and Regards,
>
> Raja
>
>
> Get FREE Email/Voicemail with 15MB at Lycos Communications at
> http://comm.lycos.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Viraj Luthra
> INET: viraj999_at_lycos.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

------_=_NextPart_001_01C063A8.9CDE4E10
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: Oracle and Unix Performance</TITLE>
</HEAD>
<BODY>

to be honest, it's = hard to take a proactive approach on performance tuning in a diverse = database environment. I basically look at what queries the users = usually execute on a frequent basis and see if I can improve the = performance of those queries any. I also run BSTAT and ESTAT every two = weeks to see what it recommends. I watch the alert log and walk around = and speak with the users and basically see what they see.

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Regards,</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Satar</FONT>
</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =

SIZE=3D1 FACE=3D"Arial">Viraj Luthra [SMTP:viraj999_at_lycos.com] Sent:   Sunday, December 10, 2000 8:26 PM To:     Multiple recipients of list ORACLE-L Subject:       = Oracle and Unix Performance

Hello all,

I sent 1 message before on this = mailing list but not sure where it disappeared.

Any way folks I need your help. I need = to know what parameters you DBA's and System Administrators(SA) would = like to see in a  performance monitoring tool. Specifically what = parameters does a DBA or a SA look for each morning so as to confirm = that there systems are working properly or are tuned properly. =

What performance metrics do you look = for day in and day out so that you are always aware that the systems = are working to the desired levels of performace. Please I need a speedy = reply.

Thanks and Regards,

<P><FONT SIZE=3D2 FACE=3D"Arial">Raja</FONT>
</P>
<BR>

Get FREE Email/Voicemail with 15MB at = Lycos Communications at <A HREF=3D"http://comm.lycos.com" = TARGET=3D"_blank">http://comm.lycos.com</A>

<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Please see the official ORACLE-L =
FAQ:</FONT><U> <FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial"><A =

HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Viraj Luthra</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =

viraj999_at_lycos.com

Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 San Diego, = California        -- Public Internet = access / Mailing Lists
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

-----------
 To REMOVE yourself from this mailing = list, send an E-Mail message
 to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru') and in
 the message BODY, include a line = containing: UNSUB ORACLE-L
 (or the name of mailing list you want = to be removed from).  You may also send the HELP command for other = Received on Mon Dec 11 2000 - 13:29:00 CST