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
• 1,825 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,128 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,991 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,384 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

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
• 5,380 points
• 1,449 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