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...
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Sat Mar 04 2006 - 08:03:57 CST
