MaintainMRC issues

From: kommareddy sreenivasa <kommacnu_at_yahoo.com>
Date: Wed, 20 Aug 2003 10:54:24 -0800
Message-ID: <F001.005CBCAE.20030820105424@fatcity.com>

Hi All,

OS: Solaris 2.8
DB: 9i

Apps: 11.5.5

Can somebody help me to resolve the issue:

we are running Maitain MRC sync the APPS and APPS_MRC schemas. (giving grants from APPS to APPS_MRC)

The issue is :
It is running for long time (4-5 hrs) for a particular instance. It's a 600 Gig development database. But the same process on the same box is finished within 2.5 - 3 hrs for another equally sized instance (dbsize as well instance size)

We have locked the accounts which are causing locking issues on objects/packages. So there is no object locking issue.

Can somebody elaborate me how to check what the whole process (MRC ) will do step by step. Any docs or Metalink Hits ...

Thanks and Regards,

Srinivas

---

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: kommareddy sreenivasa
  INET: kommacnu_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Wed Aug 20 2003 - 13:54:24 CDT