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.
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.
