Re: Find out how many CPUs ?

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 29 Sep 2006 09:37:37 -0700
Message-ID: <1159547856.994884@bubbleator.drizzle.com>

Charles Hooper wrote:
> 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.
>

Wouldn't
SELECT value
FROM gv$osstat
WHERE stat_name = 'NUM_CPUS';

Be a bit more direct?

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group

Received on Fri Sep 29 2006 - 11:37:37 CDT