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
55 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
223 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
124 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,470 points
43 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