RE: Oracle and Unix Performance

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Mon, 11 Dec 2000 19:22:41 -0800
Message-Id: <10707.124279@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_01C063EA.C94FD410
Content-Type: text/plain

BSTAT and ESTAT can be located in:
$ORACLE_HOME/rdbms/admin (in Oracle 7.3.x)

They basically take auditing statistics of the database and produce a report.txt file with the results. You then can interpret the results by yourself or do it the lazy way by submitting it to:

http://www.oraperf.com

The report is 12 pages, so I will spare the results. I would recommend running BSTAT at a peak time and running ESTAT at a later time. Make sure you have timed_statistics = true in your init<sid>.ora file.

There is no magic parameters that a DBA views on a daily basis to tune the database. And no, I do not run the utilities via cron, but you can.

Regards,
Satar

> -----Original Message-----
> From: Viraj Luthra [SMTP:viraj999_at_lycos.com]
> Sent: Tuesday, December 12, 2000 2:21 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle and Unix Performance
>
> Hello,
>
> Thanks Satar for the comments. What do BSTAT and ESTAT recommend, I
> thought these scripts were used for volume trialing. Please if could show
> me the reporting from these tools that would be great. In addition to
> this, do you see some other parameters every other day. Also have you
> started the BSTAT or ESTAT as a regular cron job or some thing?
>
> Please if any one else also has any suggestions, please do. Any help
> greatly appreciated.
>
> Regards,
>
> Raja
>
>

------_=_NextPart_001_01C063EA.C94FD410
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>

BSTAT and = ESTAT  can be located in:
 $ORACLE_HOME/rdbms/admin  (in Oracle 7.3.x)

They basically take = auditing statistics of the database and produce a report.txt file with = the results. You then can interpret the results by yourself or do it = the lazy way by submitting it to:

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

The report is 12 = pages, so I will spare the results. I would recommend running BSTAT at = a peak time and running ESTAT at a later time. Make sure you have = timed_statistics =3D true in your init<sid>.ora file.

There is no magic = parameters that a DBA views on a daily basis to tune the database. And = no, I do not run the utilities via cron, but you can.

Regards, Satar

</P>
<BR>
<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:   Tuesday, December 12, 2000 2:21 AM To:     Multiple recipients of list ORACLE-L Subject:       = RE: Oracle and Unix = Performance

Hello,

Thanks Satar for the comments. What do = BSTAT and ESTAT recommend, I thought these scripts were used for volume = trialing. Please if could show me the reporting from these tools that = would be great. In addition to this, do you see some other parameters = every other day. Also have you started the BSTAT or ESTAT as a regular = cron job or some thing?

Please if any one else also has any = suggestions, please do. Any help greatly appreciated.

Regards, Received on Mon Dec 11 2000 - 21:22:41 CST