How to check session count in Oracle:
Use the script below to find out the total session count as well as the active & inactive session count […]
Use the script below to find out the total session count as well as the active & inactive session count […]
In your daily DBA operational tasks, you may often find to kill a session in Oracle. Today we will see
During DB performance or slowness issues, it is very important to check long running query in Oracle database as a
How to Check Long Running Query in Oracle Database: Read More »
If you are getting the error while dropping a tablespace, please follow the steps to solve the issue. SQL> drop
ORA-38301: can not perform DDL/DML over objects in Recycle Bin: Read More »
You should know at first what is AWR Report. So, AWR stands for Automatic Workload Repository. AWR is a performance
Do you know how to get DDL of a dbms_scheduler job under sys schema in Oracle, if you are looking
If you want to create an Oracle CDB using DBCA silent method then you are in the right place. Just
To enable Virtualization on Windows PCs, you have to access UEFI/BIOS. Virtualization helps your PC to install a different operating
Oracle client is software that helps to communicate between Oracle database and client applications such as SQL*plus, SQL developer, Putty,