Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Bug Reports...

RE: Oracle Bug Reports...

From: <Jared.Still_at_radisys.com>
Date: Thu, 06 Mar 2003 11:59:28 -0800
Message-ID: <F001.0056255E.20030306115928@fatcity.com>


IIRC, the ORA-1555 was in another session.

Jared

"Henry Poras" <hporas_at_etal.uri.edu>
Sent by: root_at_fatcity.com
 03/06/2003 08:53 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: Oracle Bug Reports...


Interesting bug. I'm spacing on one thing though. Don't see where the ORA-1555 is coming from on their test case.

Henry

***EXCERPT FROM BUG REPORT
***
***

REM Create the user and the tables in question REM
create user medic identified by medic;
alter user medic default tablespace users temporary tablespace temp; grant dba to medic;
connect medic/medic;
create table myobjs1 as select * from dba_objects;
create table myobjs2 as select * from dba_objects;
create table myobjs3 as select * from dba_objects;

declare
 a number;
 begin
  for a in 1..3 loop
  insert into myobjs1 select * from myobjs1;   commit;
 end loop;
end;
/
REM
REM Create small rollback segment to use for these trxs, and offline all REM other non-system rollback segments
REM
create rollback segment small_rbs_to_use tablespace rbs storage (initial 50k
next 50k optimal 200k maxextents unlimited); alter rollback segment small_rbs_to_use online; alter rollback segment <all other non-system rbs here> offline; REM
REM Start session 1
REM
connect medic/medic
set time on
update myobjs1 set owner='change1';
commit;
REM
REM Start session 2
REM
connect medic/medic
set time on
update myobjs1 set owner='change2';
REM
REM Start session 3
REM
connect medic/medic
set time on
update myobjs1 set owner='change3';
REM
REM Start the Export
REM
exp medic/medic direct=y tables=\(myobjs1,myobjs2,myobjs3\) log=imp1.log REM You got to be exporting myobjs1 when session 2 and session 3 error out with ORA-1555 (snapshot too old: rollback segment number ...with name "SMALL_RBS_TO_USE" too small). To accomplish this, startup and execute the SQL statement in the three sessions, and see how long it takes, for session
2 to fail with the ORA-1555 after it was submitted for execution. In my test case, it took a minute and 20 seconds before it failed. Therefore I launch the export session a minute and an 10 seconds after executing the SQL in session 2.

-----Original Message-----
Jared.Still_at_radisys.com
Sent: Wednesday, March 05, 2003 1:29 PM
To: Multiple recipients of list ORACLE-L

.. can be rather interesting at times, when there's time to check out a few.

http://metalink.oracle.com/metalink/plsql/showDoc?db=BUG&id=2666174

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
  INET: Jared.Still_at_radisys.com

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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: hporas_at_etal.uri.edu 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Jared.Still_at_radisys.com 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 Thu Mar 06 2003 - 13:59:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US