| pipe put wait event [message #414158] |
Mon, 20 July 2009 10:20  |
srini_thiru
Messages: 133
Registered: May 2008
|
Senior Member |
|
|
Hi,
In one of the procedure we have used DBMS_PIPE to pack and unpack messages.
While i run the procedure, the session hangs for a long time and in the wait events i have found pipe put.
I have reset the buffer and even the purged the pipe. I have also restarted the database. but the problem remains.
Can any one help me in this?
|
|
|
|
|
|
|
|
| Re: pipe put wait event [message #414268 is a reply to message #414159] |
Tue, 21 July 2009 05:23  |
srini_thiru
Messages: 133
Registered: May 2008
|
Senior Member |
|
|
| BlackSwan wrote on Mon, 20 July 2009 10:23 | >Can any one help me in this?
What is supposed to be removing/reading data from the pipe?
Is it still successfully operating?
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
|
Hi,
How can i check whether pipe is successfully operating or not? Can i read the contents of the pipe?
Thanks in Advance,
Seenu.
|
|
|
|
|
|
| Re: pipe put wait event [message #414272 is a reply to message #414270] |
Tue, 21 July 2009 05:36 |
srini_thiru
Messages: 133
Registered: May 2008
|
Senior Member |
|
|
| Michel Cadot wrote on Tue, 21 July 2009 05:25 | | Quote: | Can i read the contents of the pipe?
|
Yes, it is the purpose of the pipe to be written and read.
Regards
Michel
|
Can i read the current contents of the pipe? If i have pipe put in wait event what does it indicates?
Thanks in Advance,
Seenu.
|
|
|
|
|
|
|
|
| Re: pipe put wait event [message #414279 is a reply to message #414278] |
Tue, 21 July 2009 06:23 |
srini_thiru
Messages: 133
Registered: May 2008
|
Senior Member |
|
|
| Michel Cadot wrote on Tue, 21 July 2009 06:09 | | Quote: | If i have pipe put in wait event what does it indicates?
|
It means your pipe is full.
Regards
Michel
|
I have purged that particular pipe and even gave reset buffer by using the following command.
Pipe Purging:
exec dbms_pipe.purge('PIPE_NAME');
Reset Buffer:
Exec dbms_pipe.reset_buffer;
commit;
But then too i receive the same Pipe Put in Wait Event.
Thanks in Advance,
Seenu.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
