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

This article mainly shows you "how to adjust DB parameters after installation", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to adjust DB parameters after installation" this article.

Cd $ORACLE_BASE

Mkdir temp

ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED

-- number of failed login retries. Default is 10.

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED

-- the password expires automatically after how many days. The default value is 180.

ALTER SYSTEM SET utl_file_dir='/disk/oracle/temp' scope=spfile

-- create a directory that can be read and written directly for logminer or other file operations

ALTER SYSTEM SET audit_trail='NONE' SCOPE=SPFILE

-- Database audit function, which is enabled by default

ALTER SYSTEM SET "_ optimizer_use_feedback" = FALSE SCOPE=BOTH

Cardinality feedback, which evaluates the generated cardinality of tables without statistical information, but bug affects performance.

ALTER SYSTEM SET aq_tm_processes=10 SCOPE=BOTH

-- specify the number of queue monitoring processes. The default value is 0 and the maximum value is 10.

ALTER SYSTEM SET open_cursors=500 SCOPE=BOTH

-- turn on the number of cursor

ALTER SYSTEM SET open_links=255 SCOPE=SPFILE

-- number of session connections per unit

ALTER SYSTEM SET open_links_per_instance=255 SCOPE=SPFILE

-connections opened by distributed transaction sessions

ALTER SYSTEM SET session_cached_cursors=300 SCOPE=SPFILE

-- how many coursor can a single session cache?

ALTER SYSTEM SET deferred_segment_creation=FALSE SCOPE=SPFILE

-- delay the creation of segments to prevent emp empty tables from being exported

ALTER SYSTEM SET job_queue_processes=20 SCOPE=BOTH

-- the total number of processes that can be used by job jobs, with a maximum of 1000

ALTER SYSTEM SET processes=1000 SCOPE = SPFILE

-- maximum number of processes, sessions=1.1*process + 5

Shutdown immediate

Startup

The above is all the contents of the article "how to adjust DB parameters after installation". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.