How to Setup Free Oracle Cloud Infrastructure (OCI) Account

Step 1 
Go to the free account web link. 
https://www.oracle.com/cloud/free/#free-cloud-trial 
Click on "you can sign up on the Oracle Cloud Free Tier" sign up on the bottom of the page.

SQL Query to Get Oracle Database Server CPU, CPU CORE, CPU Sockets and Physical Memory

Some Definitions 

CPU 

– Number of Processing Units in the server which is a main component of a server. 

RMAN / SQL query to Get Oracle Database Incarnation Details

What is Database Incarnation?

Database incarnation is effectively a new “version” of the database. A new version or Incarnation happens when you reset the online redo logs using “alter database open resetlogs;”.

SQL Query to Get Oracle DB TIMEZONE details

In this post I am adding some useful sql query to find out the oracle database TIMEZONE details.

How to Check, Disable and Enable Recyclebin in Oracle Database

Check whether recyclebin is enabled or not using below commands.

SQL Query to Get Oracle Blocking Sessions

In this post I am going to explain you how to get the Oracle blocking session details. 

SQL 

Get details of which session is blocking and waiting.

SQL Script to Check the Open Cursors in the Oracle Database

SQL Query

set pages 1000 lines 120
col username for a15
SELECT 	OC.inst_id, 
		OC.user_name username,