Regarding Open cursors,Replication

From: Suganya <ukumsu02_at_shafika.vetri.com>
Date: Tue, 07 Nov 2000 15:29:03 +0530
Message-Id: <10673.121279@fatcity.com>

This is a multi-part message in MIME format. --------------0FE7D86D783DDE4728663EA5
Content-Type: multipart/alternative;
boundary="------------8CD942A810B207DEF35A0989"

--------------8CD942A810B207DEF35A0989
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Any one Please reply me regarding the catrep.sql functionality and if we want to run it what's the number we have to specify for the OPEN_CURSORS in the INIT.ORA.
And explain me what are al the prerequistes for executing that. I already executed the catrep.sql once and it gave the errors as in the attached file. Hence I executed the catnorep.sql as well as catrepr.sql to remove the replication packages and other objects related to Replication.

Regards
Suganya

Alex Hillman wrote:

>
>
> What is the pricing?
>
> Alex Hillman
>
> -----Original Message-----
> From: Mark Leith [mailto:mark_at_cool-tools.co.uk]
> Sent: Friday, November 03, 2000 10:31 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: SQL Tuning
>
> I have a suggestion for what I feel is the best SQL optimisation tool
> in the
> market! It's a tool called SQLExpert from a company called Leccotech.
>
> This tool uses a feedback engine which looks at the structure of the
> database, and then rewrites as many semantically equivalent statements
> as is
> possible - automatically - for you! You can then run these alternate
> statements through an automated process to determine which statement
> has
> either the best response or elapsed times. Then generate a lovely
> little
> report for the damagement!
>
> The tool comes in either Developer or DBA editions, so you can have a
> developer looking at SQL from source, and developing new SQL, and the
> DBA
> gets an extra interactive module that looks at the SOLARIA and alike,
> and
> harvests "bad" SQL through criteria - PROCESS/USERNAME/HIGH BUFFER
> GETS
> etc..
>
> Take a look at www.leccotech.com to learn more about it..
>
> Also available through Cool-Tools :)
>
> Mark
>
> Mark Leith
> =================
> Cool Tools UK Ltd
> +44 1905 330 281
> mark_at_cool-tools.co.uk
>
> P.S sorry about the plug..
>
> ------
>
> Does anyone have any suggestion on a good SQL Tunning tool.
>
> Thanks
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark Leith
> INET: mark_at_cool-tools.co.uk
>
> 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).

--------------8CD942A810B207DEF35A0989
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html>
Hi

<br>&nbsp;&nbsp;&nbsp; Any one Please reply me regarding the <font color="#3366FF">catrep.sql&nbsp;&nbsp;
</font><font color="#000000">f</font>unctionality
<br>and if we want to run it what's the number we have to specify for
<br>the OPEN_CURSORS in the INIT.ORA.
<br>And explain me what are al the prerequistes for executing that.
<br>I already executed the catrep.sql once and it gave the errors as
<br>in the attached file. Hence I executed the catnorep.sql as well
<br>as catrepr.sql to remove the replication packages and other
<br>objects related to Replication.
<p>Regards
<br>Suganya
<br>&nbsp;
<p>Alex Hillman wrote:
<blockquote TYPE=CITE>&nbsp;
<p><font size=-1>What is the pricing?</font>
<p><font size=-1>Alex Hillman</font>
<p><font size=-1>-----Original Message-----</font>
<br><font size=-1>From: Mark Leith [<a href="mailto:mark_at_cool-tools.co.uk">mailto:mark_at_cool-tools.co.uk</a>]</font>
<br><font size=-1>Sent: Friday, November 03, 2000 10:31 AM</font>
<br><font size=-1>To: Multiple recipients of list ORACLE-L</font>
<br><font size=-1>Subject: RE: SQL Tuning</font>
<p><font size=-1>I have a suggestion for what I feel is the best SQL optimisation

tool in the
 market! It's a tool called SQLExpert from a company called Leccotech.
This tool uses a feedback engine which looks at the structure of the
 database, and then rewrites as many semantically equivalent statements as is
 possible - automatically - for you! You can then run these alternate
 statements through an automated process to determine which statement has
 either the best response or elapsed times. Then generate a lovely little
 report for the damagement! The tool comes in either Developer or DBA editions, so you can have a
 developer looking at SQL from source, and developing new SQL, and the DBA
 gets an extra interactive module that looks at the SOLARIA and alike, and

<br><font size=-1>harvests "bad" SQL through criteria - PROCESS/USERNAME/HIGH
BUFFER GETS</font>
<br><font size=-1>etc..</font>
<p><font size=-1>Take a look at www.leccotech.com to learn more about it..</font>
<p><font size=-1>Also available through Cool-Tools :)</font>
<p><font size=-1>Mark</font>
<p><font size=-1>Mark Leith</font>
<br><font size=-1>=================</font>
<br><font size=-1>Cool Tools UK Ltd</font>
<br><font size=-1>+44 1905 330 281</font>
<br><font size=-1>mark_at_cool-tools.co.uk</font>
<p><font size=-1>P.S sorry about the plug..</font>

------
Does anyone have any suggestion on a good SQL Tunning tool.

<p><font size=-1>Thanks</font>
<p><font size=-1>--</font>
<br><font size=-1>Please see the official ORACLE-L FAQ: http://www.orafaq.com</font>
<br><font size=-1>--</font>
<br><font size=-1>Author: Mark Leith</font>
<br><font size=-1>&nbsp; INET: mark_at_cool-tools.co.uk</font>
<p><font size=-1>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp;

FAX: (858) 538-5051
 San Diego, California        -- Public Internet access / Mailing Lists

<br><font size=-1>--------------------------------------------------------------------</font>

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).</blockquote>
</html>

--------------8CD942A810B207DEF35A0989--

--------------0FE7D86D783DDE4728663EA5
Content-Type: text/plain; name="param_catrep.txt"
Content-Transfer-Encoding: 7bit

Received on Tue Nov 07 2000 - 03:59:03 CST