The following command adds a log file of size 128MB.Įxec rdsadmin.rdsadmin_util. We can use the Amazon RDS procedure rdsadmin.rdsadmin_util.add_logfile to add additional redo logs. # Change the time zone to a specific regionĮxec rdsadmin.rdsadmin_util.alter_db_time_zone(p_new_tz => 'Asia/Kolkata') # Change the time zone of the DB to UTC + 5.30Įxec rdsadmin.rdsadmin_util.alter_db_time_zone(p_new_tz => '+5:30') ![]() We can use the Amazon RDS procedure rdsadmin.rdsadmin_util.alter_db_time_zone to changes the time zone for the DB. The Amazon RDS procedure rdsadmin.rdsadmin_util.alter_default_tablespace can be used to set to the default tablespace for a DB using the following command.Įxec rdsadmin.rdsadmin_util.alter_default_tablespace(tablespace_name => 'AWSuser') Select SID, SERIAL#, STATUS from V$SESSION where USERNAME = 'AWSUSER' If your database instance is not in a VPC, you can still use these instructions because configuring a non-VPC security group is an almost identical process. # First get the session identifier and the session serial number, We use the Amazon RDS procedure rdsadmin.rdsadmin_util.kill to kill a session. Sometimes a long running query or any other DB activity needs to be killed by killing the session. Below are the examples of some of the most frequently used DBA activities. This procedure can be executed using the user ID and password created during the Amazon RDS instance creation. ![]() The Amazon RDS oracle DB provides access to many stored procedures and functions which can be accessed using the SQL developer client tool. Amazon RDS - PostgreSQL Connecting to DBĪs an industry leading database technology, oracle has many in-built features which makes it easy to manage the DBA activities, even in the cloud.
0 Comments
Leave a Reply. |