Set process priority in ORACLE

Source: Internet
Author: User

ORACLE sets the process priority in the operating system. We can use the renice command to set the process priority so that the process can obtain the CPU time slice first. In ORACLE, the parameter _ high_priority_processes can also be used to set the priority of a process. Generally, we may add the LGWR process to this parameter. In my RAC test environment, this parameter adds the LMS process. SQL> SELECT x. ksppinm NAME, y. ksppstvl VALUE, x. ksppdesc describ 2 FROM x $ ksppi x, x $ ksppcv y 3 WHERE x. inst_id = USERENV ('instance') 4 AND y. inst_id = USERENV ('instance') 5 AND x. indx = y. indx 6 AND x. ksppinm LIKE '% _ high_priority_processes %' 7/name value describ ------------------------------ ---------- partition _ high_priority_processes LMS * High Priority Process Name Mas K if the LMS process does not obtain the CPU time slice for a long time, split-brain may occur. If the CPU time slice is obtained first, the probability of split-brain can be reduced. If you need to set multiple processes for, use | to separate multiple processes. * Indicates a wildcard. SQL> alter system set "_ high_priority_processes" = 'lms * | LGWR | PMON 'scope = spfile; System altered. SQL> startup force nomountORA-32004: obsolete and/or deprecated parameter (s) specifiedORACLE instance started. total System Global Area 1.0737E + 10 bytesFixed Size 2101912 bytesVariable Size 1.0586E + 10 bytesDatabase Buffers 134217728 bytesRedo Buffers 14671872 bytesSQL> show parameter _ partition name type Limit VALUE limit _ limit stringLMS * | LGWR | PMONSQL> set linesize 100SQL >_high_priority_processesSP2-0734: unknown command beginning "_ high_prio... "-rest of line ignored. SQL> show parameter _ high_priority_processes NAME TYPE VALUE -------------------------------------------------- _ high_priority_processes string LMS * | LGWR | PMON

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.