Shulou(Shulou.com)06/01 Report--

After Oracle 11g is installed and the database is built, some adjustments need to be made to make the database stable and efficient. It took a while to collate the following parameter setting specifications for reference only.

I. Database establishment parameter setting

1. Number of processes and sessions (default 150)

--View processes and sessions show parameter process;show parameter sessions;--Modify processes and sessions alter system set processes=1200 scope=spfile; alter system set sessions=1325 scope=spfile;

Reference: sessions = 1.1 * processes + 5

2. Number of cursors

--View number of cursors show parameter open_cursors;--View number of cursors currently open select count(*) from v$open_cursor;--Modify maximum number of cursors alter system set open_cursors=1000 scope=both

3. Character set (it is recommended to set it up when building the library)

--Query character set of database server: NLS_LANG = language_territory.charset select * from nls_database_parameters;--Common server parameter settings export NLS_LANG= AMERICAN_AMERICA.UTF8export NLS_LANG= AMERICAN_AMERICA.AL32UTF8

4. SGA PGA Size

oltp system reference (to be set well, to prevent memory jitter): sga= memory *80%*80% pga= memory *80%*20%

show parameter memory; show parameter sga; show parameter pga;--If you want to prevent memory jitter under high concurrency conditions, consider fixed memory alter system set memory_target=4096m scope=spfile;alter system set memory_max_target=4096m scope=spfile; alter system set sga_target=3027 m scope= spfile; alter system set sga_max_size=3027m scope=spfile;alter system set pga_aggregate_target=3027 m scope=spfile; alter system set pga_aggregate_target=1024m scope=spfile;

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.