Return-Path: <ml-errors@fatcity.com>
Received: from ensim.rackshack.net (root@localhost)
 by orafaq.net (8.11.6/8.11.6) with ESMTP id h9AKOdn28780
 for <oracle-l@orafaq.net>; Fri, 10 Oct 2003 15:24:39 -0500
X-ClientAddr: 66.27.56.213
Received: from www2.fatcity.com (rrcs-west-66-27-56-213.biz.rr.com [66.27.56.213])
 by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h9AKOdc28775
 for <oracle-l@orafaq.net>; Fri, 10 Oct 2003 15:24:39 -0500
Received: (from root@localhost)
 by www2.fatcity.com (8.11.6/8.11.6) id h9AHewj00542
 for oracle-l@orafaq.net; Fri, 10 Oct 2003 10:40:58 -0700
Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D2B7B; Fri, 10 Oct 2003 10:39:25 -0800
Message-ID: <F001.005D2B7B.20031010103925@fatcity.com>
Date: Fri, 10 Oct 2003 10:39:25 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
X-Comment: Oracle RDBMS Community Forum
X-Sender: Boris Dali <boris_dali@yahoo.ca>
Sender: ml-errors@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: Boris Dali <boris_dali@yahoo.ca>
Subject: RE: Redos gone crazy--a job for audit?
Organization: Fat City Network Services, San Diego, California
X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Igor,

Try running the following test:

create table t6 (i int) ;

create global temporary table t7 (i int) on commit
delete rows;

select value from v$mystat m, v$statname s 
where m.statistic#=s.statistic# and s.name = 'redo
size';

--> Note the value here

insert into t6 select obj# from sys.obj$ where rownum
<= 10000;

commit;

select value from v$mystat m, v$statname s 
where m.statistic#=s.statistic# and s.name = 'redo
size';

--> Compare the two. In my case it's almost 10-fold
increase in the amount of redo generated.

We ran into this not too long ago. Bug# 2874489. Fixed
in 10.1.0.1 with some backports available for
9.2.0.3/4 on **some** platforms

Note: Bug above doesn't affect direct path load

Thanks,
Boris.

 --- Igor Neyman <ineyman@perceptron.com> wrote: >
Why?
> Did you have bad experiences with temp tables?
> I thought, using temp tables should reduce amount of
> redo.
> 
> Igor Neyman, OCP DBA
> ineyman@perceptron.com
> 
> 
> 
> -----Original Message-----
> Boris Dali
> Sent: Friday, October 10, 2003 12:54 PM
> To: Multiple recipients of list ORACLE-L
> 
> Barbara,
> 
> Shoot in the dark. Any chance last vendor upgrade
> introduced global temporary tables?
> 

______________________________________________________________________ 
Post your free ad now! http://personals.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boris Dali
  INET: boris_dali@yahoo.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-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).