| View payload contents of a msg in a queue? [message #302430] |
Mon, 25 February 2008 11:15  |
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.
|
|
|
| Re: View payload contents of a msg in a queue? [message #302436 is a reply to message #302430 ] |
Mon, 25 February 2008 11:57  |
Michel Cadot
Messages: 17653
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
Query the queue table.
regards
Michel
|
|
|
| Re: View payload contents of a msg in a queue? [message #302440 is a reply to message #302430 ] |
Mon, 25 February 2008 12:11 |
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.
|
|
|
]
Members
Search
Help
Register
Login
Home
