You can expand supplemental logging at the table level to track primary key, foreign key,
unique index, and all changes. You can also use the no log option to prevent a column in a
user-defined log group from being logged.
See the Oracle Utilities guide for further details on the use of LogMiner and its procedures.
LogMiner Features Introduced in Oracle Database 11g
Until Oracle Database 11g, a DBA had to use the Java-based LogMiner console, which was
difficult to install and not completely integrated with Oracle Enterprise Manager Database
Control. The integration with OEM DB Control further enhances ease of use by integrating
a task-based log mining operation with Flashback Transaction. Figure 14-1 shows the OEM
interface for LogMiner.
FIGURE 14-1 OEM LogMiner and Flashback Transaction interface
506 Oracle Database 11g DBA Handbook
Online Object Reorganization
You can reorganize many database objects online. Options include the following:
Creating indexes online
Rebuilding indexes online
Coalescing indexes online
Rebuilding index-organized tables online
Using the DBMS_REDEFINITION package to redefine a table online
In the following sections, you will see examples of each of these operations.
Creating Indexes Online
You can create and rebuild indexes while the base tables are accessible to end users. DDL operations
are not allowed while the index is being built. To build an index online, use the online clause of
the create index command, as shown in the following example:
create index AUTH$NAME on AUTHOR (AuthorName) online;
Rebuilding Indexes Online
When you use the rebuild clause of the alter index command, Oracle uses the existing index as
the data source for the new index.
Pages:
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765