Oracle Apache Session

[Wilson]

I am currently running Oracle 8i with Apache setup in a 4-CPUs Windows
2000 Server. Users on their workstations connect to Oracle through
Internet Explorer which accesses Apache's DAD object and eventually
the PL/SQL packages in Oracle.

My application is mainly built by differenct PL/SQL packages in
Oracle. The packages build the html page based on the contents in the
database. In one part of my application, the users simply click a
search button and the application will return a list of records and
displays through Internet Explorer. The results are displayed in a
new Popup windows using basic html and jsp scripts.

The problem is that for each login through Apache to Oracle in
Internet Explorer, I can only trigger two of the four CPUs to work
when I click on the serach button. When I click the button for third
time, the new popup window is displayed but it waits until one of the
two previous windows finishes the SQL. Thus, I always cannot get all
CPUs to utilize at the same time.

I already checked CPU_COUNT in V$PARAMETER table, and the value is
four. If I run the query (the SQL statement behind the search button)
in sqlplus using four sessions at the same time, all four CPUs are
utilized.

Also, I checked the profiles of my user accounts and there is no limit
on CPU_PER_SESSION...etc.

If I open two Internet Explorers and login for two sessions, I can
open up to four windows to process the Search SQL at the same time (4
CPUs working at the same time).

Based on my find, Oracle is actually able to utilize all CPUs in the
system. However, when I work from the Internet Explorer and Apache, I
will get the utilizatoin limit problem. I wonder if there are any
parameters that limit my Oracle Apache session.

[sybrandb]

mo*******@yahoo.com (Wilson) wrote in message news:<bc**************************@posting.google. com>...

I am currently running Oracle 8i with Apache setup in a 4-CPUs Windows
2000 Server. Users on their workstations connect to Oracle through
Internet Explorer which accesses Apache's DAD object and eventually
the PL/SQL packages in Oracle.

My application is mainly built by differenct PL/SQL packages in
Oracle. The packages build the html page based on the contents in the
database. In one part of my application, the users simply click a
search button and the application will return a list of records and
displays through Internet Explorer. The results are displayed in a
new Popup windows using basic html and jsp scripts.

The problem is that for each login through Apache to Oracle in
Internet Explorer, I can only trigger two of the four CPUs to work
when I click on the serach button. When I click the button for third
time, the new popup window is displayed but it waits until one of the
two previous windows finishes the SQL. Thus, I always cannot get all
CPUs to utilize at the same time.

I already checked CPU_COUNT in V$PARAMETER table, and the value is
four. If I run the query (the SQL statement behind the search button)
in sqlplus using four sessions at the same time, all four CPUs are
utilized.

Also, I checked the profiles of my user accounts and there is no limit
on CPU_PER_SESSION...etc.

If I open two Internet Explorers and login for two sessions, I can
open up to four windows to process the Search SQL at the same time (4
CPUs working at the same time).

Based on my find, Oracle is actually able to utilize all CPUs in the
system. However, when I work from the Internet Explorer and Apache, I
will get the utilizatoin limit problem. I wonder if there are any
parameters that limit my Oracle Apache session.

That parameter would be a fundamental lack of understanding of how
Oracle works.
There is no guarantee at all each new session will get a different
CPU.
Most likely your queries are unscalable and hog Oracle, so that would
be the reason why you have to wait for a query to complete.
Check out whether your queries executes full table scans, my bet is
they all do.
Now try to learn Oracle and rebuild your application from scratch.

Sybrand Bakker
Senior Oracle DBA

[Wilson]

When you said my queries are unscalable and hog Oracle, what do you
mean? In fact, my query is a big one which involves some table scan.
Can you show me an example?

I appreciate for your help!

[Serial # 19781010]

Your problem is Internet Explorer, not Apache or Oracle. By default,
IE will only let you perform 2 concurrent HTTP downloads at a time.
You can increase this number by adding 2 new values to your registry
under the following key:
HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Internet
Settings

Then, you would create 2 new DWORD values:
MaxConnectionsPer1_0Server
MaxConnectionsPerServer

If you use 4 (Dword:00000004) as the value for each then all 4 Windows
will download at the same time.

If you are really tying up a CPU with each window, you might want to
tune the application. Otherwise how will you get more than 4
concurrent users?

[joe]

Nicely done Mr.Serial # 19781010. He actually knows how to resolve an issue
instead of snapping at people.
I guess Mr. Sybrand Bakker (aka Senior Oracle DBA) only know about Oracle
and nothing else. I hate to work for that guy. An Arrogant CS people like
him give us bad reputation for being to arrogant and unsociable.

Really Wilson, you need to optimize your query.

Joe
No nothing DBA