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…