RE: Redos gone crazy--a job for audit?

From: Boris Dali <boris_dali_at_yahoo.ca>
Date: Fri, 10 Oct 2003 10:39:25 -0800
Message-ID: <F001.005D2B7B.20031010103925@fatcity.com>

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

Received on Fri Oct 10 2003 - 13:39:25 CDT