Re: v$osstat empty on Oracle Autonomous Database

Thanks. Do all ADBs include the EE license with Diagnostic and Tuning Pack, i.e. is it safe to run AWR report on any ADB instance?

Best regards,
Nenad

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

> 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