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

  • From: GG <grzegorzof@xxxxxxxxxx>
  • To: Joel.Patterson@xxxxxxxxxxx
  • Date: Thu, 21 Jun 2012 20:00:11 +0200

W dniu 2012-06-21 19:42, Joel.Patterson@xxxxxxxxxxx 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

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


Other related posts: