Re: v$osstat empty on Oracle Autonomous Database

That doesn't work on ADB - you don't have the access to X$ views there.

Best regards,
Nenad Noveljic

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

> 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