How to use alter system sql statement in AWS RDS oracle

0 votes
"ALTER SYSTEM FLUSH BUFFER_CACHE;" 

Oracle's data buffer cache was deleted using the database command.

But then the mistake happened. ORA-01031 is the SQL Error [1031] [42000].


So I issued a different command:

"The following issue occurred while executing rdsadmin.rdsadmin util.flush buffer cache. Error code [900] [42000] in SQL: ORA-00900

Execute "exec admin.admin util.flush buffer cache;" according to the documentation. Can you explain why I can't use this command despite the fact that it indicates I can?

Does flust buffer cache have any other methods?

Dec 14, 2022 in AWS by Tejashwini
• 5,380 points
• 1,448 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In AWS

+2 votes
1 answer

How to Use Amazon AWS Credentials to Access/Query Tables in AWS RDS Instance through Mobile App

You should make your backend functions to ...READ MORE

answered Aug 28, 2018 in AWS by Priyaj
• 58,020 points
• 3,127 views
0 votes
1 answer

How to monitor Oracle RDS instance in AWS?

You could probably use Cloudwatch itself for ...READ MORE

answered Nov 2, 2020 in AWS by Nilesh
• 1,989 views
0 votes
1 answer

ELOGIN error while connecting to SQL Server RDS in AWS Elastic Beanstalk

Using SQL Server Management Studio (SSMS) with ...READ MORE

answered Feb 8, 2022 in AWS by anonymous
• 1,383 views
0 votes
0 answers

Convert oracle UDF function with to_number and value_error expection in it to AWS RDS maria db

create or replace FUNCTION num_check (p_string IN ...READ MORE

Dec 14, 2022 in AWS by Tejashwini
• 5,380 points
• 1,337 views
0 votes
0 answers
+1 vote
2 answers
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP