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 19:39:50 +0200
Message-ID: <4FE35C66.8030302_at_interia.pl>
W dniu 2012-06-21 14:54, Joel.Patterson_at_crowley.com 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
Date: Thu, 21 Jun 2012 19:39:50 +0200
Message-ID: <4FE35C66.8030302_at_interia.pl>
W dniu 2012-06-21 14:54, Joel.Patterson_at_crowley.com 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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 21 2012 - 12:39:50 CDT