Re: v$osstat empty on Oracle Autonomous Database

>The cpu_count parameter seems to reflect the number of OCPUs.

I've a few ADBs where cpu_count = 6 * OCPU, and OCPU = _rsrc_cpu_count. My guess is OCPU is limited via the underscore parameter, and cpu_count is derived from it. Is it different in your case? Real cpu_count is not visible anywhere. You may try using Runtime.getRuntime().availableProcessors() Java call to see if it returns anything different from cpu_count. I guess it should return the same cpu_count.

On Mon, Jul 17, 2023 at 11:51 AM Nenad Noveljic <nenad.noveljic_at_gmail.com> wrote:

> Thanks.
>
> >The number of OCPUs gives you the number of cores you have, and then *2
> to get the threads.
>
> The cpu_count parameter seems to reflect the number of OCPUs.
>
> Is there a better view than v$parameter to query it from the database?
>
> Best regards,
> Nenad
>
>>
>>

-- 
Regards
Timur Akhmadeev

--
http://www.freelists.org/webpage/oracle-l