Resource Quotta for CPU Usage

From: John Wood <jwood_at_hotmail.com>
Date: Tue, 21 Sep 2004 23:37:48 GMT
Message-ID: <gX24d.33631$t61.453@clgrps13>

I am planning to create CPU Resource Quota for an Oracle user mainly running reports. In our setup, all the report users will use the same user id to logon. I plan to allocate 30% of CPU time to that user.

Does that mean the total CPU time will be 30% even though there will be 3 or 4 sessions log on as the same user ? Do I need to allocate the CPU resouce to other users so that the total will be 100% ? Can I skip the setup for other users ? As I am only concern with the report user running lengthy queries at this point.

Thanks.

JW Received on Tue Sep 21 2004 - 18:37:48 CDT