As an industry driving data set innovation, prophet has numerous in-constructed highlights which makes it simple to deal with the DBA exercises, even in the cloud. The Amazon RDS prophet DB gives admittance to many put away techniques and capacities which can be gotten to utilizing the SQL designer customer device. This method can be executed utilizing the client ID and secret key made during the Amazon RDS occurrence creation. The following are the instances of the absolute most oftentimes utilized DBA exercises.
Murdering a Session
At times a long running inquiry or some other DB movement should be killed by killing the meeting. We utilize the Amazon RDS method rdsadmin.rdsadmin_util.kill to slaughter a meeting. The accompanying code does that.
# First get the session identifier and the session serial number,
select SID, SERIAL#, STATUS from V$SESSION where USERNAME = 'AWSUSER';
# Next use the procedure
begin
rdsadmin.rdsadmin_util.kill(
sid => sid,
serial => serial_number);
end;
/
Setting the Default Tablespace
The Amazon RDS technique rdsadmin.rdsadmin_util.alter_default_tablespace can be utilized to set to the default tablespace for a DB utilizing the accompanying order.
exec rdsadmin.rdsadmin_util.alter_default_tablespace(tablespace_name => 'AWSuser');
Setting the Database Time Zone
We can utilize the Amazon RDS technique rdsadmin.rdsadmin_util.alter_db_time_zone to changes the time region for the DB.
# Change the time zone of the DB to UTC + 5.30
exec rdsadmin.rdsadmin_util.alter_db_time_zone(p_new_tz => '+5:30');
# Change the time zone to a specific region
exec rdsadmin.rdsadmin_util.alter_db_time_zone(p_new_tz => 'Asia/Kolkata');
Adding Online Redo Logs
We can utilize the Amazon RDS technique rdsadmin.rdsadmin_util.add_logfile to add extra re-try logs. The accompanying order adds a log document of size 128MB.
exec rdsadmin.rdsadmin_util.add_logfile(p_size => '128M');