Oracle Database Locking Mechanism – 2
Oracle's Distributed Database Option provides the ability to perform transactions spanning multiple networked databases. As…
Read moreJune 2023
Check the Patch Applied to the Oracle Database
You can use Oracle OPatch utility to check all the Oracle Patches applied in Oracle…
Read moreOracle Clusterware Startup Sequence
What is Oracle Clusterware – RAC ? Oracle Clusterware enables servers to communicate with each…
Read moreHow to find long running sessions in Oracle?
You can query the v$session_longops view to find long-running queries and you can query the…
Read moreHow to find Stale object and last analyzed for tables/indexes ?
To find stale objects and the last analyzed date for tables and indexes in an…
Read moreHow To Find Queries Taking Longer Than N Seconds in MYSQL ?
MySQL Server - Version 5.1 and later The simplest way to find long running queries…
Read moreOverview of Oracle Temporary Tablespace (Creating/Resizing)
Temporary Tablespaces A temporary tablespace does exist on a permanent basis as do other tablespaces,…
Read more