Re: catalog.sql catproc.sql

From: <Riyaj_Shamsudeen_at_i2.com>
Date: Tue, 22 May 2001 10:23:44 -0700
Message-ID: <F001.0030B048.20010522094619@fatcity.com>

I think, you may be better off doing this during the maintenance window. When you execute catolog.sql it invalidates the standard package which in turn invalidates many, many other packages. You may run in to major performance problems if you do this, while users are using the database..

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com

Ray Stell <stellr_at_stell.cns.vt.edu>
Sent by: root_at_fatcity.com
05/22/01 09:22 AM
Please respond to ORACLE-L

       
        To:        Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc:        
        Subject:        catalog.sql catproc.sql

While it doesn't seem like a real great idea, can I get away with running catalog.sql and catproc.sql while db has users and jobs running?  I have a real hard time getting a maintenance window, Some docs I've seen explicitly say to do a startup rather than startup restrict.

---

Ray Stell   stellr_at_vt.edu     (540) 231-4109     KE4TJC    28^D

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: stellr_at_stell.cns.vt.edu

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

Received on Tue May 22 2001 - 12:23:44 CDT