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…
Vertica store table data in compressed format. To get the size of a table in vertica, you can use the…