Catrep.sql

From: Suganya <ukumsu02_at_shafika.vetri.com>
Date: Thu, 09 Nov 2000 17:36:00 +0530
Message-Id: <10675.121547@fatcity.com>

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

Hi all
      After executing the catrep.sql still lot of packages are seems to

be invalid. After that I executed the

r0703040.sql
utlrp.sql which are optional sql's recomended by the oracle corporation
to rerun the packages which are in a invalid mode Even after that 76 rows are in the invalid status. Please give me some tips to solve this problem. FYI

OBJECT_NAME                    OBJECT_TYPE
------------------------------ ------------------
NameFromLastDDL                FUNCTION
DBMSOBJG                       PACKAGE
DBMSOBJG                       PACKAGE BODY
DBMSOBJG2                      PACKAGE
DBMSOBJG2                      PACKAGE BODY
DBMSOBJGWRAPPER                PACKAGE BODY
DBMS_ASYNCRPC_PUSH             PACKAGE BODY
DBMS_DEFER                     PACKAGE BODY
DBMS_DEFERGEN                  PACKAGE
DBMS_DEFERGEN                  PACKAGE BODY
DBMS_DEFERGEN_AUDIT            PACKAGE


OBJECT_NAME                    OBJECT_TYPE
------------------------------ ------------------
DBMS_DEFERGEN_AUDIT            PACKAGE BODY
DBMS_DEFERGEN_INTERNAL         PACKAGE
DBMS_DEFERGEN_INTERNAL         PACKAGE BODY
DBMS_DEFERGEN_LOB              PACKAGE
DBMS_DEFERGEN_LOB              PACKAGE BODY
DBMS_DEFERGEN_PRIORITY         PACKAGE BODY
DBMS_DEFERGEN_RESOLUTION       PACKAGE
DBMS_DEFERGEN_RESOLUTION       PACKAGE BODY
DBMS_DEFERGEN_UTIL             PACKAGE
DBMS_DEFERGEN_UTIL             PACKAGE BODY
DBMS_DEFERGEN_WRAP             PACKAGE


OBJECT_NAME                    OBJECT_TYPE
------------------------------ ------------------
DBMS_DEFERGEN_WRAP             PACKAGE BODY
DBMS_DEFER_IMPORT_INTERNAL     PACKAGE BODY
DBMS_DEFER_INTERNAL_QUERY      PACKAGE BODY
DBMS_DEFER_INTERNAL_SYS        PACKAGE BODY
DBMS_DEFER_QUERY               PACKAGE BODY
DBMS_DEFER_REPCAT              PACKAGE BODY
DBMS_DEFER_SYS                 PACKAGE
DBMS_DEFER_SYS                 PACKAGE BODY
DBMS_DEFER_SYS_PART1           PACKAGE BODY
DBMS_INTERNAL_REPCAT           PACKAGE BODY
DBMS_MAINT_GEN                 PACKAGE BODY


OBJECT_NAME                    OBJECT_TYPE
------------------------------ ------------------
DBMS_OFFLINE_INTERNAL          PACKAGE BODY
DBMS_OFFLINE_OG                PACKAGE BODY
DBMS_OFFLINE_SNAPSHOT          PACKAGE BODY
DBMS_OFFLINE_UTL               PACKAGE
DBMS_OFFLINE_UTL               PACKAGE BODY
DBMS_RECTIFIER_DIFF            PACKAGE BODY
DBMS_RECTIFIER_FRIENDS         PACKAGE BODY
DBMS_REPCAT                    PACKAGE BODY
DBMS_REPCAT_ADMIN              PACKAGE BODY
DBMS_REPCAT_CACHE              PACKAGE
DBMS_REPCAT_CACHE              PACKAGE BODY


OBJECT_NAME                    OBJECT_TYPE
------------------------------ ------------------
DBMS_REPCAT_CONF               PACKAGE BODY
DBMS_REPCAT_DECL               PACKAGE
DBMS_REPCAT_DECL               PACKAGE BODY
DBMS_REPCAT_FLA                PACKAGE
DBMS_REPCAT_FLA                PACKAGE BODY
DBMS_REPCAT_FLA_MAS            PACKAGE BODY
DBMS_REPCAT_FLA_UTL            PACKAGE
DBMS_REPCAT_FLA_UTL            PACKAGE BODY
DBMS_REPCAT_INSTANTIATE        PACKAGE BODY
DBMS_REPCAT_INTERNAL           PACKAGE BODY
DBMS_REPCAT_MAS                PACKAGE


