Being a DBA, you often asked to check the status of RMAN backup job details. There are many ways to monitor the progress of the backup...
Best Way to move all objects from one Tablespace to another in Oracle
Being a DBA, there are many occasions where you need to move all database objects from one tablespace to another to make them reorganized....
How to Fix AHM not Advancing to Last Good Epoch in Vertica
Vertica advances the AHM at an interval of 5 minutes to be equal with Last Good Epoch - LGE. Because of unrefreshed projections due to some...
How to Check the Size of Tables in Vertica
Vertica store table data in compressed format. To get the size of a table in vertica, you can use the below query. By using column_storage and projection_storage system tables you will get the size of table compressed format. You can check the all the column definition from the official vertica sites using below...
Subscribe to:
Posts (Atom)