DBAToolZ - Scripts ( Partitioning ) DBAToolZ Home
 (Last updated 05/21/2003)
Home     Download     Forums     SQL Scripts     Book Review     Links     Feedback


Script Name Description

s_tab_figure_subparts.sql

	I use this script on tables that are not yet
	partitioned but need to be partitioned.
	It allows me to figure out number of subpartitions.
	--------
	STRATEGY:
 	+------------------------------------------+
 	Goal:
 	        20 EXTENTS per SUBPARTITION
 	Rule:
 	        2sp     for 0-40        EXTENT TABLE
 	        8sp     for 41-160      EXTENT TABLE
 	        16sp    for 161+        EXTENT TABLE
 	+------------------------------------------+

s_tab_part.sql

	Reports partitioned tables from dba_part_tables

s_tab_subpart.sql

	Reports table subpartition details

DBAToolZ Home | Contact Us
Copyright© 2001 DBAToolZ.com All Rights Reserved.