OBJECT_NAME                    OBJECT_TYPE
------------------------------ ------------------
DBMS_REPCAT_MAS                PACKAGE BODY
DBMS_REPCAT_MIG                PACKAGE BODY
DBMS_REPCAT_MIG_INTERNAL       PACKAGE BODY
DBMS_REPCAT_RPC                PACKAGE BODY
DBMS_REPCAT_RPC_UTL            PACKAGE BODY
DBMS_REPCAT_SNA                PACKAGE
DBMS_REPCAT_SNA                PACKAGE BODY
DBMS_REPCAT_SNA_UTL            PACKAGE
DBMS_REPCAT_SNA_UTL            PACKAGE BODY
DBMS_REPCAT_UNTRUSTED          PACKAGE
DBMS_REPCAT_UNTRUSTED          PACKAGE BODY


OBJECT_NAME                    OBJECT_TYPE
------------------------------ ------------------
DBMS_REPCAT_UTL                PACKAGE
DBMS_REPCAT_UTL                PACKAGE BODY
DBMS_REPCAT_UTL2               PACKAGE BODY
DBMS_REPCAT_UTL3               PACKAGE
DBMS_REPCAT_UTL3               PACKAGE BODY
DBMS_REPCAT_UTL4               PACKAGE
DBMS_REPCAT_UTL4               PACKAGE BODY
DBMS_REPCAT_VALIDATE           PACKAGE BODY
DBMS_REPUTIL                   PACKAGE BODY
_ALL_REPCOLUMN                 VIEW

76 rows selected.

Thanks in advance
Suganya

Suganya wrote:

> Hi
> 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).
>

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

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

Hi all       After executing the catrep.sql still lot of packages are seems to be invalid. After that I executed the
    r0703040.sql    utlrp.sql which are optional sql's recomended by the oracle corporation

<br><b><font color="#3366FF">to rerun the packages which are in a invalid
mode</font></b>
<br><b><font color="#3366FF">Even after that 76 rows are in the invalid

status.
 Please give me some tips  to solve this problem.
 FYI OBJECT_NAME                    OBJECT_TYPE

<br><b><font color="#3366FF">------------------------------ ------------------</font></b>

NameFromLastDDL                FUNCTION

<br><b><font color="#3366FF">DBMSOBJG&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">DBMSOBJG&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

PACKAGE BODY

<br><b><font color="#3366FF">DBMSOBJG2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">DBMSOBJG2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

PACKAGE BODY
 DBMSOBJGWRAPPER                PACKAGE BODY
 DBMS_ASYNCRPC_PUSH             PACKAGE BODY
 DBMS_DEFER                     PACKAGE BODY

<br><b><font color="#3366FF">DBMS_DEFERGEN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">DBMS_DEFERGEN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

PACKAGE BODY

<br><b><font color="#3366FF">DBMS_DEFERGEN_AUDIT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">&nbsp;</font></b>
<br><b><font color="#3366FF">&nbsp;</font></b>
<br><b><font color="#3366FF">OBJECT_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

OBJECT_TYPE

<br><b><font color="#3366FF">------------------------------ ------------------</font></b>

DBMS_DEFERGEN_AUDIT            PACKAGE BODY

<br><b><font color="#3366FF">DBMS_DEFERGEN_INTERNAL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">DBMS_DEFERGEN_INTERNAL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

PACKAGE BODY

<br><b><font color="#3366FF">DBMS_DEFERGEN_LOB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">DBMS_DEFERGEN_LOB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

PACKAGE BODY
 DBMS_DEFERGEN_PRIORITY         PACKAGE BODY

<br><b><font color="#3366FF">DBMS_DEFERGEN_RESOLUTION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">DBMS_DEFERGEN_RESOLUTION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

PACKAGE BODY

<br><b><font color="#3366FF">DBMS_DEFERGEN_UTIL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">DBMS_DEFERGEN_UTIL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

PACKAGE BODY

<br><b><font color="#3366FF">DBMS_DEFERGEN_WRAP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">&nbsp;</font></b>
<br><b><font color="#3366FF">&nbsp;</font></b>
<br><b><font color="#3366FF">OBJECT_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

OBJECT_TYPE

<br><b><font color="#3366FF">------------------------------ ------------------</font></b>

DBMS_DEFERGEN_WRAP             PACKAGE BODY
 DBMS_DEFER_IMPORT_INTERNAL     PACKAGE BODY
 DBMS_DEFER_INTERNAL_QUERY      PACKAGE BODY
 DBMS_DEFER_INTERNAL_SYS        PACKAGE BODY
 DBMS_DEFER_QUERY               PACKAGE BODY
 DBMS_DEFER_REPCAT              PACKAGE BODY

<br><b><font color="#3366FF">DBMS_DEFER_SYS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">DBMS_DEFER_SYS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

PACKAGE BODY
 DBMS_DEFER_SYS_PART1           PACKAGE BODY
 DBMS_INTERNAL_REPCAT           PACKAGE BODY
 DBMS_MAINT_GEN                 PACKAGE BODY

<br><b><font color="#3366FF">&nbsp;</font></b>
<br><b><font color="#3366FF">&nbsp;</font></b>
<br><b><font color="#3366FF">OBJECT_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

OBJECT_TYPE

