You can use the Oracle dbms_stats and export utilities to migrate schema statistics from your PROD instance to your TEST instance, so that your developers…
View More Export Import statistics with dbms_stats in Oracle
Month: March 2022
Oracle Version Numbers
Something that always comes up when discussing Oracle versions is that I am not always sure which number is the Major Database Release and which is the Database…
View More Oracle Version Numbers
Find password for database link (<= 11.2.0.2)!
when we need to recreate a database link for some reason and we do not happen to have the password handy, weβre usually stuck. However,…
View More Find password for database link (<= 11.2.0.2)!
How to check progress of a long running statistics gathering job
If you have a long-running statistics job running, you can check it from v$session_longops: For example, you execute: Check progress with:
View More How to check progress of a long running statistics gathering job
Gather Schema Stats using DBMS_STATS.GATHER_SCHEMA_STATS
DBMS_STATS package was introduced in Oracle 8i and used to gather Database,table,Schema,dictionary and fixed object statistic in Oracle database. Statistic of objects should be up…
View More Gather Schema Stats using DBMS_STATS.GATHER_SCHEMA_STATS
convert seconds into mins hours in Oracle
Oracle Standby Redo Logs vs Online Redo Logs:
Redo Logs Conceptually, Oracle Redo Logs are a collection of Redo records. Redo records are a group of change vectors. Each change vector denotes a…
View More Oracle Standby Redo Logs vs Online Redo Logs:
DBA Interview Questions
1-Explain the security practices such as LDAP SSL SSO and certificate management LDAP: Lightweight Directory Access Protocol–LDAP is a tool for extracting and editing data…
View More DBA Interview Questions
MySQL login root without password in Linux
to add more users just add more user and password in ~/.my.cnf
View More MySQL login root without password in Linux
Install MySQL Docker
I assume Docker already installed and running. Pull mysql container You can specify version (5.7). If version is not given it will download latest version.…
View More Install MySQL Docker