or
View More 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
Drop Objects in Oracle
The best and most efficient way is to catch the “table not found” exception: this avoids the overhead of checking if the table exists twice;…
View More Drop Objects in Oracle
SQL Developer autocommit on/off
Click the checkbox to turn it on. Hereโs what the setting does: Value Impact Checked Autocommit is on. SQL statements that change data will have…
View More SQL Developer autocommit on/off
How to Configure Virtual IP Address (VIP) on CentOS
As its name suggests, Virtual IP address (VIP) is an IP address that doesn’t have an actual physical network interface. Incoming packets are sent to…
View More How to Configure Virtual IP Address (VIP) on CentOS
Resource limit of sessions and processes in Oracle
Check the resource limit of session and processes in Oracle With help of V$RESOURCE_LIMIT view, we can see the current utilization and MAX utilization of…
View More Resource limit of sessions and processes in Oracle
Oracle GoldenGate vs Oracle Data Guard
The configuration of Oracle GoldenGate / Data Guard has the purpose of synchronizing data between two or more systems . The basic features of the…
View More Oracle GoldenGate vs Oracle Data Guard