Online Redefinition Tables 

Definition

This submonitor in the SAP/Oracle Database Monitor lets you check the online redefinition of tables in the database. You can see:

·        Tables in redefinition mode

·        Operations overview

Online redefinition lets you redefine tables – add, rename, or drop columns – while keeping the table fully online and available.

Use

You choose Detailed Analyses ®  Overall activity  ® Online Redefinition Tables and the required tab page.

You cannot view history information in this monitor.

Structure

Entries marked “RAC only” appear only for Oracle Real Application Cluster (RAC)

·         Tables in redefinition mode

This tab page displays the tables that are currently in online redefinition mode:

Column	Description
Table Name	Name of table
Created	Date when the table was created
DML Operation	Data Manipulation Language (DML) operation
Occurrence	Number of times for this DML operation on the table

 

·         Operations Overview

This tab page displays the time of each DML operation on the redefined tables:

Column	Description
Table Name	Name of table
Operation	DML operation
Date	Date when the table was created
Hour	Hour at which the redefinition occurred
Occurrence	Number of times for this DML operation on the table