Re: RAC and LMT

From: Murali Vallath <murali_vallath_at_yahoo.com>
Date: Wed, 19 May 2004 15:54:16 -0700 (PDT)
Message-ID: <20040519225416.36874.qmail@web41803.mail.yahoo.com>

LMT is NOT a requirement for RAC.  

However you will notice from a performance persepective, LMT provides a great positive benefit in a RAC environment.  

todd.sheetz_at_aurora.org wrote:
We are currently on Oracle 8.1.7.3 on VMS and are starting the planning to upgrade to 9.2.0.5 later this year. Early next year we are planning on implementing RAC. I have heard/read that LMT are required for RAC. We are currently on dictionary managed per vendor mandate but will be able to use LMT by the time we go to RAC. My (long winded) question is whether the DBMS_SPACE_ADMIN.TABLEPSACE_MIGRATE_TO_LOCAL is good enough to implement LMT for RAC. I understand that we won't have all the positives of LMT, but we are currently at 1.75 terabytes and I would not be looking forward to exporting and importing it tablespace by tablespace. Any thoughts or comments are greatly appreciated!

Thanks

Todd Sheetz
Senior Database Administrator
Aurora Health Care

Who's the more foolish? The fool or the fool who follows him. -- Obi-Wan Kenobi

---

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

---

Murali Vallath

Author: Oracle Real Application Clusters Publisher Digital Press                 

---

Do you Yahoo!?
Yahoo! Domains - Claim yours for only $14.70/year

---

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

---

Received on Wed May 19 2004 - 17:51:13 CDT