From oracle-l-bounce@freelists.org Fri Jun 3 09:22:51 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j53EMpw1010678 for ; Fri, 3 Jun 2005 09:22:51 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j53EMpNi010674 for ; Fri, 3 Jun 2005 09:22:51 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1BCA31BB04B; Fri, 3 Jun 2005 08:19:45 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 07443-06; Fri, 3 Jun 2005 08:19:45 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 94E551BACA3; Fri, 3 Jun 2005 08:19:44 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=W25h5hh1LrcSwOCgfgt3zmAXeTQMNiiTkZG1PTIZaQhdzZcjCwJJy3Ul/9xNSoQiiFCP6/FzUj/SUBvpgV+hesaCF8m9s+SC9NEisoLwYq50tJbN4FFuCjI1Y9ZBhTDuV9I7/fuI4fmNL+QvPttvccrZEihPq9wb6cc5CmaJNTQ= Message-ID: Date: Fri, 3 Jun 2005 08:17:55 -0500 From: Dennis Williams To: onkarnath.tiwary@gmail.com Subject: Re: RBS not using Cc: Lex de Haan , oracle-l@freelists.org In-Reply-To: Mime-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Content-Disposition: inline References: <20050603121055.1D4F442B5@node42.naturaljoin.lan> X-archive-position: 20638 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: oracledba.williams@gmail.com Precedence: normal Reply-To: oracledba.williams@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.63 Onkar - You are correct, that the data blocks your transaction is modifying are all using RBS01. You have thusly commanded Oracle. But that just has to do with modifying blocks. As Jeremiah points out, the ORA-01555 is caused by READING from the database. When other transactions have modified blocks that you need to read, those transactions may have used other rollback segments. Read the article, it is less than a page long. Dennis Williams On 6/3/05, Onkar N Tiwary wrote: > Lex/Dennis, > Thanx for the suggestion but my main query is why my transaction is not > using RBS01 when I have set the same for the current transaction?? No dou= bt > u guys are absolutely right but when I am setting the transaction to use > RBS01 then it should use that only and not the other rollback segment(if = I > am not wrong). -- http://www.freelists.org/webpage/oracle-l