Shulou(Shulou.com)05/31 Report--

This article is to share with you the contents of oracle installation needs to pay attention to for the first time. Xiaobian thinks it is quite practical, so share it with everyone for reference. Let's follow Xiaobian and have a look.

When installing for the first time, the following list needs to be confirmed:

1. When creating control files, you need to confirm the needs of MAXINSTANCES, MAXDATAFILES, MAXLOGFILES, MAXLOGMEMBERS, and MAXLOGHISTORY, redo log size considerations, so as to avoid future expansion.

2. Configure the attributes of the table.

3. Configuration of initial parameters, such as process, DB_NAME, DB_DOMAIN, OPEN_CURSORS, CONTROL_FILES, DB_FILES, COMPATIBLE, DB_BLOCK_SIZE, SGA_TARGET, PGA_AGGREGATE_TARGET, PROCESSES, SESSIONS, UNDO_MANAGEMENT, UNDO_TABLESPACE

4. Character set consideration.

5. Design of table space.

For memory settings:

For OLTP systems

SGA Memory =(Physical Memory *80%)*80%

PGA Memory =(Physical Memory *80%)*20%

For DSS systems

SGA Memory =(Physical Memory *80%)*50%

PGA Memory =(Physical Memory *80%)*50%

Thank you for reading! About "oracle first installation needs to pay attention to what" this article is shared here, I hope the above content can be of some help to everyone, so that everyone can learn more knowledge, if you think the article is good, you can share it to let more people see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.