This post is all about monitoring Data Pump jobs, checking expdp or impdp status, to kill running jobs, troubleshoot hung…
The default DBA role is automatically created during Oracle Database installation. This role contains most database system privileges. Therefore, the…
Getting below error while installing oracle 11g/12c database using DBCA. UnsatisfiedLinkError exception loading native library: njni11java.lang.UnsatisfiedLinkError: /home/u01/app/oracle/product/11.2.0/db_1/lib/libnjni11.so: libclntsh.so.11.1: cannot open…
Oracle has inbuilt features using which you can convert scn to timestamp and timestamp to scn. SCN_TO_TIMESTAMP takes as an…
A materialized view is a table segment or database object that contains the results of a query. A materialized view…
Sometimes it is required to flush the single sql plan from the shared pool and it a good idea rather…
There are various ways to describe table in vertica, among some of them are listed below. List table definition using…
Being a DBA, you often asked to check the status of RMAN backup job details. You can monitor progress and…
Being a DBA, there are many occasions where you need to move all database objects from one tablespace to another…
Vertica advances the AHM at an interval of 5 minutes to be equal with Last Good Epoch – LGE. Because…