Home » Server Options » Streams & AQ » View payload contents of a msg in a queue?
View payload contents of a msg in a queue? [message #302430] Mon, 25 February 2008 11:15 Go to next message
alp0001
Messages: 29
Registered: September 2005
Location: Illinois, USA
Junior Member
How do you view the contents of the payload of a msg in a queue (via PL/SQL) without actually dequeing it (Oracle 10)? Is there a way based on the msg_id that is available? We need to see what type of payload is causing the msg to stay on the queue for production support monitoring.

Report message to a moderator

Re: View payload contents of a msg in a queue? [message #302436 is a reply to message #302430] Mon, 25 February 2008 11:57 Go to previous messageGo to next message
Michel Cadot
Messages: 54722
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query the queue table.

regards
Michel

Report message to a moderator

Re: View payload contents of a msg in a queue? [message #302440 is a reply to message #302430] Mon, 25 February 2008 12:11 Go to previous message
alp0001
Messages: 29
Registered: September 2005
Location: Illinois, USA
Junior Member
I will ask our DBAs as payload isn't a column that is available -> only msg_id and enq_time are the only columns currently available.

Report message to a moderator

Previous Topic: Recipientlist (Connection with Java)
Next Topic: dequeue from AQ
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jun 20 07:29:49 CDT 2013

Total time taken to generate the page: 0.17564 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.