partitioning option with parallel server

From: Sathish Tatikonda <sathisht_at_infy.com>
Date: Tue, 12 Feb 2002 00:07:45 -0800
Message-ID: <F001.0040C48F.20020212000318@fatcity.com>

hi all,

I have read this document on partitioning which says that partitioning cannot be implemented in clusters.

---

---

I.2 Version 8:

---

Partitioning is offered as an option in Oracle V8 Enterprise Server Edition. It is an option that requires specific selection during installation of the RDBMS that enables it to be linked into the kernel. This new option is useful in addressing performance problems and database
administration issues in Very Large Database (VLDB) environments. Administrators of databases with historical data are particularly interested in this option. Administrators of OLTP databases concerned the performance and/or availability also benefit with the implementation of this option.

Advantages:

• Improved database administration as several maintenance operations can now be done at a partition level rather than at a table or index level. Moreover, the independence between partitions allows the maintenance on those very partitions to take place simultaneously.
• Database unavailability reduced. Finer grained recovery as it can be done at the partition level.
• Better distribution of data as it is possible to spread it out on several partitions and different disks.
• Performance enhancement in the dispatching of queries, particularly for data warehousing or decision making. The optimizer is capable of selecting a limited quantity of rows associated with one or several partitions specified in the query.

This functionality is available for both indexes and tables, but cannot be implemented in clusters.

---

---

does this mean that we cannot implement partitioning with Parallel server. It would be of great help in case you can clarify this point.

thanks,
Sathish.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sathish Tatikonda
  INET: sathisht_at_infy.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Feb 12 2002 - 02:07:45 CST