Hi friends.
I'm running Oracle EE 11.2 on Solaris 10.
I'm digging into the use of composite limit to limit some of the resources that the report users can use on our OLTP database.
Obviously, my intention is to prevent them from bringing down our OLTP database to its knees with some runaway or heavy reports.
We all know how easy it is for report writers using Crystal Reports or some other tool to develop ad-hoc queries, joining views to views, etc.
So, I figured I could create them a profile, (e.g., reports_profile) and limit their composite_limit.
I checked out a couple of web pages and then it just got more confusing.
Wondering if anyone has done this and figured it out and able to explain it easily.
References:
ALTER RESOURCE COST
and
CREATE PROFILE
Any help would be appreciated. I read the docs, but it is still confusing.