nerdexam
Oracle

1Z0-062 · Question #192

What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?

The correct answer is C. It provides parallel upgrade options to finish the upgrade process with a reduced down time.. The catctl.pl script is Oracle's parallel upgrade utility that reduces database downtime by distributing the upgrade workload across multiple CPU processes.

Performing Database Maintenance

Question

What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?

Options

  • AIt generates a log file containing the fixes that can be made to the source database.
  • BIt recompiles all invalid PLSQL and Java code.
  • CIt provides parallel upgrade options to finish the upgrade process with a reduced down time.
  • DIt provides a summary of the upgrade results.
  • EIt generates fixup scripts to be run on the source database before upgrade.

How the community answered

(38 responses)
  • A
    3% (1)
  • B
    3% (1)
  • C
    89% (34)
  • E
    5% (2)

Why each option

The catctl.pl script is Oracle's parallel upgrade utility that reduces database downtime by distributing the upgrade workload across multiple CPU processes.

AIt generates a log file containing the fixes that can be made to the source database.

Generating a log of fixes for the source database is the role of the Pre-Upgrade Information Tool (preupgrade.jar), not catctl.pl.

BIt recompiles all invalid PLSQL and Java code.

Recompiling invalid PL/SQL and Java objects is performed post-upgrade by utlrp.sql, not by catctl.pl.

CIt provides parallel upgrade options to finish the upgrade process with a reduced down time.Correct

catctl.pl invokes a parallel upgrade mechanism that splits catalog upgrade processing across multiple worker processes, significantly reducing total elapsed upgrade time and minimizing the required maintenance window.

DIt provides a summary of the upgrade results.

Upgrade result summaries are produced from the upgrade log files themselves, and summarizing results is not a distinct function of catctl.pl.

EIt generates fixup scripts to be run on the source database before upgrade.

Generating fixup scripts to prepare the source database before upgrade is also the responsibility of the Pre-Upgrade Information Tool, not catctl.pl.

Concept tested: Oracle parallel upgrade utility catctl.pl functionality

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/using-autoupgrade-oracle-database-upgrades.html

Topics

#database upgrade#catctl.pl#parallel upgrade#downtime reduction

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-062 Practice