Strange execution plan picking random index to do bitmap conv on.

string 8.1.7 optimizer_index_caching integer 0 optimizer_index_cost_adj integer 100 optimizer_max_permutations integer 8 optimizer_mode string CHOOSE -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Turner, Adrian

RE: (un)intelligent agent

optimizer_index_cost_adj integer 100 optimizer_max_permutations integer 8 optimizer_mode string CHOOSE -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Turner, Adrian A SITI-ITPSIE INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: Strange execution plan picking random index to do bitmap conv on.

optimizer_max_permutations integer 8 optimizer_mode string CHOOSE -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Turner, Adrian A SITI-ITPSIE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: What is happening to OTN 9iRel2 page?

see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Turner, Adrian A SITI-ITPSIE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Nosort parallel dml uses TEMP tablespace

. -Original Message- From: Turner, Adrian A SITI-ITPSIE Sent: 16 September 2003 15:16 To: Multiple recipients of list ORACLE-L Subject: Nosort parallel dml uses TEMP tablespace Apologies if this has been covered before but metalink is not clear on the reasons behind it The database

RE: Nosort parallel dml uses TEMP tablespace

required does not compute either. BTW there are 27 partitions in the target table, which does not match the number parallel slaves Cheers, Adrian -Original Message- Sent: 17 September 2003 09:26 To: Turner, Adrian A SITI-ITPSIE Cc: [EMAIL PROTECTED]; Multiple recipients of list ORACLE-L

RE: Nosort parallel dml uses TEMP tablespace

From: Turner, Adrian A SITI-ITPSIE To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 17, 2003 11:39 AM Subject: RE: Nosort parallel dml uses TEMP tablespace I'm even more confused now. TEMP ran out of spa

Nosort parallel dml uses TEMP tablespace

Title: Nosort parallel dml uses TEMP tablespace Apologies if this has been covered before but metalink is not clear on the reasons behind it The database is running version 9204 EE on WinNT Sp6; and the statement is a parallel direct load into partitioned table selecting from a 12.2GB

RE: Oracle Instances not starting up via services

see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Turner, Adrian A SITI-ITPSIE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in sync with INIT.ORA ?)

://www.orafaq.net -- Author: Turner, Adrian A SITI-ITPSIE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: RE: Ab Initio, Unix Scripting, and Datawarehousing

-L FAQ: http://www.orafaq.net -- Author: Turner, Adrian A SITI-ITPSIE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: AW: Cannot delete datafile from O/S -- Help !!

-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Turner, Adrian A SITI-ITPSIE INET: [EMAIL PROTECTED] Fat City Network Services

RE: Count(*) last 30 seconds

Title: Message Ramon, Our Win2k boxes get between 1000-2000 gets a second off a SAN. Are you using compressed folders to store your datafiles? Whats Multi_block_read_countset to? Set MBRC to 32 (32x8K=256K). Make your extent sizesare divisable by 256Kto reduce gets Regards Adrian