Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

utlrp execution hangs

dba05Sep 22 2010 — edited Oct 13 2010
Hi,

I have 2 database running from same Oracle Home.

One database has some invalid objects and other has zero invalids.

But if I run utlrp on either database it will run forever,and it's not reducing no.of invalids also.

Only recent change was applying latest cpu patch-July 2010.

Any one had same issue ?

When I checked the DB session,found that it's executing below sql

select 1
from resource_view
where any_path = '/xdbconfig.xml'


Database version:10.2.0.4
OS-Solaris 5.10

Thanks in advance...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 10 2010
Added on Sep 22 2010
#general-database-discussions
16 comments
7,072 views