4 min read
Oracle's Distributed Database Option provides the ability to perform transactions spanning multiple networked databases. As in standalone databases, transactions may...
Month: June 2023
4 min read
2 min read
You can use Oracle OPatch utility to check all the Oracle Patches applied in Oracle database. opatch utility is located...
7 min read
What is Oracle Clusterware – RAC ? Oracle Clusterware enables servers to communicate with each other, so that they appear...
7 min read
You can query the v$session_longops view to find long-running queries and you can query the AWR to find historical queries...
2 min read
To find stale objects and the last analyzed date for tables and indexes in an Oracle Database, you can query...
2 min read
MySQL Server - Version 5.1 and later The simplest way to find long running queries are to look at the...
6 min read
Temporary Tablespaces A temporary tablespace does exist on a permanent basis as do other tablespaces, such as the System and...
