Oracle Test Environment parameter tuning.

Test environment above Oracle database performance parameter settings

1. Close the Recycle Bin

Alter system set Recyclebin=off

2. Modify the size of the redo log

The default size of 11g is 50m if redo file compares small OLTP logs more than the case will cause more redo FileSwitch recommended to modify the default size at DBCA time 500m to 1G better.

If you have already created and the table is small, you can execute commands in the database to add a new redo file and then delete the old redofile for processing.

ALTER DATABASE Add logfile Group x (' Dir\redofile.name ', ' dir\anotherdb.name ') size XXXXM;

Then alter system switch logfile

View Log Status

SELECT group#, members, bytes/1024/1024 BYTE_MB, status from V$log;

Alter system checkpoint

ALTER DATABASE drop logfile Group 1 # Delete inactive log file

Improve performance

3. Modifying the memory parameters of Oracle

1) Memory_target set to 0 off AMM memory management

alter system Set sga_max_size = Xxg scope=spfile;

Alter system set SGA_TARGET=XXG Scope=spfile;

Alter system set PGA_AGGREGATE_TARGET=XXXG Scope=spfile;

Alter system set Db_cache_size =XXG

Alter system set Shared_pool_size =XXG

Note that db_cache_size + shared_pool_size cannot be larger than the size of the SGA area

4. ORACLE12C in-memory database parameters

First increase the size of Oracle's In_memory

alter system Set Inmemory_size = Xxg Note that the parameters of inmemory are also in the SGA area

Alter tablespace XXX default inmemory

You can also place tables or views separately in the InMemory area, but each has its own benefits.

5. Parameters such as session and process modification.

6. Linux database when you enable hugepage way to improve performance,---you have forgotten how to configure.

7. Improve performance with ASM storage, and use raw disk to address the IO loss of the virtualization layer and the operating system layer.

Oracle Test Environment parameter tuning.