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

Home » Misc » Here

Comments

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...

Hi.

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.

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!