Re: What is PIPE NAMESPACE in v$librarycache view

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.
Received on Mon Mar 17 2003 - 23:35:54 CST