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
Category: Oracle
Oracle
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
Concurrency Control
Concurrency Control is a mechanism that maintains consistency and isolation, which are two properties of the ACID, when several transactions run concurrently in the database.…
View More Concurrency Control
Migration from Oracle to Postgres
Data Type Mapping PostgreSQL has rich set of data types. Some of the important Data type conversion between Oracle and PostgreSQL is as follow. Oracle…
View More Migration from Oracle to Postgres
Display big numbers in SQLPLUS
NUMWIDTH setting which is by default 10 and hence you can display only 10 numbers without conversion but anything beyond that becomes exponential format. SHOW…
View More Display big numbers in SQLPLUS
Oracle database Patch on windows platform
Apply Oracle Patch on windows platform NOTE:412160.1 – Updated DST Transitions and New Time Zones in Oracle RDBMS and OJVM Time Zone File Patches 1. Set…
View More Oracle database Patch on windows platform
Statistics History restore table old stats in Oracle
Restore old table statistics in Oracle Check and Restore the old statistics of tables in OracleOracle Stats will help the optimizer to choose better execution…
View More Statistics History restore table old stats in Oracle