June 2023

man in gray long sleeve suit holding a pen

4 min read

Oracle

Oracle Database Locking Mechanism – 2

asrblogger

Oracle's Distributed Database Option provides the ability to perform transactions spanning multiple networked databases. As in standalone databases, transactions may...

2 min read

Oracle

Check the Patch Applied to the Oracle Database

asrblogger

You can use Oracle OPatch utility to check all the Oracle Patches applied in Oracle database. opatch utility is located...

black room divider with geometric design on white surface

7 min read

Oracle Clusterware Startup Sequence

asrblogger

What is Oracle Clusterware – RAC ? Oracle Clusterware enables servers to communicate with each other, so that they appear...

unrecognizable hacker with smartphone typing on laptop at desk

7 min read

Oracle

How to find long running sessions in Oracle?

asrblogger

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

Oracle

How to find Stale object and last analyzed for tables/indexes ?

asrblogger

To find stale objects and the last analyzed date for tables and indexes in an Oracle Database, you can query...

man in brown overcoat looking at the time

2 min read

MySQL

How To Find Queries Taking Longer Than N Seconds in MYSQL ?

asrblogger

MySQL Server - Version 5.1 and later The simplest way to find long running queries are to look at the...

6 min read

Oracle

Overview of Oracle Temporary Tablespace (Creating/Resizing)

asrblogger

Temporary Tablespaces A temporary tablespace does exist on a permanent basis as do other tablespaces, such as the System and...

Oracle Database Locking Mechanism – 2

Check the Patch Applied to the Oracle Database

Oracle Clusterware Startup Sequence

How to find long running sessions in Oracle?

How to find Stale object and last analyzed for tables/indexes ?

How To Find Queries Taking Longer Than N Seconds in MYSQL ?

Overview of Oracle Temporary Tablespace (Creating/Resizing)

Create Pluggable Database (PDB) Manually Using SQL Prompt Oracle 19c !!

How to check FRA ( Fast Recovery area) Utilization in Oracle ?

How to check Tablespace Utilization in Oracle ?

Install and Configure OpenSearch & OpenSearch Dashboard

You may have missed