Learn Oracle Administration best practices, configurations, and expert tips for smooth database management. Optimize performance and security today!
we can create an Oracle Database using the below two methods: Using the DBCA Method Using Manual/Command line Method DBCA stands for Database Configuration Assistant - It is a utility…
If you have already installed Oracle VirtualBox and the Linux operating system, you can proceed with the Install Oracle 19c software part. If you do not have a virtual Box…
To set up Oracle VirtualBox on your Windows/MacBook, first, you have to download and Install the Oracle Virtual Box software. You can follow the steps provided in the post How…
You can easily setup MobaXterm on your laptop/desktop to access the virtual machines created in your VirtualBox. If you do not have VirtualBox on your machine then follow my other…
Putty is a popular tool to establish connections securely and efficiently from your machine (laptop/desktop) to the remote servers created in your virtual machines. To know how to setup Putty…
Oracle VirtualBox is a platform to run multiple operating systems on a single machine. If you have a Windows laptop, there's a general dilemma: you may want to install the…
Do you know how to troubleshoot high FRA usage in Oracle, if you are looking for the same, then you are at the right place. FRA stands for fast recovery…
change instance name in Oracle Database
In our operational daily basis DBA activities, it is important to know the schema size, table size, DB size, object size etc. So here are the proper steps/commands where you…
Do you know why stats gather is required in Oracle Database? i)As a DBA we may see that, highly transactional tables often gets stale. So stats gather can improve its…