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
• 3,820 points
241 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
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
515 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
329 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
• 3,820 points
213 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