Re: Parallel hint
Date: Mon, 16 Feb 2009 07:39:20 -0000
"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
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.htmlReceived on Mon Feb 16 2009 - 01:39:20 CST