Re: v$osstat empty on Oracle Autonomous Database

Thanks. How do you query the value of undocumented parameter _rsrc_cpu_count on ADB? There's no sysdba access there.

Best regards,
Nenad

On Mon, Jul 17, 2023 at 3:00 PM Timur Akhmadeev <timur.akhmadeev_at_gmail.com> wrote:

> >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