library cache lock on import

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Wed, 25 Jan 2006 15:21:15 -0400
Message-ID: <cd4305c10601251121o244e087ewe6377c23ea4b0a07@mail.gmail.com>

Hi please if you can,
I'm getting an library cache lock on an import, it seems to be related to the compilation of some procedures using database links, directed to the same database (this is because in others systems the same links points to other database, in this case not)

Thep roblem is I can-t figure out what means this exactly for example chyecking v$session row_wait_obj#, I found the table SCHEDULER$_SRCQ_INFO, that don't makes too much sense to me

or the namespace I can't find on V$DB_OBJECT_CACHE

Thanks
SELECT * FROM V$SESSION_WAIT
where not wait_class='Idle'
order by 1,2

SID                                    SEQ#                           
       EVENT                                                          
 P1TEXT                                                           P1  
                                  P1RAW      P2TEXT                   
                                       P2                             
       P2RAW      P3TEXT                                              
            P3                                     P3RAW     
WAIT_CLASS_ID                          WAIT_CLASS#                    
       WAIT_CLASS                                                     
 WAIT_TIME                              SECONDS_IN_WAIT               
        STATE


-------------------------------------- -------------------

91                                    	457                            
      	library cache lock                                             
	handle address                                                 
	858746552                             	332F6EB8  	lock address       
                                            	872673408                
            	3403F080  	100*mode+namespace                            
                 	201                                   	000000C9 
	3875070507                            	4                             
       	Concurrency                                                   
 	0                                     	1220                         
        	WAITING

--

Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

8 years of experience in Oracle 7,8i,9i,10g and developer 6i
--

http://www.freelists.org/webpage/oracle-l Received on Wed Jan 25 2006 - 13:21:15 CST