Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Tuning 9i Database - after migrating from 8i. -
> 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.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Mar 04 2004 - 16:47:20 CST
![]() |
![]() |