473,326 Members | 2,680 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Re: Use of Parallel Query Servers

If you are firing that many queries you better be using bind variables and
parsing the query once and rebinding, and executing many times and NOT
closing the cursor. Doing that will help you immensely lower CPU usage.
You are sending the queries sychronsly and the type of queries you are
sending are not suited for doing parallel queries on (" single row from the
a table and uses the primary key in its WHERE predicate"). Parallel queries
are more suited for full table scan or large sorts. Using parallel query in
your case will make each query take longer.

The reason you see a cpu get busy is because you are sending the queries one
after another and not at the same time. I think you would dramatically
speed things up by using bind variables etc. as I have stated before.(odds
are over 90% that you are not using bind variables given your high CPU
usage)
Jim

"Shekar Kamath" <sh***********@mphasis.comwrote in message
news:77**************************@posting.google.c om...
Hi,

We are attempting to switch on the parallel query servers option in
Oracle,So far we have not succeeded in doing.Was just wondering
whether its helpful in our case. Following is the configuration of
the machine on which the Oracle server is installed.

Dual CPU Intel Xeon P4 1.8 GHz,
1 GB RAM, SCSI HDD.

Our application is firing multiple queries one after the other in
sequence, each of the individual queries is not complicated and is
required to retrieve a single row from the a table and uses the
primary key in its WHERE predicate. Total number of such queries being
fired is close to 46000 in a sigle sequential operation.

What we notice is that the server is only making use of a single CPU,
the other CPU is essentially idle. The CPU getting used reaches close
to 90% utilisation and the other CPU remians idle during this entire
duration.

We tried switching on the parallel query option by setting the
parallel_automatic_tuning parameter in init.ora to true. However even
this is not helping. The server is still utilizing only a single CPU.
The outputs from v$pq_slave, v$pq_tqstat returns zero rows.

Any clues on what we may be doing wrong?

-Shekar

Jun 27 '08 #1
0 1418

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Yuancai \(Charlie\) Ye | last post by:
Hi, All: I am happy to annouce that we have formally released our latest SocketPro version 4 at www.udaparts.com, an advanced remoting framework written from batching/queue, asynchrony and...
2
by: Neil Ginsberg | last post by:
I have a SQL 7 db with a union query (view), and I'm getting the error, "The query processor could not start the necessary thread resources for parallel query execution." This union query has been...
6
by: Alexandre MELARD | last post by:
HI, I have a tricky problem about parallel processing using JavaScript. a script makes use of classes. 2 objects A and B are created at intialisation. The two objects make use of the same...
11
by: karan | last post by:
I would like to know how one can use the parallel port through c/c++.Also, how does one determine what port is installed(EPP/ECP/SSP/PS2)? What is the differnece between these? What are the...
12
by: Peter Eisentraut | last post by:
Is there any practical limit on the number of parallel connections that a PostgreSQL server can service? We're in the process of setting up a system that will require up to 10000 connections open...
4
by: Mark D Powell | last post by:
SQL Server 2000 SP3A Last week one of our processes starting issuing or suffering deadlock detected errors every 15 minutes or so. I have read several articles at MS on the subject. I set a...
4
by: sesling | last post by:
I currently use an SQL command line that utilizes parallel threads. ex. select /*+ PARALLEL (ACCOUNT 20) */ Account_ID, Customer_Name, Add_Date from Customer_Info. By running this query using...
43
by: parallelpython | last post by:
Has anybody tried to run parallel python applications? It appears that if your application is computation-bound using 'thread' or 'threading' modules will not get you any speedup. That is because...
0
by: Daniel Roy | last post by:
In addition to setting this parameter to TRUE, you'll need to either specify the PARALLEL clause for the table(s) involved, or use the relevant hints ("PARALLEL"). Note also that parallelization is...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.