How to use alter system sql statement in AWS RDS oracle

0 votes

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

"ALTER SYSTEM FLUSH BUFFER_CACHE;" 

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

So I used a different command:

"EXEC rdsadmin.rdsadmin_util.flush_buffer_cache; 

Now this happened: SQL Error [900] [42000]: ORA-00900

The docs say that this command "exec admin.admin_util.flush_buffer_cache;" can be used but it can't. Why? Also, how to do flust_buffer_cache?

Dec 14, 2022 in AWS by Roshan
• 300 points
753 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
1,259 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
765 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
488 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
418 views
0 votes
0 answers

How to use "alter system.." sql statement in AWS RDS oracle?

"ALTER SYSTEM FLUSH BUFFER_CACHE;" Oracle's data buffer ...READ MORE

Dec 14, 2022 in AWS by Tejashwini
• 3,820 points
430 views
+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