Re: RBS in SYSTEM Ts

From: <J.Velikanovs_at_alise.lv>
Date: Fri, 6 Aug 2004 18:56:20 +0300
Message-ID: <OF2CC252B3.192365F3-ONC2256EE8.005760C8-C2256EE8.0058506C@alise.lv>

Gabriel,
You havn't mentioned version of DB (sel * from v$version;). If it is >= 9.0.0.0.0 then, there must to be UNDO, as mentioned by others ;)
It is Funy case if version is >= 9 ;)

Jurijs
+371 9268222 (+2 GMT)

Thank you for teaching me.
http://otn.oracle.com/ocm/jvelikanovs.html

"Aragon, Gabriel (GE Commercial Finance)" <gabriel.aragon_at_ge.com> Sent by: oracle-l-bounce_at_freelists.org
06.08.2004 18:30
Please respond to oracle-l

        To:     <oracle-l_at_freelists.org>
        cc: 
        Subject:        RBS in SYSTEM Ts

Hello list, I just found in the DB that the only RBS created is using = the SYSTEM ts, I want to suggest the DB owner to create another TS for = RBS operations with 3 or 4 RBS, and not use the SYSTEM ts for these = operations, the reasons I give are that the performance can be affected = because the rbs operations are accesing the same TS that the DD and also = that the rbs operations can make this ts grow to a huge size, I think = those are valid and enough reasons to do it. Am I missing something = else?=20

TIA
Gabriel

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Fri Aug 06 2004 - 11:01:03 CDT