- Más nuevo
- Más votos
- Más comentarios
To clear the buffer cache in AWS RDS Oracle, you can try running the following command as the RDS superuser:
EXEC rdsadmin.rdsadmin_util.flush_buffer_cache;
Note that this command requires superuser privileges, so you may need to grant yourself the necessary permissions before running it. Additionally, you may need to run the command in a specific schema, such as rdsadmin, to avoid the ORA-00900 error.
If you are unable to run the command or are still encountering errors, you can try using the ALTER SYSTEM command instead:
ALTER SYSTEM FLUSH BUFFER_CACHE;
This command may require the ALTER SYSTEM privilege, which you can grant to yourself using the GRANT statement. For example:
GRANT ALTER SYSTEM TO myuser;
Keep in mind that clearing the buffer cache can have a negative impact on database performance, so it should only be done as a last resort and under the guidance of a qualified DBA.
Contenido relevante
- OFICIAL DE AWSActualizada hace 3 años
not all three Any other way?