Veritas Storage Foundation 5.1 SP1: Storage and Availability Management for Oracle (5900-1504, April 2011)

Moving files ........................................................................ 237
Moving sub-file objects .......................................................... 237
How SmartTier for Oracle works ................................................... 238
How partitions change the way Oracle stores database
objects .......................................................................... 238
Database extents to file location .............................................. 241
Statistics in Oracle ................................................................ 241
Optimizing storage for Oracle database objects .......................... 242
About Automatic Workload Repository statistics ........................ 243
SmartTier in a High Availability (HA) environment .......................... 244
Chapter 14 Configuring and administering SmartTier ................... 245
Configuring SmartTier for Oracle .................................................. 245
SmartTier for Oracle command requirements ............................ 246
Defining database parameters ................................................ 246
Setting up storage classes ...................................................... 249
Converting a Veritas File System (VxFS) to a VxFS multi-volume
file system .................................................................... 251
Classifying volumes into a storage class .................................... 252
Displaying free space on your storage class ............................... 252
Adding new volumes to a storage class ..................................... 254
Removing volumes from a storage class .................................... 254
SmartTier policy management ...................................................... 255
Relocating files .................................................................... 255
Relocating tablespaces .......................................................... 256
Relocating table partitions ..................................................... 257
Using preset policies ............................................................. 257
Running SmartTier for Oracle reports ............................................ 259
Viewing modified allocation policies ........................................ 259
Viewing audit reports ............................................................ 260
Extent balancing in a database environment .................................... 260
Extent balancing file system ................................................... 261
Creating an extent balanced file system .................................... 262
Viewing SmartTier sub-file level reports ......................................... 264
Administering SmartTier at the sub-file level .................................. 266
Chapter 15 SmartTier for Oracle use cases ....................................... 269
SmartTier for Oracle file-based use cases ........................................ 269
Migrating partitioned data and tablespaces ............................... 269
Scheduling the relocation of archive and Flashback logs .............. 271
SmartTier for Oracle sub-file use cases ........................................... 274
13Contents