From oracle-l-bounce@freelists.org Tue Jun 21 13:00:08 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j5LI06mM020016 for ; Tue, 21 Jun 2005 13:00:06 -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 j5LI03Ni020007 for ; Tue, 21 Jun 2005 13:00:03 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0A9351C2E93; Tue, 21 Jun 2005 11:56:39 -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 08270-08; Tue, 21 Jun 2005 11:56:38 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7BE2D1C2D94; Tue, 21 Jun 2005 11:56:38 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C57681.E2D39CE8" Subject: RE: question regarding automatic undo Date: Tue, 21 Jun 2005 12:54:27 -0400 Message-ID: <4001DEAF7DF9BD498B58B45051FBEA6502988E60@25exch1.vicorpower.vicr.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: question regarding automatic undo Thread-Index: AcV2gEpDV/tZzzYaSlCsbBc/Z5b0owAAYVBg From: "Goulet, Dick" To: , , , , , X-OriginalArrivalTime: 21 Jun 2005 16:54:28.0056 (UTC) FILETIME=[E2F60580:01C57681] X-archive-position: 21424 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: DGoulet@vicr.com Precedence: normal Reply-To: DGoulet@vicr.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=-2.6 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------_=_NextPart_001_01C57681.E2D39CE8 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Yes. When you enable automatic undo management you leave all of that to the database engine. _____ =20 From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Jeffrey Beckstrom Sent: Tuesday, June 21, 2005 12:41 PM To: oracle-l@freelists.org; oracle-db-l@Groups.ITtoolbox.com; ORACLE-L@IC.SUNYSB.EDU; oracledba@LazyDBA.com; oracle-rdbms@yahoogroups.com Subject: question regarding automatic undo Two identical databases. =20 database 1 has 10 undo online and 2 offline database 2 has 10 undo online and 23 offline =20 Why does the second have more offline undo segments. Does Oracle automatically create them if needed and when no longer needed offline it?? =20 =20 =20 Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 ------_=_NextPart_001_01C57681.E2D39CE8 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Yes. = When you=20 enable automatic undo management you leave all of that to the database=20 engine.

From: oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org] On Behalf Of Jeffrey=20 Beckstrom
Sent: Tuesday, June 21, 2005 12:41 PM
To:=20 oracle-l@freelists.org; oracle-db-l@Groups.ITtoolbox.com;=20 ORACLE-L@IC.SUNYSB.EDU; oracledba@LazyDBA.com;=20 oracle-rdbms@yahoogroups.com
Subject: question regarding = automatic=20 undo

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=20 automatically create them if needed and when no longer needed offline = it??

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

------_=_NextPart_001_01C57681.E2D39CE8-- -- http://www.freelists.org/webpage/oracle-l