CpuCount, SCSI, RAM SIZE 

Cpu Count:

specifies the number of CPUs available for Oracle Database to use

select value   from v$parameter where name like ‘cpu_count’;

SCSI:

To display the SCSI devices currently attached (and recognized) by the SCSI subsystem use.

cat /proc/scsi/scsi
The output looks like this:

[oracle@alsm ~]$ cat /proc/scsi/scsi

Attached devices:

Host: scsi0 Channel: 00 Id: 00 Lun: 00

  Vendor: VMware   Model: Virtual disk     Rev: 1.0

  Type:   Direct-Access                    ANSI  SCSI revision: 02

Host: scsi0 Channel: 00 Id: 01 Lun: 00

  Vendor: VMware   Model: Virtual disk     Rev: 1.0

  Type:   Direct-Access                    ANSI  SCSI revision: 02

Host: scsi0 Channel: 00 Id: 02 Lun: 00

  Vendor: VMware   Model: Virtual disk     Rev: 1.0

  Type:   Direct-Access                    ANSI  SCSI revision: 02

Host: scsi2 Channel: 00 Id: 00 Lun: 00

  Vendor: NECVMWar Model: VMware IDE CDR10 Rev: 1.00

  Type:   CD-ROM                           ANSI  SCSI revision: 05

RAM SIZE 
select max(value)/1024/1024 c1  from dba_hist_osstat
where stat_name = ‘PHYSICAL_MEMORY_BYTES’;

C1
———-
15879.0313

 

Hits: 3

Leave a Reply

Your email address will not be published. Required fields are marked *