<br><b><font color="#3366FF">------------------------------ ------------------</font></b>

DBMS_OFFLINE_INTERNAL          PACKAGE BODY
 DBMS_OFFLINE_OG                PACKAGE BODY
 DBMS_OFFLINE_SNAPSHOT          PACKAGE BODY

<br><b><font color="#3366FF">DBMS_OFFLINE_UTL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">DBMS_OFFLINE_UTL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

PACKAGE BODY
 DBMS_RECTIFIER_DIFF            PACKAGE BODY
 DBMS_RECTIFIER_FRIENDS         PACKAGE BODY
 DBMS_REPCAT                    PACKAGE BODY
 DBMS_REPCAT_ADMIN              PACKAGE BODY

<br><b><font color="#3366FF">DBMS_REPCAT_CACHE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">DBMS_REPCAT_CACHE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

PACKAGE BODY

<br><b><font color="#3366FF">&nbsp;</font></b>
<br><b><font color="#3366FF">&nbsp;</font></b>
<br><b><font color="#3366FF">OBJECT_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

OBJECT_TYPE

<br><b><font color="#3366FF">------------------------------ ------------------</font></b>

DBMS_REPCAT_CONF               PACKAGE BODY

<br><b><font color="#3366FF">DBMS_REPCAT_DECL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">DBMS_REPCAT_DECL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

PACKAGE BODY

<br><b><font color="#3366FF">DBMS_REPCAT_FLA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">DBMS_REPCAT_FLA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

PACKAGE BODY
 DBMS_REPCAT_FLA_MAS            PACKAGE BODY

<br><b><font color="#3366FF">DBMS_REPCAT_FLA_UTL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">DBMS_REPCAT_FLA_UTL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

PACKAGE BODY
 DBMS_REPCAT_INSTANTIATE        PACKAGE BODY
 DBMS_REPCAT_INTERNAL           PACKAGE BODY

<br><b><font color="#3366FF">DBMS_REPCAT_MAS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">&nbsp;</font></b>
<br><b><font color="#3366FF">&nbsp;</font></b>
<br><b><font color="#3366FF">OBJECT_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

OBJECT_TYPE

<br><b><font color="#3366FF">------------------------------ ------------------</font></b>

DBMS_REPCAT_MAS                PACKAGE BODY
 DBMS_REPCAT_MIG                PACKAGE BODY
 DBMS_REPCAT_MIG_INTERNAL       PACKAGE BODY
 DBMS_REPCAT_RPC                PACKAGE BODY
 DBMS_REPCAT_RPC_UTL            PACKAGE BODY

<br><b><font color="#3366FF">DBMS_REPCAT_SNA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">DBMS_REPCAT_SNA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

PACKAGE BODY

<br><b><font color="#3366FF">DBMS_REPCAT_SNA_UTL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">DBMS_REPCAT_SNA_UTL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

PACKAGE BODY

<br><b><font color="#3366FF">DBMS_REPCAT_UNTRUSTED&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">DBMS_REPCAT_UNTRUSTED&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

PACKAGE BODY

<br><b><font color="#3366FF">&nbsp;</font></b>
<br><b><font color="#3366FF">&nbsp;</font></b>
<br><b><font color="#3366FF">OBJECT_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

OBJECT_TYPE

<br><b><font color="#3366FF">------------------------------ ------------------</font></b>
<br><b><font color="#3366FF">DBMS_REPCAT_UTL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

PACKAGE
 DBMS_REPCAT_UTL                PACKAGE BODY
 DBMS_REPCAT_UTL2               PACKAGE BODY

<br><b><font color="#3366FF">DBMS_REPCAT_UTL3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">DBMS_REPCAT_UTL3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

PACKAGE BODY

<br><b><font color="#3366FF">DBMS_REPCAT_UTL4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
PACKAGE</font></b>
<br><b><font color="#3366FF">DBMS_REPCAT_UTL4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

PACKAGE BODY
 DBMS_REPCAT_VALIDATE           PACKAGE BODY
 DBMS_REPUTIL                   PACKAGE BODY

<br><b><font color="#3366FF">_ALL_REPCOLUMN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
VIEW</font></b>
<br><b><font color="#3366FF">&nbsp;</font></b>
<br><b><font color="#3366FF">76 rows selected.</font></b>
<br><b><font color="#3366FF">&nbsp;</font></b>
<br><b><font color="#3366FF"></font></b>&nbsp;<b><font color="#3366FF"></font></b>
<p><b><font color="#3366FF">Thanks in advance</font></b>
<br><b><font color="#3366FF">Suganya</font></b>
<br><b><font color="#3366FF"></font></b>&nbsp;
<br><b><font color="#3366FF"></font></b>&nbsp;<font color="#3366FF"></font>
<p>Suganya wrote:

<blockquote TYPE=CITE>Hi
     Any one Please reply me regarding the catrep.sql

</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 Received on Thu Nov 09 2000 - 06:06:00 CST