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,
SQL Script to Find out Total SGA and Current SGA Utilization
This query gives you the total SGA and its current usage by combining v$sga, v$sgastat and v$sga_dynamic_components dynamic views.
