Sponsor of the Day:
Jerkmate
https://dbaclass.com/article/how-to-find-fragmentation-in-oracle-table/
How to find fragmentation in oracle table DBACLASS
When a lot of DML operations happens on a table, the table will become fragmented because DML does not release free space from the table below the HWM. So...
findfragmentationoracletabledbaclass
https://dbaclass.com/
KNOWLEDGE BASE FOR DBA DBACLASS
knowledge basedba
https://dbaclass.com/article/get-export-dump-pluggable-database/
How to get export dump in pluggable database oracle 12c DBACLASS
Nov 7, 2018 - In the multitenant database, For getting an export dump from the pluggable database, we need a follow a bit different process. DEMO: PLUGGABLE DATABASE(PDB) –...
database oraclegetexportdumppluggable
https://dbaclass.com/article/change-the-execution-plan-without-changing-the-sql-query/
change the execution plan without changing the sql query - DBACLASS DBACLASS
There are few situations where we know the execution plan of a particular query can be improved with use of proper hint, But if we are not allowed to change...
execution planwithout changingsql querychangedbaclass
https://dbaclass.com/article/hive-installation-mysql-database/
Hive installation with mysql database - DBACLASS DBACLASS
Mysql database installation and configuration 1.Download and install and its dependencies. 2.Initialize db with command $ mysql_install_db connect to mysql...
mysql databasehiveinstallationdbaclass