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

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

You May Also Like

Shell script to monitor asm diskgroup usage
Enable DDL replication in goldengate
Ansible script to run script on remote server and fetch the output
How to move AUD$ table to another tablespace using DBMS_AUDIT_MGMT
FLASHBACK parameter in DATAPUMP(EXPDP)
Generate custom report from OEM cloud control
ORA-01536: space quota exceeded for tablespace
ESTIMATE REQUIRED DISK SPACE FOR EXPORT USING estimate_only
DEFERRED_SEGMENT_CREATION parameter in oracle
Add database as target oracle 12c cloud control

From This Website

How to generate AWR report in RAC
how to send mail using utl_mail in oracle 11g
ORA-30034: Undo tablespace cannot be specified as temporary tablespace
orapwd tool for password file in oracle
How to find cpu and memory information of oracle database server
LOG_CHECKPOINTS_TO_ALERT parameter in oracle
Hive installation with mysql database
REUSE_DUMPFILES parameter in EXPDP
Apply database patch from OEM Cloud control
ORA-32774: more than one file was specified for bigfile tablespace