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
Throughput, latency, concurrency
The difference between making a good and a bad decisions often comes down to the quality of the pre-defined metrics. If the metric is poor…
View More Throughput, latency, concurrency
CURSOR_SHARING(EXACT/FORCE/SIMILAR) In ORACLE
How CURSOR_SHARING works in ORACLE?CURSOR_SHARING determines what kind of SQL statements can share the same cursors. The possible values are EXACT which is the default value and…
View More CURSOR_SHARING(EXACT/FORCE/SIMILAR) In ORACLE
Adding postgres as SUDOERS in centos
Login as root: :wq!
View More Adding postgres as SUDOERS in centos
How to Configure SCRAM and MD5 Authentication in Pgpool-II
scram-sha-256 Authentication Configuration To perform the password-based authentication, Pgpool-II requires a password file which contains a list of database users and passwords in format username:password. The…
View More How to Configure SCRAM and MD5 Authentication in Pgpool-II
Schema vs User (Role) in Postgres
In Postgres and Oracle schemas and users (roles) are different entities. When you create a user in Oracle it is a schema at the same…
View More Schema vs User (Role) in Postgres