Re: Parallel hint

From: Jonathan Lewis <>
Date: Mon, 16 Feb 2009 07:39:20 -0000
Message-ID: <>

"Dion Cho" <> wrote in message On 2월16일, 오후1시43분, raja <> wrote:

It's not v$pq_stat, but v$pq_tqstat, like

select dfo_number, tq_id, server_type, process,   num_rows, bytes, avg_latency, waits, timeouts from v$pq_tqstat
order by 1, 2, 3, 4, 5

Thanks for highlighting the error.
There's an example of usage and a couple of comments at:

It's 10 years old, but most of it is still relevant.


Jonathan Lewis

Author: Cost Based Oracle: Fundamentals

The Co-operative Oracle Users' FAQ
Received on Mon Feb 16 2009 - 01:39:20 CST

Original text of this message