There are three broad categories for setting up a database when you install Oracle database using the installation wizard:
Transaction Processing: Online transaction processing is typically for applications with multiple users inserting and updating low volumes per transaction
General Purpose: A batch application that loads large volumes of data during specific windows
Data Warehouse: An application that can have multiple users (transactions) requesting large volumes of data for read-only
Identify the key stakeholders, business process owners, and system owners within the identified process flows.
To determine the initial configuration of the database, it is important to get an understanding of the number of users and the expected volumes you will be processing:
1. Schedule meetings with the stakeholders.
2. Ask key questions to understand the nature of the solution:
a. How many anticipated users do you expect for the solution?
b. What...