Re: v$osstat empty on Oracle Autonomous Database

Maximum effort....impressive...

How To Query And Change The Oracle Hidden Parameters In Oracle 10g and Later (Doc ID 315631.1)

D

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

> 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