AWS RDS: 5 Must-Know Actions for Oracle DBAs

begin
 rdsadmin.rdsadmin_util.kill(
 sid => &sid,
 serial => &serial,
 method => 'IMMEDIATE');
 end;
 /

exec rdsadmin.rdsadmin_util.flush_shared_pool;
 exec rdsadmin.rdsadmin_util.flush_buffer_cache;
 

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;
 /

begin
  rdsadmin.rdsadmin_util.grant_sys_object(
  p_obj_name => 'V_$SESSION',
  p_grantee => 'PYTHIAN',
  p_privilege => 'SELECT');
 end;
 /

begin
  rdsadmin.rdsadmin_util.grant_sys_object(
  p_obj_name => 'V_$SESSION',
  p_grantee => 'PYTHIAN',
  p_privilege => 'SELECT',
  p_grant_option => true);
 end;
 /

begin
  rdsadmin.rdsadmin_util.revoke_sys_object(
  p_obj_name => 'V_$SESSION',
  p_revokee => 'PYTHIAN',
  p_privilege => 'SELECT');
 end;
 /

begin
  rdsadmin.rdsadmin_password_verify.create_verify_function(
  p_verify_function_name => 'CUSTOM_PASSWORD_FUNCTION', 
  p_min_length => 12, 
  p_min_uppercase => 2, 
  p_min_digits => 1, 
  p_min_special => 1,
  p_disallow_at_sign => true);
 end;
 /

col text format a150
 select TEXT from DBA_SOURCE 
 where OWNER = 'SYS' and NAME = 'CUSTOM_PASSWORD_FUNCTION' order by LINE;