January 2005
Beginner to intermediate
928 pages
22h 14m
English
In a multi-partition environment, a database partition is an independent subset of a database that contains its own data, indexes, configuration files, and transaction logs. A partition group is a logical grouping of one or more database partitions that lets you control the placement of table spaces and buffer pools within the database partitions.
Partition groups are classified based on the number of database partitions they contain.
Single-partition partition groups contain only one database partition.
Multi-partition partition groups contain more than one database partition.
Figure 8.8 shows four database partition groups.
pgall is a multi-partition partition group ...
Read now
Unlock full access