Oracle’s Distributed Database Option provides the ability to perform transactions spanning multiple networked databases. As in standalone databases, transactions may block each other as they try to exclusively access database table rows, causing Locking Conflicts.In the former case, tools and scripts exist that can help the DBA detect and resolve such conflicts. In distributed databases, … Read more
You can use Oracle OPatch utility to check all the Oracle Patches applied in Oracle database. opatch utility is located under $ORACLE_HOME/OPatch directory. Run the opatch lsinventory command to get the list of interim patches applied. 1. Listing Applied Patches 2. Using opatch lsinventory 3. To get information on particular patch ID/ Check patch is … Read more
What is Oracle Clusterware – RAC ? Oracle Clusterware enables servers to communicate with each other, so that they appear to function as a collective unit. This combination of servers is commonly known as a “cluster”. Oracle Real Application Clusters known as Oracle RAC uses Oracle Clusterware as the infrastructure that binds multiple nodes that … Read more
You can query the v$session_longops view to find long-running queries and you can query the AWR to find historical queries (if you have purchased the AWR packs).. The Oracle data dictionary contains a little-known view called the v$session_longops. The v$session_longops view allows the Oracle professional contract the amount of time that is used by long-running … Read more
To find stale objects and the last analyzed date for tables and indexes in an Oracle Database, you can query the data dictionary views DBA_TAB_STATISTICS, DBA_IND_STATISTICS, and DBA_OBJECTS. Stale statistics are indicated by the STALE_STATS column in the DBA_TAB_STATISTICS view for tables and in the DBA_IND_STATISTICS view for indexes. Find Stale Tables Find Stale Indexes … Read more
MySQL Server – Version 5.1 and later The simplest way to find long running queries are to look at the process list. There are various options how to do this depending on your version and whether you have the Sys Schema installed. The Sys Schema session View In MySQL 5.6 or later with the Sys … Read more
Temporary Tablespaces A temporary tablespace does exist on a permanent basis as do other tablespaces, such as the System and Sysaux tablespaces. However, the data in a temporary tablespace is of a temporary nature, which persists only for the length of a user session. Oracle uses temporary tablespaces as work areas for tasks such as … Read more