Re:Resource management

From: <dgoulet_at_vicr.com>
Date: Fri, 18 Jan 2002 15:02:13 -0800
Message-ID: <F001.003F46C9.20020118141029@fatcity.com>

Bambi,

Boy you ARE rested!! Yes you can, their in the user profile & they work darn well if you set 'resource_limit=true' in the init.ora file. The only problem is that it does not re-submit the query, it just terminates the session. Saves my bacon more times than I care to add up.

DickG.

____________________Reply Separator____________________
Author: "Bellows; Bambi" <BBellows_at_usg.com>
Date:       1/18/2002 1:05 PM

Hi Guys!

Hope everyone had a good holiday. I'm back from 3 weeks off and feeling rested. Maybe a bit too rested.

I got a question on whether Oracle has a concept of resource management... that is, if user X consumes too much CPU time, or the query runs too long, whether there is some way to enter limits into Oracle which will kill the query and, based on rules, resubmit it for a different time. I thought the answer was yes because it sounded so dang familiar... now I'm not sure if it was Oracle or Ingres or Sybase or SQL Server, or whether it was something that could be set from Financials.

Your help, as always, is appreciated!
Bambi.

<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">

<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 10">
<meta name=Originator content="Microsoft Word 10">
<link rel=File-List href="cid:filelist.xml_at_01C1A031.A02C1610">
<!--[if gte mso 9]><xml>
<w:WordDocument>

  <w:SpellingState>Clean</w:SpellingState>
  <w:GrammarState>Clean</w:GrammarState>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
  <w:Compatibility>
   <w:BreakWrappedTables/>
   <w:SnapToGridInCell/>
   <w:WrapTextWithPunct/>

<w:UseAsianBreakRules/>
</w:Compatibility>

  <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
 </w:WordDocument>

</xml><![endif]-->
<style>
<!--

/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal

        {mso-style-parent:"";
        margin:0in;
        margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        font-size:12.0pt;
        font-family:"Times New Roman";
        mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline;
        text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline;
        text-underline:single;}
span.EmailStyle17
        {mso-style-type:personal-compose;
        mso-style-noshow:yes;
        mso-ansi-font-size:10.0pt;
        mso-bidi-font-size:10.0pt;
        font-family:Arial;
        mso-ascii-font-family:Arial;
        mso-hansi-font-family:Arial;
        mso-bidi-font-family:Arial;
        color:windowtext;}
span.SpellE
        {mso-style-name:"";
        mso-spl-e:yes;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.25in 1.0in 1.25in;
        mso-header-margin:.5in;
        mso-footer-margin:.5in;
        mso-paper-source:0;}
div.Section1
        {page:Section1;}

-->
</style>
<!--[if gte mso 10]>
<style>

/* Style Definitions */
table.MsoNormalTable

        {mso-style-name:"Table Normal";
        mso-tstyle-rowband-size:0;
        mso-tstyle-colband-size:0;
        mso-style-noshow:yes;
        mso-style-parent:"";
        mso-padding-alt:0in 5.4pt 0in 5.4pt;
        mso-para-margin:0in;
        mso-para-margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        font-size:10.0pt;
        font-family:"Times New Roman";}

</style>
<![endif]-->
</head>

<body lang=EN-US link=blue vlink=purple style='tab-interval:.5in'>

<div class=Section1>

Hi Guys!<o:p></o:p>

<o:p> </o:p>

Hope everyone had a good holiday.  I'm back from 3 weeks off and feeling rested.  Maybe a bit too rested.<o:p></o:p>

<o:p> </o:p>

I got a question on whether Oracle has a concept of resource management... that is, if user X consumes too much CPU time, or the query runs too long, whether there is some way to enter limits into Oracle which will kill the query and, based on rules, resubmit it for a different time.  I thought the answer was yes because it sounded so dang familiar... now I'm not sure if it was Oracle or Ingres or Sybase or SQL Server, or whether it was something that could be set from Financials. 
<o:p></o:p>

<o:p> </o:p>

Your help, as always, is appreciated!<o:p></o:p>

Bambi.<o:p></o:p>

</div>

</body>

</html>

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

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 Fri Jan 18 2002 - 17:02:13 CST