Re: v$osstat empty on Oracle Autonomous Database

Then, is there a way to retrieve the value of an undocumented parameter value on an ADB instance without EE and Diagnostic and Tuning Pack? Best regards,
Nenad

On Mon, Jul 17, 2023 at 9:14 PM Douglas Dunyan <dmdunyan_at_gmail.com> wrote:

> NO
>
> On Mon, Jul 17, 2023 at 12:13 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