This query is used to find out the SQLIDs spend on the CPU, Wait and IO.
SQL Query
Script to Find Most Active Session in Oracle Database for Last One Hour
These SQLs to identify most active sessions in the oracle database for last one hour. Two queries mentioned here for the background and foreground processes.
SQL Query to Find I/O Intensive SQL and SQLText in Last One Hour
This can be used for finding out most CPU intensive query in last one hour. There are 3 data dictionary views involved in this query.
gv$active_session_history
gv$event_name
v$sqlarea
SQL Query to Find Out Oracle Session Details for a Past Time Period from the History tables
There are the 3 views can be used to achieve this goal. The columns are almost similar to the V$SESSION table except snap_id, sample_id, sample_time etc.. The AWR,
SQL Query to Find Out Pending Distributed Transaction in Oracle Database
A distributed transaction includes one or more statements that, individually or as a group, update data on two or more distinct nodes of a distributed database.
OCI-How to Generate SSH Keys for OCI instance connectivity
To connect OCI Unix instance using Putty from windows server or Unix server it requires public and private keys to establish the connection. To generate keys we can use Putty Keygen tool.
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.
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.
