Re: profile

2002-06-04 Thread Mladen Gogala

DBMS_RESOURCE_MANAGER does just that. See tha manual (supplied PL/SQL 
packages reference)
and  Metablink.

On 2002.06.04 04:08 Otakar Mouèka wrote:
> Hello guru
> How can I set a  performance of CPU for 1 session  at 15 % in profile
> I hawe Oracle 8.1.7 . R 3 .
> Thanks Oto
> 
> 
> 
> 
> 
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Otakar =?iso-8859-2?q?Mou=E8ka?=
>   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).
> 

-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mladen Gogala
  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).



RE: profile

2002-06-04 Thread Ganesh Raja

Set Resource_Limit = TRUE in the Parameter File.

Then Create a Profile that uses Cpu_Per_Call and CPU_Per_Session values so
that CPU Usgae is restricted.

HTH

Best Regards,
Ganesh R
Tel  : +971 (4)  397 3337  Ext 420
Fax  : +971 (4)  397 6262
HP   : +971 (50) 745 6019

Live to learn... forget... and learn again. 




-Original Message-
Sent: Tuesday, June 04, 2002 12:08 PM
To: Multiple recipients of list ORACLE-L


Hello guru 
How can I set a  performance of CPU for 1 session  at 15 % in profile 
I hawe Oracle 8.1.7 . R 3 .
Thanks Oto 






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Otakar =?iso-8859-2?q?Mou=E8ka?=
  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: Ganesh Raja
  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).