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.

 

acehints.com Copyright 2011-20 All Rights Reserved | Site Map | Contact | Disclaimer