RE: limit user CPU usage

From: <antonio.belloni_at_hstern.com.br>
Date: Wed, 16 Jan 2002 04:00:38 -0800
Message-ID: <F001.003F128D.20020116034018@fatcity.com>

If you are using 8i , you can setup Resource Manager. For more info about this subject see Oracle Administratorīs Guide.

HIH,
Antonio Belloni

                                                                                       
        
                    "Carle,                                                            
        
                    William T            To:     Multiple recipients of list ORACLE-L  
        
                    (Bill),              <ORACLE-L_at_fatcity.com>                        
        
                    ALINF"               cc:                                           
        
                    <wcarle_at_att.c        Subject:     RE: limit user CPU usage         
        
                    om>                                                                
        
                    Sent by:                                                           
        
                    root_at_fatcity.                                                      
        
                    com                                                                
        
                                                                                       
        
                                                                                       
        
                    15/01/02                                                           
        
                    16:30                                                              
        
                    Please                                                             
        
                    respond to                                                         
        
                    ORACLE-L                                                           
        
                                                                                       
        
                                                                                       
        

Hi,

    You can set up a profile to set resource limits and have the user use that profile. This is explained in the Oracle Administrator's Guide.

Bill Carle

AT&T

Database Administrator

816-995-3922

wcarle_at_att.com

-----Original Message-----

Sent: Tuesday, January 15, 2002 12:10 PM To: Multiple recipients of list ORACLE-L

Hi, Guys,

Is there some parameters or user-profile prometers in Oracle can limit user CPU usage?

I mean, make specific user or all users use less CPU, I has a SQL query that use 100% CPU.

I know the SQL is bad, but before developer change it, Is there something I can do?

Any suggestion will be highly appreciated.

My environment is Oracle8.1.6 on Win2000.

Thanks,

Kevin Wang

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: antonio.belloni_at_hstern.com.br

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: ListGuru_at_fatcity.com (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). Received on Wed Jan 16 2002 - 06:00:38 CST