Re: What is PIPE NAMESPACE in v$librarycache view

From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 17 Mar 2003 13:40:01 -0800
Message-ID: <1b061893.0303171340.617bbb88@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 - 15:40:01 CST