Re: DBMS_STATS and CBO

To: Multiple recipients of list ORACLE-L Subject: Re: DBMS_STATS and CBO Btw, how much free space do you have in OS where your tempfiles are? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 6:49 PM (Resending

RE: DBMS_STATS and CBO

(Resending) Any comments on the following?? When creating index, got ORA-00603: ORACLE server session terminated by fatal error apparently caused by ksedmp: internal or fatal error ORA-01114: IO error writing block to file 121 (block # 149) ORA-27063: skgfospo: number of bytes read/written is

RE: DBMS_STATS and CBO

Sorry about the last post. Forgot to change the subject. Duh! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and

RE: DBMS_STATS and CBO

Stephen, I had something similar happen to me. In 8i, Temp files are not fully allocated when they get created. So if you create a temp file of 600M, only a small portion gets immediately allocated. The Temp file grows into the full 600M as needed. They did this to speed up the creation of

Re: DBMS_STATS and CBO

Btw, how much free space do you have in OS where your tempfiles are? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 6:49 PM (Resending) Any comments on the following?? When creating index, got ORA-00603:

RE: DBMS_STATS and CBO

have some other kind of weirdness going on here? Is this making sense? -Original Message- From: Tanel Poder [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 11:35 AM To: Multiple recipients of list ORACLE-L Subject: Re: DBMS_STATS and CBO Btw, how much free space do you

Re: DBMS_STATS and CBO

Hi, I have hit similiar situation in my datawarehouse server. As temp file are sparse, it did not allocate the actual space when it was created. But as you really begin to sort and the filesystem is full , you can get this error. I offlined that tempfile and add another tempfile in another

RE: DBMS_STATS and CBO

Tom, Your observation on which platform? On HPUX 11.0 I think it allocates full given physical size of tempfile at the time of creation and it was 8.1.6.2 when I created it 2 years back. I remember that I created 6 files of 501 MB each and it occupied disk space of 3GB+. Regards Rafiq

RE: DBMS_STATS and CBO

Rafiq, SunOS 5.8 Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, September 18, 2003 1:40 PM To: Multiple recipients of list ORACLE-L Tom, Your observation on which platform? On HPUX 11.0 I think it allocates full given physical size of tempfile at

Re: DBMS_STATS and CBO

Message- From: Tanel Poder [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 11:35 AM To: Multiple recipients of list ORACLE-L Subject: Re: DBMS_STATS and CBO Btw, how much free space do you have in OS where your tempfiles are? Tanel. - Original Message

RE: DBMS_STATS and CBO

Now, THERE is an idea! Thanky. By the way, there is now a Tanel folder in my mailbox. -Original Message- From: Tanel Poder [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Subject: Re: DBMS_STATS and CBO To avoid

RE: DBMS_STATS and CBO

Tom Thanks. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 18 Sep 2003 09:54:47 -0800 Rafiq, SunOS 5.8 Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, September 18, 2003 1:40 PM To:

RE: DBMS_STATS and CBO

recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: DBMS_STATS and CBO

RE: DBMS_STATS and CBO

Prasad, We ran into the same problem when we did FOR ALL INDEXED COLUMNS using DBMS_STATS. Then we changed it to run against FOR ALL COLUMNS SIZE 1. Then CBO started to use the indexes. execute dbms_stats.gather_table_stats('owner','table',NULL,30,TRUE, 'FOR ALL COLUMNS SIZE

RE: DBMS_STATS and CBO

To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: DBMS_STATS and CBO .com 08/09/2003 12:14 AM

RE: DBMS_STATS and CBO

: [EMAIL PROTECTED]Subject: RE: DBMS_STATS and CBO .com

Re: DBMS_STATS and CBO

@ alltel.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: DBMS_STATS and CBO .com 08/09/2003 12