> 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. ---------------------------------------------------------------- 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 -----------------------------------------------------------------