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


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')
select STAT_NAME,VALUE/1024/1024/1024 || ' GB'  ,COMMENTS from v$osstat where stat_name  IN ('PHYSICAL_MEMORY_BYTES')


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

Related Topics

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

You May Also Like

Shell script for monitoring blocking sessions
Find user commits per minute in oracle database
How to flashback a RAC database
How to deinstall/cleanup standalone grid infrastructure
OGG-00665 OCI Error describe for query
ORA-01536: space quota exceeded for tablespace
Shell script to monitor goldengate process
Upgrade database using OEM 12C cloud control
CONTENT parameter in datapump
How to change flash recovery area location

From This Website

How to stop MySQL on Linux and Windows
How to move spfile from file system to ASM in RAC
How to move AUD$ table to another tablespace using DBMS_AUDIT_MGMT
SAMPLE parameter in EXPDP to export subset of data
How to use expdp to export data from physical standby database
How to enable active dataguard in physical standby database
Apply database proactive bundle patch in RAC using manual process
how to change archivelog destination in oracle
ORA-02304: invalid object identifier literal while import with CREATE TYPE OID