SQL Query to Get Oracle Database Server CPU, CPU CORE, CPU Sockets and Physical Memory

Some Definitions 
– 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.


Oracle (580) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips

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