In today’s data-driven world, database security is more critical than ever. Microsoft recognizes this need and has responded with SQL...

Many times, I got the question from my colleague or training participants, how to login MySQL if I forgot the password. I have explained...

Oracle Database 21c is the first Oracle database release with CDB-only architecture. Oracle 20c was announced only CDB architecture but...

Since a new version is coming out every year, Oracle’s release roadmap introduced two types of annual releases. Interim releases (20c,...

While you are working on SQL*Plus and RMAN on Linux environment and you did some mistake and you want to edit your query it won’t work by...

Backspace key does not work in sqlplus. It's not a issue form Oracle. This is a terminal type issue. echo $TERM stty -a and see if you...

In this demo i am sharing you some handy script to monitor your database object. Monitor the list of tables with number of rows and...

Different Backup mode in SQL Server. As a DBA you must know how point of time recovery performed? Answer : Point In-Time recovery means...

Oracle Cloud Platform MySQL database Service is available on Oracle Cloud with fully-managed Cloud Infrastructure native service, The...

As a DBA sometimes we get the task to remove MySQL installation from Server. We have to uninstall MySQL completely from the system and...

Oracle 20c is available for preview mode on the Oracle Public Cloud. Preview version databases are not intended for production use and...

Autonomous Database is able to connect Non-Oracle Database (DB2, Teradata, SQL Server etc) via Oracle Database Gateway. Oracle Database...

Standby database is now supported in Autonomous Database. When you enable Autonomous Data Guard on ADB support only 19c and above...

Apply the patch is DBA responsibility and we applied it Quarterly as per our GMB plan based on Oracle release patch. You can identified...

Learn Performance Tuning from Oracle Expert. If interested to join drop an email to info@dbatrainings.com or WhatsApp / Call...

AWS recently introduced new features now customer is able to stop Amazon EC2 Spot Instances backed by Amazon EBS and start them at will,...

Cloud provider is giving many new features to customer. Now AWS is also offering Scaling features similar to Oracle. AWS has introduced...

If you are facing such an issue in your MySQL environment for Password policy you need to reset your password validate the policy. The...

In this post, I am going to describe to you, step by step process for database refresh using datapump (EXPDP/IMPDB). In this example, my...

As a DBA sometimes you need to know how what’s taking space in an Oracle database, or how large is the table you’re working on, here’s a...