Re: Find out how many CPUs ?

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 29 Sep 2006 08:45:00 -0700
Message-ID: <1159544699.951213.21330@h48g2000cwc.googlegroups.com>

klabu wrote:
> 10g
> Is there a way/view to find out from WITHIN Oracle (i.e. No access to
> OS)
> How many CPUs on the server ?
>
> thx

V$OSSTAT: SELECT

  MAX(DECODE(STAT_NAME,'NUM_CPUS',VALUE,1)) CPUS,
  MAX(DECODE(STAT_NAME,'NUM_CPU_CORES',VALUE,1)) CPU_CORES,
  MAX(DECODE(STAT_NAME,'BUSY_TIME',VALUE,0)) BUSY_TIME,
  MAX(DECODE(STAT_NAME,'IDLE_TIME',VALUE,0)) IDLE_TIME,

(MAX(DECODE(STAT_NAME,'BUSY_TIME',VALUE,0))/MAX(DECODE(STAT_NAME,'NUM_CPUS',VALUE,1)))/24/ 3600/100 BUSY_DAYS, (MAX(DECODE(STAT_NAME,'IDLE_TIME',VALUE,0))/MAX(DECODE(STAT_NAME,'NUM_CPUS',VALUE,1)))/24/ 3600/100 IDLE_DAYS
FROM
V$OSSTAT; Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Fri Sep 29 2006 - 10:45:00 CDT