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