DBAStack
5 subscribers
5 links
Navigating the World of Databases with Confidence!!
Download Telegram
Channel created
Channel photo updated
Hello All,

Please explore this article on 'Storage Engines in MySQL 8' to understand how different engines can enhance database performance.

If you enjoyed the article, please leave a comment and share it with your friends. Also, let me know which Oracle and MySQL topics you'd like to see covered in future articles.

https://dbastack.com/storage-engines-in-mysql-8/

#MySQL #StorageEngines #InnoDB
Oracle 19c RAC Database Installation Steps

Before moving towards the Oracle 19c RAC Database Installation Steps, we will first understand why we require an RAC machine.
RAC stands for Real Application Cluster, where we can create a cluster, and later, we can add multiple nodes to it.
At a high level, RAC provides a high availability solution, ensuring that if any node goes down, the client can still perform operations using the available machines.

https://dbastack.com/oracle-19c-rac-database-installation-steps/
How to run SQL Tuning Advisor in OEM 13c

In every organization, Database performance is crucial for maintaining smooth operations. The application team will always be happy if their queries take very little time for execution and they are getting results quickly. Unfortunately, this is not possible every time for them and they will straight away come to the DBA team if they are facing any query slowness issues.
Sometimes DBA can easily identify the issue, but what if they need more recommendations which help resolve the long-running queries? Here SQL tuning advisor comes into the picture which shares the best possible recommendation that helps the DBA to resolve the issue.
In this article, we will explore How to Run Sql Tuning Advisor in OEM 13c to enhance query performance effectively. It would be best if you had OEM 13c installed on your server for that first you have to download OEM 13c as per your requirement like in Linux, Windows, etc.

https://dbastack.com/how-to-run-sql-tuning-advisor-in-oem-13c/
Forwarded from Gautam Raghavan
Hello Everyone,  if anyone is interested to learn Advanced Oracle RAC along with simulation, please check below links. Links are from udemy.

There are some preview tutorials as well.

https://www.udemy.com/course/master-oracle-rac-advanced-concepts-hands-on-training-2/?couponCode=LOCLZDOFFPINTRMT

https://www.udemy.com/course/master-oracle-rac-advanced-concepts-hands-on-training-1/?couponCode=LOCLZDOFFPINTRMT