Re: Parallel hint

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 16 Feb 2009 07:39:20 -0000
Message-ID: <1pidndY4Jci4hQTUnZ2dnUVZ8jydnZ2d_at_bt.com>


"Dion Cho" <ukja.dion_at_gmail.com> wrote in message news:28a09d79-963e-4c3c-bacb-d6c31ce0ae65_at_o40g2000prn.googlegroups.com... On 2¿ù16ÀÏ, ¿ÀÈÄ1½Ã43ºÐ, raja <dextersu..._at_gmail.com> wrote:

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

<<parallel_dml_here>>
commit;
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: http://www.jlcomp.demon.co.uk/pqcosts.html

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

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Received on Mon Feb 16 2009 - 01:39:20 CST

Original text of this message