: RE: A performance problem
The other database in on a different server.
I looked at the statspack report for the other database, for the time period in
question.
Top 5 Timed Events
~~% Total
Event
) [EMAIL PROTECTED]
Date: 2003/12/29 Mon PM 01:14:34 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: A performance problem
John,
I can run this in our development environment and trace the job. But, the data is
quite a bit larger in production. I can't really take
: Multiple recipients of list ORACLE-L
Asunto: Re: Oracle 9.2.0.2 performance problem
Just curious: why are you using PGA_AGGREGATE_TARGET? Are there any limits
on memory capacity that you are in danger of exceeding? You have two CPUs
with 4Gb of RAM; I imagine that you're not in any danger
To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
hkchital@singn cc:
et.com.sgSubject: Re: Oracle 9.2.0.2
performance problem
Sent by:
[EMAIL PROTECTED]
m
).
Hemant K
Chitale To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
hkchital@singn cc:
et.com.sgSubject: Re: Oracle
9.2.0.2
performance problem
PROTECTED]
hkchital@singn cc:
et.com.sgSubject: Re: Oracle 9.2.0.2
performance problem
Sent by:
[EMAIL PROTECTED]
m
22/01/2003
00:49
Wonder if it is the SORT (for the GroupBy) taking time ?
What is the SORT_AREA_SIZE and what are the INITIAL and NEXT
extents of the user's temporary tablespace ?
Are the tablespaces Locally-Managed and the temporary tablespace
a TEMPORARY TABLESPACE with a TEMPFILE ?
Hemant
At 01:59 AM
:
et.com.sgSubject: Re: Oracle 9.2.0.2 performance
problem
Sent
Juan Miranda,
It seems quite strange,there is little wait event in the statspack
report, and you execution path should be the same on both platform, right? And is the
data volumn the same in both platform?And does the time spent on fetch the result from
server to your client
: Multiple recipients of list ORACLE-L
Asunto: Re: Oracle 9.2.0.2 performance problem
Juan Miranda,
It seems quite strange,there is little wait event in the statspack
report,
and you execution path should be the same on both platform, right? And is
the data volumn the same in both
: Monday, January 20, 2003 7:35 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle 9.2.0.2 performance problem
Hello
We execute the query in the servers, so there is no NET
problem (I think).
The data volume is exact (imported).
Execution path is the same, full-scan
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle 9.2.0.2 performance problem
Hello
We execute the query in the servers, so there is no NET
problem (I think).
The data volume is exact (imported).
Execution path is the same, full-scan.
This is a very strange problem and is very
Select personid from person
minus
select personid from phonenumber
Fazal
--- Dennis M. Heisler [EMAIL PROTECTED]
wrote:
select personid from person
where not exists (select '1' from phonenumber
where personid = person.personid);
Nils Höglund wrote:
Hello,
I have encountered a
select personid from person
where not exists (select '1' from phonenumber
where personid = person.personid);
Nils Höglund wrote:
Hello,
I have encountered a performance problem. I use Oracle8 Enterprise Edition
Release 8.0.5.0.0 - Production.
I have two tables. phonenumber and person,
C'mon, Larry, don't be shy :-)
Hello,
I have encountered a performance problem. I use
Oracle8 Enterprise Edition
Release 8.0.5.0.0 - Production.
I have two tables. phonenumber and person, each
person has none, one or
many phonenumbers referenced to him.
The phonenumber-table is
Move to EXISTS like this:
SELECT pn.personid
FROM phonenumber pn
WHERE NOT EXISTS (
SELECT NULL
FROM person p
WHERE p.personid=pn.personid);
--
hth
Alexandre
- Original Message -
Try EXISTS.
SELECT personid FROM person WHERE NOT EXISTS (
SELECT 0 FROM phonenumber WHERE person.personid=phonenumber.personid
);
You'll get all persons without any telephone number.
JP
On Tuesday 25 June 2002 15:08, Nils Höglund wrote:
Hello,
I have encountered a performance
Maybe you can get faster results with minus:
select distinct personid from persons
minus
select distinct personid from phones
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 25, 2002 3:08 PM
Hello,
I have
Title: RE: NOT IN performance problem
Nils, try this...(replaces NOT IN with an Outer Join)
select a.id from person a, phonenumber b
where a.id = b.id(+)
and b.id is null;
-Original Message-
From: Nils Höglund [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 25, 2002 9:08 AM
Hello,
I have encountered a performance problem. I use Oracle8 Enterprise Edition
Release 8.0.5.0.0 - Production.
I have two tables. phonenumber and person, each person has none, one or
many phonenumbers referenced to him.
I'm not sure what you want since your query doesn't
select personid from person_table
minus
select personid from phonenumber_table
/
Nils Höglund wrote:
Hello,
I have encountered a performance problem. I use Oracle8 Enterprise Edition
Release 8.0.5.0.0 - Production.
I have two tables. phonenumber and person, each person has none, one or
Finally! :)
Richard Huntley [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/25/2002 07:48 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: NOT IN performance problem
Nils, try this...(replaces
I'm not sure what you want since your query doesn't correspond to what
you are saying you want. Therefore no sample just a general statement,
use minus.
SELECT personid FROM phonenumber WHERE personid NOT IN (
SELECT personid FROM person);
I'm wondering how I could restructure or
On Friday 31 August 2001 13:40, Stephane Faroult wrote:
Procedure:
CREATE OR REPLACE PROCEDURE transform_prc IS
CURSOR cur_main
IS
SELECT distinct idserver,
to_char(dtreadingtime, 'DD-MON- HH24:MI') dttime
FROM tblcounter_reading a
WHERE
Title: RE: Stored Procedure Performance Problem --- Please Help
Where's your tkprof output? First step always is to trace.
-Original Message-
From: Viral Amin [SMTP:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 10:00 AM
To: Multiple recipients of list ORACLE-L
Subject: Stored
Without TKPROF output it is difficult to pinpoint exact statement which is
causing all the problems.
BUT wait .. you can optimize few things
* You mention you are on 817, make use of BULK BINDING for handling all the
inserts, this will help speedup the process.
* If you create a
Viral,
Have you tried to run this with tracing turned on? The trace file can show
you areas of concern.
Also, you may want to look into using DBMS_PROFILER package to find
performance bottlenecks in your PL/SQL procedures. Read more about it in the
Oracle8i Supplied PL/SQL Packages Reference
Title: Stored Procedure Performance Problem --- Please Help
Viral,
Are
you saying your entire database is on one 13GB drive? If so, it's no
wonder this operation takes a very long time - you're I/O bound in a big
way! The inserts and updates of tables and indexes, not to mention disk
sorts
Another important thing your insert statement should be rewritten to
use bind variables i.e. EXECYTE IMMEDIATE USING clause. This will
help reduce parsing as well.
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Viral,
There has been a few sensible advices but no global critic, so I think
that I can have a stab at it.
Viral Amin wrote:
Hi All,
Hardware : Dell server - 256MB RAM, 13GB Hard Disk, Single CPU
Software : Oracle 8.1.7 (Non-parallel server option)
OS : Windows NT 4.0 SP6
30 matches
Mail list logo
