Re: v$osstat empty on Oracle Autonomous Database

AWR report shows it in 'Parameters modified by this container' section

On Mon, Jul 17, 2023 at 4:46 PM Nenad Noveljic <nenad.noveljic_at_gmail.com> wrote:

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

-- 
Regards
Timur Akhmadeev

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