Re: What is PIPE NAMESPACE in v$librarycache view

kachkar_at_tablimited.com.au said...
> Actually I am monitoring that view (v$librarycache ) and I noticed
> that the value for that namespace (ie pipe) changes a lot from 1 to
> 0.3 and goes up again to 1 , so I did a search on how to tune this ,
> I could not find any , but at least I know what the heck is pipe.
>
> I could not find any place that talks about tuning this pipe.
>
> thanks for your help
>
>
>
> danielroy10_at_hotmail.com (Daniel Roy) wrote in message news:<1b061893.0303171340.617bbb88_at_posting.google.com>...
> > A pipe is just a memory structure used for interprocess communication
> > (for example, DBWR needs to tell LGWR that a checkpoint occurred, and
> > that it should write the redo log changes to disk). I can't think of
> > any way to tune this specifically. I'm sure everyone reading this post
> > wonders what the heck makes you think that this is THE problem with
> > your database performance! Before looking at such specifics, make sure
> > to follow a structured approach to tuning your database (either with a
> > course or with a book).
> >
> > Daniel
> >
> > kachkar_at_tablimited.com.au (achkar) wrote in message news:<acb78eab.0303162027.1744d0e5_at_posting.google.com>...
> > > Hi all ,
> > >
> > > does anyone know the use for PIPE namespace in v$librarycache view ,
> > > what is it , what is it used for ? and how to tune it ??
> > >
> > > can anyone shed some lights on it for me please.
> > >
> > > Thanks in advance.
>

Maybe you were searching in the wrong place. I did a Google search for "librarycache namespace" (without quotes) and got a little over 500 hits, many of which attempt to explain what it is and what it means to tuning.

-- 
/Karsten
DBA > retired > DBA