Samir Roy, Author At DBA POSTMORTEM

Grant All Privileges to User in Oracle :

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

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