DBA Notes – Page 14

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…

MySQL Oracle Postgres

DBA Interview Questions

Bulent Soylu March 11, 2022 interview questions LDAP oracle ssl sso

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…

Linux MySQL

MySQL login root without password in Linux

Bulent Soylu March 2, 2022 linux mysql

to add more users just add more user and password in ~/.my.cnf

Docker MySQL

Install MySQL Docker

Bulent Soylu March 2, 2022

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.…

Oracle

Drop Objects in Oracle

Bulent Soylu February 15, 2022 drop procedure drop table 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;…

Oracle

SQL Developer autocommit on/off

Bulent Soylu February 1, 2022 autocommit oracle sql developer

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…

Linux

How to Configure Virtual IP Address (VIP) on CentOS

Bulent Soylu January 27, 2022 centos linux virtual ip

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…

Oracle

Resource limit of sessions and processes in Oracle

Bulent Soylu January 26, 2022 oracle procsesses sessions

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…