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 19:39:50 +0200
W dniu 2012-06-21 14:54, Joel.Patterson@xxxxxxxxxxx pisze:
> When first starting a database I get very high USER IO: I used db optimizer
> to see what stands out. user 'Unknown', is shown to be consuming IO - it is
> connected to Non-SQL Activity with an SQL_ID of 0, and a SQL_ID which is
> connected to the Advanced queuing wait event in the subject line.
> I am unsure how this wait event or session is connected to the IO. Has
> anyone come across this before? Don't use AQ purposely in this DB or others.
Could You please share OS and DB version ?
You can try call stack profiling but details depends on OS :) .
Regards
GregG
--
//www.freelists.org/webpage/oracle-l
Other related posts:
