YES ____________________Reply Separator____________________ Author: "Ed Lewis" <[EMAIL PROTECTED]> Date: 8/29/2002 7:23 AM
Dick and Dennis, The application here is the same, where all users are logged in as the same user via the application server. But in my case, I want to throttle all the users who use this id. Wouldn't ORM be beneficial in that situation ? thanks. ed > Dennis, > > You've got that right. Damned PeopleSoft! We were hoping we might be able > to leverage ORM to control PeopleSorft query users. No such luck since everyone > is PeopleSoft. Now on the other hand, if you've got the LUXURY of having people > logged in with their own usernames you certainly can throttle down those you > want, almost to a crawl. > dick goulet > Dick - My understanding is that Oracle Resource Manager controls resources > based on userid. In other words, if a third-party application or an > application server uses the same Oracle userid for access, then Oracle > Resource Manager wouldn't help much. Is that what you've seen? > Dennis Williams > DBA > Lifetouch, Inc. > > Ed, > > The only way your going to do this is through Oracle Resource Manager. > You'll need an 8.1.x Enterprise database. Then you can setup your resource > plans and groups to manage who gets how much CPU at a time. Any of the > operating level tools out there cannot get down to the level of granularity > your > asking for since all of the activity happens within Oracle. All those tools > can > do is control the amount of CPU that Oracle gets which has a global effect > that > hampers all users of the database. > > Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed Lewis INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).