Re: wrong start_time and start_date in v$transaction

Nenad, this maybe silly: have you recently done a Solaris upgrade? For instance to 11.4? If that is the case you may need to relink your Oracle home. That might fix the problem.Regards On Tue, 2020-09-08 at 11:32 +0000, Noveljic Nenad wrote:
> The dedicated process doesn’t call the timestamp function itself. It
> rather reads the current value from an address location
> which is continuously updated by the VKTM. This is probably an
> optimization, because the real time timestamp function is expensive.
>
>
>
> In my case, vktm hangs and it doesn’t update the location holding the
> current Epoch time. The stale timestamp gets then
> copied in each transaction entry.
>
>
>
> Since vktm hangs in nanosleep OS kernel call, it might be an OS
> issue:
>
>
>
> pstack 14583
>
> 14583: ora_vktm_ATRM2

-- 
Mladen Gogala

Database Consultant

Tel: (347) 321-1217


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