Re: v$osstat empty on Oracle Autonomous Database

Have a look here
https://sqlmaria.com/2020/04/14/generating-an-awr-report-for-autonomous-databases/ ,
and diag&tuning are included with ADB (servetrless) Regards

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

> 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