Check and remove Table Fragmentation in Oracle

 What is Table Fragmentation? Fragmentation is caused in table when we do update, delete operation within the table which make the space available in between the table which lead to fragmentation. When rows are inserted into the table, the high watermark(used blocks)...

RMAN Tasks in AWS RDS Oracle

Since AWS RDS is a PaaS, we donot have login to the Database host, rather we can connect to the database and there are some built-in queries which can help make our life easier to perform the Backup Operations in AWS RDS For more posts on AWS RDS please check...

Daily Tasks in AWS RDS Oracle

This blog is meant to have a deep understanding on the daily tasks you can perform in Oracle Database hosted in AWS RDS. For more posts on AWS RDS please check the INDEX page or visit our YouTube channel How does RDS work? To deliver a managed service experience,...

Steps to integrate S3 with Amazon Oracle RDS

You can transfer files between an Amazon RDS for Oracle DB instance and an Amazon S3 bucket. You can use Amazon S3 integration with Oracle features such as Data Pump. For example, you can download Data Pump files from Amazon S3 to the DB instance host. For more posts...