From dynatrace (only) you will not have access to such informations. You can see only ORA exceptions on transactions.
this feature may give you some extra insights about your DB. But in most cases help of DBa would be priceless.
You’re right, it’s probably because of how engine works. In general I would look for slow or failed queries in Dynatrace in timeframe near locks. Then you should send them to DBA for analysis I think.
If you want to be alerted in such case you will be because of failure rate and slowdown on DB. You don’t need to configure anything more. But when you want just analysis you can filter data you already have.