Scripts for tuning in 8.1.6

2001-07-17 Thread Eca Eca


Hi Friends :

Does anyone have some good prepared scripts for tuning in database.

And how to use it in Linux ?

I know that it is necessary to run several times and to calculate some 
statistics using the result of the queries.

Regards

Eriovaldo


_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eca Eca
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



Re: Scripts for tuning in 8.1.6

2001-07-17 Thread Jon Walthour

Eca:

A great place to start would be bstat/estat or stats pack. After that, I'd
pick up Richard Niemac's book on Performance Tuning. Then, I'd round that
off with a look at Steve Adams' website http://www.ixora.com.au when you're
ready for it (it's pretty advanced).

--

Jon Walthour, OCDBA
Oracle DBA
Cincinnati, Ohio

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 17, 2001 10:05 PM


>
> Hi Friends :
>
> Does anyone have some good prepared scripts for tuning in database.
>
> And how to use it in Linux ?
>
> I know that it is necessary to run several times and to calculate some
> statistics using the result of the queries.
>
> Regards
>
> Eriovaldo
>
>
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Eca Eca
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jon Walthour
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



RE: Scripts for tuning in 8.1.6

2001-07-19 Thread Christopher Spence

www.ixora.com.au has many many scripts for such tasks.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Tuesday, July 17, 2001 10:05 PM
To: Multiple recipients of list ORACLE-L



Hi Friends :

Does anyone have some good prepared scripts for tuning in database.

And how to use it in Linux ?

I know that it is necessary to run several times and to calculate some 
statistics using the result of the queries.

Regards

Eriovaldo


_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eca Eca
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



RE: Scripts for tuning in 8.1.6

2001-07-20 Thread Ramon Estevez

si, todo listo

Ramón Estévez



*809-565-3121 x 225



* [EMAIL PROTECTED]





-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Christopher
Spence
Enviado el: Thursday, 19 July, 2001 9:22 AM
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Scripts for tuning in 8.1.6


www.ixora.com.au has many many scripts for such tasks.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot



-Original Message-
Sent: Tuesday, July 17, 2001 10:05 PM
To: Multiple recipients of list ORACLE-L



Hi Friends :

Does anyone have some good prepared scripts for tuning in database.

And how to use it in Linux ?

I know that it is necessary to run several times and to calculate some
statistics using the result of the queries.

Regards

Eriovaldo


_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eca Eca
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ramon Estevez
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).