I have seen the documentation online with respect to database user creation, permissions, and connection, but nothing with regards to actually creating the new database. Therefore, I have some questions in regards to a new Oracle 12 database creation. They are the following:
1. What are the memory requirements for the database? (PGA/SGA allocation?)
2. Are there any sizing requirements for oracle SYS/SYSAUX/USERS tablespaces?
3. I'm assuming when I create the 'jiradbuser' I will be assigning them to the USERS tablespace, correct?
4. What are the recommended number/sizing of redo log files, if needed, for the new database?
If I can get some clarification on the above, that will help me get started. Thanks