Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SELECT, INSERT, UPDATE, DELETE Prioritization

dariusrusAug 28 2006 — edited Aug 28 2006
Hi,

Is it possible to put priority on SELECT, INSERT, UPDATE, DELETE ?

what I would want to achive is to get SELECT statemets to run with a higer priority then UPDATE for example, (because on UPADATE I have triggers that take alot of CPU resources and the server response is slow for SELECT statemets)

If this is possible how should I do that or where I can find some documentation related to this?

Thank you,
Darius
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 25 2006
Added on Aug 28 2006
4 comments
682 views