How to kill a session in Oracle database:
In your daily DBA operational tasks, you may often find to kill a session in Oracle. Today we will see how to deal with that situation with proper and simple…
Learn Oracle Administration best practices, configurations, and expert tips for smooth database management. Optimize performance and security today!
How to Check Long Running Query in Oracle Database:
During DB performance or slowness issues, it is very important to check long running query in Oracle database as a DBA. Today we will learn how to check this with…
ORA-38301: can not perform DDL/DML over objects in Recycle Bin:
If you are getting the error while dropping a tablespace, please follow the steps to solve the issue. SQL> drop tablespace USER_TBS including contents and datafiles;drop tablespace USER_TBS including contents…
How To Generate AWR Report in Oracle :
You should know at first what is AWR Report. So, AWR stands for Automatic Workload Repository. AWR is a performance Report which collects the data of Oracle database in regular…
How to get DDL of a dbms_scheduler job :
Do you know how to get DDL of a dbms_scheduler job under sys schema in Oracle, if you are looking for the same then this article is for you. In…
Create Oracle CDB using DBCA silent method:
If you want to create an Oracle CDB using DBCA silent method then you are in the right place. Just go through the article and at the end of this…
How to enable Virtualization on Windows PCs:
To enable Virtualization on Windows PCs, you have to access UEFI/BIOS. Virtualization helps your PC to install a different operating system, like Android™ or Linux. Many Windows 10 PCs and…
How to download Oracle 19c client:
Oracle client is software that helps to communicate between Oracle database and client applications such as SQL*plus, SQL developer, Putty, or mobaxterm. To download Oracle 19c client, first open the…
How to create Oracle database manually:
In this article, I will show you the detailed steps on how to create Oracle database manually. I think you all know how to create Oracle database through DBCA GUI…
How to create and drop oracle database using DBCA silent method:
You can create and drop oracle database using DBCA silent method. In this article, I will show you the detailed steps for the same: create and drop Oracle database using…