Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Performance tuning

RE: Performance tuning

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Tue, 7 Nov 2000 15:28:49 -0800
Message-Id: <10673.121377@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_01C04912.7B9CB070
Content-Type: text/plain

Oracle's utility...

BSTAT/ESTAT do a search on *bstat* on your file system in the oracle home directory.

Regards,
Satar

> -----Original Message-----
> From: Roy Ferguson [SMTP:rferguso_at_level1.com]
> Sent: Tuesday, November 07, 2000 9:56 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Performance tuning
>
>
> can I get some feedback from dba's out there have have a top 10 or so list
> of
> things they regularly look for when doing performance tuning?...what
> things do
> you look at or for to determine the overall status of a database?
>
> thanks in advance...roy
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Roy Ferguson
> INET: rferguso_at_level1.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_01C04912.7B9CB070
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: Performance tuning</TITLE>
</HEAD>
<BODY>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Oracle's = utility...</FONT>
</P>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">BSTAT/ESTAT</FONT> </P>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">do a search on = *bstat*&nbsp; on your file system in the oracle home directory.</FONT> </P>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Regards,<BR> 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">Roy Ferguson [SMTP:rferguso_at_level1.com]</FONT> <BR><B><FONT SIZE=3D1 FACE=3D"Arial">Sent:&nbsp;&nbsp;</FONT></B> <FONT = SIZE=3D1 FACE=3D"Arial">Tuesday, November 07, 2000 9:56 PM</FONT> <BR><B><FONT SIZE=3D1 =
FACE=3D"Arial">To:&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> <FONT SIZE=3D1 = FACE=3D"Arial">Multiple recipients of list ORACLE-L</FONT> <BR><B><FONT SIZE=3D1 =
FACE=3D"Arial">Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT>=
</B> <FONT SIZE=3D1 FACE=3D"Arial">Performance tuning</FONT>
</P>
<BR>

<P><FONT SIZE=3D2 FACE=3D"Arial">can I get some feedback from dba's out = there have have a top 10 or so list of </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">things they regularly look for when = doing performance tuning?...what things do </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">you look at or for to determine the = overall status of a database?</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">thanks in advance...roy</FONT> </P>

<P><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></FONT></U>

<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Roy Ferguson</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =
rferguso_at_level1.com</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Fat City Network = Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) = 538-5051</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">San Diego, = California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=
-----------</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">To REMOVE yourself from this mailing = list, send an E-Mail message</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">the message BODY, include a line = containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">(or the name of mailing list you want = to be removed from).&nbsp; You may</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">also send the HELP command for other = Received on Tue Nov 07 2000 - 17:28:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US