Re: (oracle q000) Streams AQ: waiting for time management or cleanup tasks fall out.

From: GG <grzegorzof_at_interia.pl>
Date: Thu, 21 Jun 2012 20:00:11 +0200
Message-ID: <4FE3612B.9080301_at_interia.pl>

W dniu 2012-06-21 19:42, Joel.Patterson_at_crowley.com pisze:
> Sorry, 10.2.0.4, solaris 9
>
>

So its simple with DTrace :
http://blog.tanelpoder.com/files/scripts/dtrace/dstackprof.sh

Tanel used that here
http://blog.tanelpoder.com/2008/09/02/oracle-hidden-costs-revealed-part2-using-dtrace-to-find-why-writes-in-system-tablespace-are-slower-than-in-others/

Regards
GG

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 21 2012 - 13:00:11 CDT

This message: [ Message body ]
Next message: Karl Arao: "Re: I/O performance"
Previous message: Niall Litchfield: "Re: I/O performance"
In reply to: Joel.Patterson_at_crowley.com: "RE: (oracle q000) Streams AQ: waiting for time management or cleanup tasks fall out."
Next in thread: Tim Gorman: "Re: (oracle q000) Streams AQ: waiting for time management or cleanup tasks fall out."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message