What is difference between Autonomous Database (ADB/ATP/ ATP-Dedicated) or traditional oracle enterprise database?
Maria did a blog post summarising all the differences here - this has links to videos and whitepapers. I recommend you read it.
https://sqlmaria.com/2017/11/02/oracle-autonomous-database/ But briefly
Traditional database
- *YOUR* job to create it, back it up, patch it, setup high availability, decide on indexing, buy more CPUs if you need them, etc etc
Autonomous database
- *OUR* job to create it, back it up, patch it, setup high availability, decide on indexing, etc etc
- YOUR job is .... use it.