Re: Tuning: which applications are writing too much

From: Gerard H. Pille <ghp_at_skynet.be>
Date: Sat, 04 Mar 2006 16:45:44 +0100
Message-ID: <4409b616$0$24766$ba620e4c@news.skynet.be>

Frank van Bortel wrote:

> Gerard H. Pille wrote:
> 

>>Hallo,
>>
>>our applications - or some of them - are generating more data than our
>>hardware can stomach. The question is of course which ones. Should be
>>easy to answer if I can determine which tables are written to most.
>>
>>Don't tell me to RTFM, I know all about the F, and I'm starting with the
>>Oracle manuals the minute I've posted this.
>>
>>Any hints are well come, even the obvious ones, I can always have
>>overlooked something stupid, haven't been doing any general tuning for
>>quite a while now.
>>
>>Thanks,
>>
>>Gerard
>>
>>PS: Most of the databases are 9.2.0.7, all are version 9.

> 
> 
> Generate data where? Redo logs?
> How about logminer to see what.
> Streams active? Check if there isn't a network alias which could be
> validated the moment the database was opened. Generates about
> 100MB/minute of redo log, due to an aq job that goes bezerk...
> 

Hallo Frank,

can I get some more on that AQ job? I know we've started using Advanced (?) Queueing recently.

Thanks,

Gerard Received on Sat Mar 04 2006 - 09:45:44 CST