Re: v$osstat empty on Oracle Autonomous Database

Yes, ADB comes with all options included. There are no options to choose or license extra, also no editions like SE or EE.

[image: LORE DATA]
Franky Weber Faust

Consultor de Banco de Dados | LORE DATA
Oracle ACE ♠️
Fone: *47 99125 2714*
Email: franky_at_loredata.com.br
loredata.com.br

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

> 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