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

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

You May Also Like

How to move controlfile to a new location in oracle
ERROR: No checkpoint table specified for ADD REPLICAT
How to setup dataguard broker configuration (DG broker) in 12c
How to move AUD$ table to another tablespace using DBMS_AUDIT_MGMT
ORA-20101: TABLESPACE is not a ASSM (Automatic Segment Space Management) tablespace
ORA-30034: Undo tablespace cannot be specified as temporary tablespace
Steps for changing public hostname for a standalone grid infrastructure
Open wallet automatically after starting the database

From This Website

Oracle database Security Assessment Tool
Upgrade database using OEM 12C cloud control
How to drop SQL baselines in oracle
How to get the execution plan for a SQL between two AWR snapshots
Display sql_id of the sql, using set feedback in oracle 18C - New feature
OGG-01028 partial record at sequence extract abended
How to recreate MGMT database in ORACLE 12C GRID
How to drop a database in postgres
ORA-32773: operation not supported for smallfile tablespace
How to run expdp in pluggable database(PDB)