8i | 9i | 10g | 11g | 12c | Misc | PL/SQL | SQL | RAC | Linux

Home » Misc » Here

Comments for Resource Manager

Resource Manager - Prevent batch processes interfering with your OLTP transactions by using this simple PL/SQL API to assign a priority to each type of session.

Laurent said...

The RESOURCE_MANAGER_PLAN parameter is used to tell the instance which resource plan to use. This can be set in the init.ora file or by using the ALTER SESSION command.

-->"alter session" : no, "alter system" yes

TIm... said...


LOL. The sentence was wrong, but the command following it was right. I think I need an editor. :)

I've corrected it now. Thanks for the heads-up.


Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired