Below script is useful in getting CPU, memory and core, socket information of a database server from SQL prompt.

SCRIPT:

set pagesize 299
set lines 299
select STAT_NAME,to_char(VALUE) as VALUE  ,COMMENTS from v$osstat where stat_name  IN ('NUM_CPUS','NUM_CPU_CORES','NUM_CPU_SOCKETS')
union
select STAT_NAME,VALUE/1024/1024/1024 || ' GB'  ,COMMENTS from v$osstat where stat_name  IN ('PHYSICAL_MEMORY_BYTES')

OUTPUT:

STAT_NAME                        VALUE                                       COMMENTS
-------------------------------- ------------------------------------------- --------------------------------------------------------
NUM_CPUS                         256                                         Number of active CPUs
NUM_CPU_CORES                    32                                          Number of CPU cores
NUM_CPU_SOCKETS                  4                                           Number of physical CPU sockets
PHYSICAL_MEMORY_BYTES            255.5 GB                                    Physical memory size in bytes
SCRIPT DATABASE SCRIPTS


Related Topics

Find sessions consuming lot of CPU
Script to get cpu usage and wait event information in oracle database
How to find cpu and memory information of oracle database server
Get sid from ospid
How to get tablespace quota details of an user in oracle
Find the active transactions in oracle database
Find pending distributed pending transactions in oracle
Find user commits per minute in oracle database
How to monitor parallel queries in oracle db
How to find execution history of an sql_id

You May Also Like

ORA-32771: cannot add file to bigfile tablespace
SET ROWLIMIT in oracle 18C - New feature
Apply patch on oracle 12.2 database ( Release update)
Shell script to report failed login attempt in oracle
SKIP_CONSTRAINT_ERRORS as DATA_OPTION in impdp
Ansible script to run script on remote server and fetch the output
How to keep or delete columns/Variable of a data frame in R
How to install postgres database on mac os/linux
Lock account automatically with INACTIVE_ACCOUNT_TIME
How to recreate MGMT database in ORACLE 12C GRID

From This Website

How to enable active dataguard in physical standby database
Query clause in oracle datapump expdp
How to install trace file analyzer( TFACTL)
How to enable flash recovery area in oracle database
How to stop MySQL on Linux and Windows
SAMPLE parameter in EXPDP to export subset of data
Important views in For Oracle DBA in daily usage
Get sid from ospid
Install oracle enterprise manager cloud control 12c
orapwd tool for password file in oracle