Flush shared pool, buffer cache, and smart flash cache in AWS Oracle RDS

How to flush the shared pool and buffer cache in AWS Oracle RDS

Flush the shared pool in AWS Oracle RDS

EXEC rdsadmin.rdsadmin_util.flush_shared_pool;

Flush or Empty the buffer cache of AWS Oracle RDS database

EXEC rdsadmin.rdsadmin_util.flush_buffer_cache;

Flush the database smart flash cache

EXEC rdsadmin.rdsadmin_util.flush_flash_cache;

Leave a Reply