ORA-00020: maximum number of processes exceeded
As a DBA, we often encounter the ORA-00020 error. Today we will discuss how to deal with that situation with detailed steps. Steps to resolve ORA-00020 Error : Step 1:…
As a DBA, we often encounter the ORA-00020 error. Today we will discuss how to deal with that situation with detailed steps. Steps to resolve ORA-00020 Error : Step 1:…
Often in our daily DBA tasks, we may get the requirement to grant all privileges to user in Oracle. Today we will learn about this. Steps to Grant All Privileges…
Use the script below to find the active and inactive session details in Oracle database. It script can be used in the Oracle RAC database also. -- Adjust output formatting…
Use the script below to find out the total session count as well as the active & inactive session count in Oracle database. - Adjust formatting set linesize 700 set…
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…
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…
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…
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…
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…
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…