Re: Tuning 9i Database - after migrating from 8i. -
- From: Mladen Gogala <mladen@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 4 Mar 2004 17:54:21 -0500
On 03/04/2004 04:20:24 PM, Tanel Põder wrote:
> > Is that good or bad? That depends on your site. Mixed mode OLTP/DSS/Batch
> > sites are a losing proposition any way you look at them. Having data guard
> > replicate your reporting tables to an operational data store and then
> > running reports from ODS is much better solution.
>
> In mixed environments I've often used a loggon trigger, which sets
> optimizer_* parameters and also sort & hash_area_sizes differently for large
> batch jobs based on username or whatever session attribute..
>
> Tanel.
>
Well, a big report running a hash join of two tables, one of which is big
will consume significant part of I/O bandwidth, significant part of CPU
capacity,
it will speed up cycling of db_block_buffers, thus increasing the number of
I/O requests by the OLTP jobs and will make just about everything else run
significantly slower. That means that the effort invested in tuning OLTP
apps must be much larger, because every little mistake in application
design will slow users to unacceptable levels and then phones start ringing....
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
