October 22, 2020

How to create Oracle Autonomous Database in OCI

What is autonomous database:-  An Oracle Autonomous Database is a cloud-based technology designed to automate many of the routine tasks required to manage Oracle databases which is mostly done by DBA's. It uses machine learning to automate database performance tuning, backups, securing database , patching etc.

Types of autonomous database based on workload :-


  •  Autonomous transaction processing
  •   Autonomous data warehouse
  •   Autonomous Json Database

To create Autonomous database, first login to Oracle cloud (www.oracle.com/cloud




Provide details such as Display name , Database name , Workload type- which is autonomous transaction processing in our case , deployment type- shared infrastructure ,DB Version , Cpu count , storage etc. In our case we chose “Always Free” option which comes with default 1 Ocpu and 20GB of storage.
















So this concludes the creation of Oracle Autonomous Database.


No comments:

Post a Comment

How to Change MAX_STRING_SIZE in a PDB (Oracle 19c Step-by-Step Guide)

  Changing MAX_STRING_SIZE in a PDB (What Worked for Me) I recently had to deal with a requirement where the application team wanted to st...