Samir Roy, Author At DBA POSTMORTEM

ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

Today in this article, we will discuss about how to resolve if you encounter ORA-19802 error. Problem : SQL> alter […]

As a DBA, we often encounter the ORA-00020 error. Today we will discuss how to deal with that situation with

Often in our daily DBA tasks, we may get the requirement to grant all privileges to user in Oracle. Today

Use the script below to find the active and inactive session details in Oracle database. It script can be used

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

If you are getting the error while dropping a tablespace, please follow the steps to solve the issue. SQL> drop

You should know at first what is AWR Report. So, AWR stands for Automatic Workload Repository. AWR is a performance