Re: v$osstat empty on Oracle Autonomous Database

Hi,
On ADB you don't get access to the OS, so no way of getting /proc/cpuinfo. The number of OCPUs gives you the number of cores you have, and then *2 to get the threads.

regards

On Mon, Jul 17, 2023 at 8:19 AM Nenad Noveljic <nenad.noveljic_at_gmail.com> wrote:

> Thanks. I was thinking more of getting the information from some V$ views.
>
> On Sun, Jul 16, 2023 at 10:14 PM Douglas Dunyan <dmdunyan_at_gmail.com>
> wrote:
>
>> OS ?
>> /etc/cpuinfo ?
>> Also, isn’t there something in the alert log posted during startup ?
>>
>> D
>>
>> On Sun, Jul 16, 2023 at 12:34 PM Nenad Noveljic <nenad.noveljic_at_gmail.com>
>> wrote:
>>
>>> v$osstat doesn't return any rows on Oracle Autonomous Database.
>>>
>>> Is there an alternative way to get the number of virtual CPU threads on
>>> the server?
>>>
>>> Best regards,
>>> Nenad
>>>
>>

--
http://www.freelists.org/webpage/oracle-l