Re: IIS connects to Oracle : only ONE session active at any time
From: Jason Brown [MSFT] (i-brjaso_at_online.microsoft.com)
Date: 10/21/04
- Next message: Hongkia: "Re: Application popup: dllhost.exe - Application Error"
- Previous message: Ken Schaefer: "Re: accessing share from isapi"
- In reply to: Martin Molema: "Re: IIS connects to Oracle : only ONE session active at any time"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 21 Oct 2004 16:26:16 +1000
That's just the connection string - which should be fine - but it does sound
like Oracle or IIS is queuing requests rather than multi-threading them.
I'll do a bit of research and see if I can come up with anything.
--
Jason Brown
Microsoft GTSC, IIS
This posting is provided "AS IS" with no warranties, and confers no
rights.
"Martin Molema" <google@molema.org> wrote in message
news:b8b3ba4c.0410202214.2bb440af@posting.google.com...
> Jason,
>
> Thanks for your effort to help. The application programmers think the
> ADO connection is defined on application scope. They gave me a file
> called GLOBAL.ASA. Here's the content (username/pwd replaced by ***)
>
> Looking forward to you next question :)
>
> Greetings martin
>
> FILE:GLOBAL.ASA
> <SCRIPT LANGUAGE='VBScript' RUNAT='Server'>
>
>
> 'Sub Session_OnStart
> '**Put your code here **
> 'End Sub
>
>
> </SCRIPT>
> <SCRIPT LANGUAGE=VBScript RUNAT=Server>
> Sub Application_OnStart
> '==Visual InterDev Generated - startspan==
> '--Project Data Connection
> Application("Connection1_ConnectionString") = "DSN=ESWIMMS;User
> Id=SWM_OWNER;PASSWORD=*******;UID=******;DBQ=ESWIMMS;DBA=W;APA=T;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;FRL=T;MTS=F;CSR=F;PFC=10;TLO=0;"
> Application("Connection1_ConnectionTimeout") = 15
> Application("Connection1_CommandTimeout") = 30
> Application("Command1_CommandTimeout") = 180
> Application("Connection1_CursorLocation") = 3
> Application("Connection1_RuntimeUserName") = "SWM_USER"
> Application("Connection1_RuntimePassword") = "SWM"
> '-- Project Data Environment
> 'Set DE = Server.CreateObject("DERuntime.DERuntime")
> 'Application("DE") = DE.Load(Server.MapPath("Global.ASA"),
> "_private/DataEnvironment/DataEnvironment.asa")
> '==Visual InterDev Generated - endspan==
> End Sub
> </SCRIPT>
>
>
> "Jason Brown [MSFT]" <i-brjaso@online.microsoft.com> wrote in message
> news:<O#qGHkmtEHA.3188@TK2MSFTNGP15.phx.gbl>...
>> OK, question #1 : is the ADO connection object placed into Session or
>> Application scope, by any chance?
>>
>>
>> --
>> Jason Brown
>> Microsoft GTSC, IIS
>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>>
>> "Martin Molema" <google@molema.org> wrote in message
>> news:b8b3ba4c.0410192149.589ffd60@posting.google.com...
>> > Hello everyone,
>> >
>> > We have an IIS-server using ASP and connecting to an Oracle 7.3.4
>> > database. I do not have too many tech-details on everything because
>> > I'm only an end-user type of person. Recently we keep having
>> > performance problems: it takes very long to access certain web-pages
>> > that require quite some Oracle-data. Some indication: with one person
>> > logged on a page takes 30 seconds to build up. With 4 persons it takes
>> > 4 minutes: after 4 minutes the first one gets the complete page.
>> > Within the next 30 seconds the other 3 users also get the data.
>> > Imagine 40 or 80 users: Page cannot be displayed.........
>> >
>> > A short while ago we did some tests with only 4 users. Normally there
>> > are about 30 to 80 persons active. With only 4 users we saw in Oracle
>> > (using monitoring tools) that there were NO concurrent sessions
>> > active, although we pressed a certain button to open the form almost
>> > at exactly the same moment.
>> >
>> > What happens is that a certain session is active for a while. Then all
>> > sessions are inactive for a short time; following is a different
>> > session being active. Etc etc etc.
>> >
>> > Having noticed this, we later watched the database-activity when about
>> > 30 persons were using the web-application. Then the same behaviour was
>> > noticed.
>> >
>> > The problem is that neither the persons who administer the database
>> > nor the persons who manage the IIS have a clue why this is happening.
>> > The programmers 'blame' the IIS, the IIS blames Oracle etc etc. But
>> > still no solution.
>> >
>> > Somebody came up with a change in the session-parameters (MTS=....)
>> > but that changed nothing.
>> >
>> > Any help whould be greatly appreciated because we have serious
>> > problems.
>> >
>> > Greetings Martin
>> > google-nospam@nospam.molema.org
>> > (please remove nospam-parts for mail)
- Next message: Hongkia: "Re: Application popup: dllhost.exe - Application Error"
- Previous message: Ken Schaefer: "Re: accessing share from isapi"
- In reply to: Martin Molema: "Re: IIS connects to Oracle : only ONE session active at any time"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
