We have couple of programs for our internal application.
We use some custom tables which are temporary and used within the programs. One table per program and never used by any other program. Ever since, we upgraded to 19C, we started getting this error once a month in different programs, even though we run the program once a day and the table being truncated is used only that particular process.
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired