ignore, I figured it out.
>
> From: "Unai Basterretxea" <[Email Address Removed] Date: 2003/06/30 Mon AM 10:51:52 EDT
> To: "LazyDBA.com Discussion" <[Email Address Removed] Subject: RE: strange locking issue
>
> which is the data dictionary query?
>
> -----Mensaje original-----
> De: [Email Address Removed] [mailto:[Email Address Removed] Enviado el: astelehena, 2003.eko ekainak 30 16:29
> Para: LazyDBA.com Discussion
> Asunto: Re: strange locking issue
>
>
> i drilled down deeper. It turns out the locks being held by DBWR are for
> media recovery. any idea where to check next?
>
> Im not sure why DBWR would be performing a media recovery. I also checked my
> script and I cannot access DBA_FREE_SPACE view. I do any kind of query on it
> and it is blocked.
> >
> > From: <[Email Address Removed] > Date: 2003/06/30 Mon AM 10:19:28 EDT
> > To: "LazyDBA.com Discussion" <[Email Address Removed] > Subject: strange locking issue
> >
> > Im attempting to run some queries on the data dictionary and they should
> run in about 5 seconds. They are hanging.
> >
> > So I checked v$lock. DBWR has 12 locks and LGWR has 1 lock. I checked
> v$locked_object, no objects are locked. No other processes are running.
> >
> > Where do I go now to investigate this further?
> >
> >
> > --------
> > Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > To unsubscribe: send a blank email to oracledba-[Email Address Removed] > To subscribe: send a blank email to oracledba-[Email Address Removed] > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> > Tell yer mates about http://www.farAwayJobs.com
> > By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
> >
> >
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
> --------
> Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>

Oracle LazyDBA home page