Re: Oracle Partitioning
- From: Nuno Souto <dbvision@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 29 Oct 2013 20:21:40 +1100
I'll second the post below. We have used most if not all of these
techniques, in both the DW and one of the DSS dbs.
Works peachy and greatly simplifies some of the maintenance of both
stats and volatile data re-compaction.
--
Cheers
Nuno Souto
dbvision@xxxxxxxxxxxx
On 29/10/2013 3:21 AM, Karth Panchan wrote:
> Along with partition elimination on query you can add following benefits of
> partitions. Most of these I have used in Datawarehouse and OLTP environments.
>
> Partition provide ability to run Web applications without downtime for data
> load. You can partition tables and using Exchange partition data get load. No
> downtime.
>
> We can separate History and Current data into partitions to reduce work load
> OLTP.
>
> To improve performance we can collapse multiple partitions into single
> partition. Example:12 month partition can collapse into single at the end of
> the year.
>
> Archive partitions can be moved to Readonly table space if needed. This way
> statistics intact at partition level.
>
> We can have compress/uncompressed partitions in table.
>
> Please note every thing based applications I have supported. It change base
> on your application.
>
> HTH
>
> Karth
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
