From oracle-l-bounce@freelists.org Tue Jun 21 12:46:24 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j5LHkNJ5018388 for ; Tue, 21 Jun 2005 12:46:23 -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 j5LHkNNi018384 for ; Tue, 21 Jun 2005 12:46:23 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E09DA1C2CC2; Tue, 21 Jun 2005 11:42:58 -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 04836-05; Tue, 21 Jun 2005 11:42:58 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 667A61C2CBF; Tue, 21 Jun 2005 11:42:58 -0500 (EST) Message-Id: Date: Tue, 21 Jun 2005 12:40:42 -0400 From: "Jeffrey Beckstrom" To: , , , , Subject: question regarding automatic undo Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=_E4C71335.4E2F3355" X-archive-position: 21420 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: JBECKSTROM@gcrta.org Precedence: normal Reply-To: JBECKSTROM@gcrta.org 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.7 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE, SUSPICIOUS_RECIPS autolearn=no version=2.63 --=_E4C71335.4E2F3355 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Two identical databases. database 1 has 10 undo online and 2 offline database 2 has 10 undo online and 23 offline Why does the second have more offline undo segments. Does Oracle automatically create them if needed and when no longer needed offline it?? Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 --=_E4C71335.4E2F3355 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Content-Description: HTML

Two identical databases.

database 1 has 10 undo online and 2 offline

database 2 has 10 undo online and 23 offline

Why does the second have more offline undo segments. Does Oracle automatically create them if needed and when no longer needed offline it??

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113

--=_E4C71335.4E2F3355-- -- http://www.freelists.org/webpage/oracle-l