Home » RDBMS Server » Server Administration » pipe put wait event (ORACLE 10.2.0.4.0, Windows)
pipe put wait event [message #414158] Mon, 20 July 2009 10:20 Go to next message
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 #414159 is a reply to message #414158] Mon, 20 July 2009 10:23 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>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.
Re: pipe put wait event [message #414160 is a reply to message #414158] Mon, 20 July 2009 10:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Be sure there is someone reading the pipe.

Regards
Michel
Re: pipe put wait event [message #414268 is a reply to message #414159] Tue, 21 July 2009 05:23 Go to previous messageGo to next message
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 #414270 is a reply to message #414268] Tue, 21 July 2009 05:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can i read the contents of the pipe?

Yes, it is the purpose of the pipe to be written and read.

Regards
Michel

[Updated on: Tue, 21 July 2009 05:26]

Report message to a moderator

Re: pipe put wait event [message #414272 is a reply to message #414270] Tue, 21 July 2009 05:36 Go to previous messageGo to next message
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 #414277 is a reply to message #414272] Tue, 21 July 2009 06:08 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


>>Can i read the current contents of the pipe? If i have pipe put in wait event what does it indicates?

Check Here; you may get answer for your question.

http://download.oracle.com/docs/cd/B14117_01/appdev.101/b10802/d_pipe.htm
Re: pipe put wait event [message #414278 is a reply to message #414272] Tue, 21 July 2009 06:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
If i have pipe put in wait event what does it indicates?

It means your pipe is full.

Regards
Michel
Re: pipe put wait event [message #414279 is a reply to message #414278] Tue, 21 July 2009 06:23 Go to previous messageGo to next message
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.
Re: pipe put wait event [message #414290 is a reply to message #414279] Tue, 21 July 2009 06:58 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I can't see what you did and what you got.

Regards
Michel
Previous Topic: When to go for oracle 10g standard edition,,,!!!
Next Topic: ORA-09817: Write to audit file failed.
Goto Forum:
  


Current Time: Sun Dec 04 23:10:06 CST 2016

Total time taken to generate the page: 0.07758 seconds