Tuning options for rdsadmin.rdsadmin_rman_util.validate_database package

 

Option	Timing
Use default section size (10M) provided by Example	00:02:42.911
Without Specifying section size	00:00:18.530
Validation Type limits to "PHYSICAL" only	00:00:18.257
Validation per tablespace (manually parallel through different sessions)	00:00:10.863

Lacking of Parallelism in Standard Edition

BEGIN
    rdsadmin.rdsadmin_rman_util.validate_database(
        p_validation_type     => 'PHYSICAL+LOGICAL', 
        p_parallel            => 4,  
        p_section_size_mb     => 10,
        p_rman_to_dbms_output => FALSE);
END;
/

SQL> set timing on
SQL> BEGIN
  2      rdsadmin.rdsadmin_rman_util.validate_database(
  3          p_validation_type     => 'PHYSICAL+LOGICAL',
  4          p_parallel            => 4,
  5          p_section_size_mb     => 10,
  6          p_rman_to_dbms_output => FALSE);
  7  END;
  8* /

Error starting at line : 1 in command -
BEGIN
    rdsadmin.rdsadmin_rman_util.validate_database(
        p_validation_type     => 'PHYSICAL+LOGICAL',
        p_parallel            => 4,
        p_section_size_mb     => 10,
        p_rman_to_dbms_output => FALSE);
END;
Error report -
ORA-20722: Parallelism require Enterprise Edition.
ORA-06512: at "SYS.RDS_SYS_RMAN_UTIL", line 283
ORA-06512: at "SYS.RDS_SYS_RMAN_UTIL", line 819
ORA-06512: at "SYS.RDS_SYS_RMAN_UTIL", line 851
ORA-06512: at "RDSADMIN.RDSADMIN_RMAN_UTIL", line 29
ORA-06512: at line 2

Elapsed: 00:00:01.070

Use default section size (10M) provided by Example

BEGIN
    rdsadmin.rdsadmin_rman_util.validate_database(
        p_validation_type     => 'PHYSICAL+LOGICAL',
        p_parallel            => 1,  
        p_section_size_mb     => 10,
        p_rman_to_dbms_output => FALSE);
END;
/

SQL> BEGIN
  2      rdsadmin.rdsadmin_rman_util.validate_database(
  3          p_validation_type     => 'PHYSICAL+LOGICAL',
  4          p_parallel            => 1,
  5          p_section_size_mb     => 10,
  6          p_rman_to_dbms_output => FALSE);
  7  END;
  8* /

PL/SQL procedure successfully completed.

Elapsed: 00:02:42.911

Without Specifying section size

BEGIN
    rdsadmin.rdsadmin_rman_util.validate_database(
        p_validation_type     => 'PHYSICAL+LOGICAL',
        p_parallel            => 1,  
        p_section_size_mb     => NULL,
        p_rman_to_dbms_output => FALSE);
END;
/

SQL> BEGIN
  2      rdsadmin.rdsadmin_rman_util.validate_database(
  3          p_validation_type     => 'PHYSICAL+LOGICAL',
  4          p_parallel            => 1,
  5          p_section_size_mb     => NULL,
  6          p_rman_to_dbms_output => FALSE);
  7  END;
  8* /

PL/SQL procedure successfully completed.

Elapsed: 00:00:18.530

Validation Type limits to "PHYSICAL" only

BEGIN
    rdsadmin.rdsadmin_rman_util.validate_database(
        p_validation_type     => 'PHYSICAL',
        p_parallel            => 1,  
        p_section_size_mb     => NULL,
        p_rman_to_dbms_output => FALSE);
END;
/

SQL> BEGIN
  2      rdsadmin.rdsadmin_rman_util.validate_database(
  3          p_validation_type     => 'PHYSICAL',
  4          p_parallel            => 1,
  5          p_section_size_mb     => NULL,
  6          p_rman_to_dbms_output => FALSE);
  7  END;
  8* /

PL/SQL procedure successfully completed.

Elapsed: 00:00:18.257

Validation per tablespace (manually parallel through different sessions)

BEGIN
    rdsadmin.rdsadmin_rman_util.validate_tablespace(
        p_validation_type     => 'PHYSICAL+LOGICAL',
		p_tablespace_name     => 'SYSTEM',
        p_parallel            => 1,  
        p_section_size_mb     => NULL,
        p_rman_to_dbms_output => FALSE);
END;
/

BEGIN
    rdsadmin.rdsadmin_rman_util.validate_tablespace(
        p_validation_type     => 'PHYSICAL+LOGICAL',
		p_tablespace_name     => 'SYSAUX',
        p_parallel            => 1,  
        p_section_size_mb     => 10,
        p_rman_to_dbms_output => NULL);
END;
/

-- SESSION 1
SQL> BEGIN
  2      rdsadmin.rdsadmin_rman_util.validate_tablespace(
  3          p_validation_type     => 'PHYSICAL+LOGICAL',
  4  p_tablespace_name     => 'SYSTEM',
  5          p_parallel            => 1,
  6          p_section_size_mb     => NULL,
  7          p_rman_to_dbms_output => FALSE);
  8  END;
  9* /

PL/SQL procedure successfully completed.

Elapsed: 00:00:10.863
SQL>

-- SESSION 2
SQL> BEGIN
  2      rdsadmin.rdsadmin_rman_util.validate_tablespace(
  3          p_validation_type     => 'PHYSICAL+LOGICAL',
  4  p_tablespace_name     => 'SYSAUX',
  5          p_parallel            => 1,
  6          p_section_size_mb     => NULL,
  7          p_rman_to_dbms_output => FALSE);
  8  END;
  9* /

PL/SQL procedure successfully completed.

Elapsed: 00:00:05.224