Re: Runaway pl/sql in the db from orphaned oas connections causes complete memory saturation
From: Charles Schultz <sacrophyte_at_gmail.com>
Date: Fri, 7 Dec 2012 07:33:35 -0600
Message-ID: <CAPZQniW4vh=x_zGinfPLw=hGDGs5WO7e5SvQ77k6dsSKrp4gYA_at_mail.gmail.com>
I am willing to bet several folks can and do see lots of SRs. *wink* None the less, here is the simple "hello world" procedure:
END; So LoadRunner records a user opening up a web page, which in turn prompts the oas to call this procedure via a pool connection, the database then executes the procedure and returns the output to oas, which pops up a very simple message on the user's screen.
Date: Fri, 7 Dec 2012 07:33:35 -0600
Message-ID: <CAPZQniW4vh=x_zGinfPLw=hGDGs5WO7e5SvQ77k6dsSKrp4gYA_at_mail.gmail.com>
I am willing to bet several folks can and do see lots of SRs. *wink* None the less, here is the simple "hello world" procedure:
CREATE OR REPLACE PROCEDURE hello_world
IS
BEGIN
HTP.HTMLOPEN; -- generates <HTML>
HTP.HEADOPEN; -- generates <HEAD>
HTP.TITLE('Title'); -- generates <TITLE>Hello</TITLE>
HTP.HEADCLOSE; -- generates </HTML>
- generates <BODY TEXT="#000000" BGCOLOR="#FFFFFF"> HTP.BODYOPEN( cattributes => 'TEXT="#000000" BGCOLOR="#FFFFFF"');
- generates <H1>Heading in the HTML File</H1> HTP.HEADER(1, 'Heading in the HTML File');
HTP.PARA; -- generates <P>
HTP.PRINT('Hello World!!');
HTP.BODYCLOSE; -- generates </BODY>
HTP.HTMLCLOSE; -- generates </HTML>
END; So LoadRunner records a user opening up a web page, which in turn prompts the oas to call this procedure via a pool connection, the database then executes the procedure and returns the output to oas, which pops up a very simple message on the user's screen.
Hmmm.... If I put the link here, I could just ignore LoadRunner and let you all try it out...... *wicked grin*
NOTE: for the sake of disclosure, I am a mere DBA; we have a team of folks that handle OAS and I do not claim to understand it at all. Not much cross-training over here.
On Fri, Dec 7, 2012 at 12:34 AM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:
> I don't think anyone here will be able to see the SRs - but if you can
> share the Hello World test case...
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>
-- Charles Schultz -- http://www.freelists.org/webpage/oracle-lReceived on Fri Dec 07 2012 - 14:33:35 CET