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.

CPU Core 
– Brain of the CPU. Each core performs operations separately from others. Multiple cores works to together to perform a parallel operation.

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.
SQL> SELECT version FROM v$timezone_file;

   VERSION
----------
      32

 

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