Re: Multiple datasets in one dataset

On Oct 19, 1:08 am, roman.moroku...@xxxxxxxxxxxxxx wrote:
Hi Joel,

Please let us know which exact version and platform you are using.

Oracle 10g on Windows

There are some outer join bugs, but not generally on anything this
simple AFAIK.

Well, I understand.

Are you seeing your cpu pegged?

No. I did not look on the server yet. The client gets in a time out
after a while. So it looks like Oracle never returns.

Do you know how to check for wait states with Oracle?

No. Please tell me.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/instance_tune.htm#PFGRF02410

There are also some 3rd party books. Cary Milsap has a good one.

It's also worthwhile to trace to find out exactly what is going wrong
with a particular SQL. Plenty online about that, including this
groups archives. http://www.psoug.org/reference/trace_analyzer.html


Anything else going wrong, errors in the alert log?

Did not look at it yet. Will have to soon.


Oracle 10g 10.0.2.1.0 on Windows 2003 64 bit
No patch so far installed.

You probably want to look into dealing with that.

Just for grins, maybe you should check and see if you get a different
answer using the ANSI syntax for joins.

Example (from metalink Note:137286.1):

This query returns rows from the departments table even if no
employees are
assigned to it.

SELECT employee_id, department_name
FROM departments d
LEFT OUTER JOIN employees e
ON (e.department_id= d.department_id);

This is equivalent to the following pre-Oracle9i outer join notation:

SELECT employee_id, department_name
FROM departments d, employees e
WHERE e.department_id(+) = d.department_id;

jg
--
@home.com is bogus.
"I'd like to see a 'Bagpipe Heroes'" -
http://www.signonsandiego.com/uniontrib/20071019/news_1b19hot.html

.

Relevant Pages

  • Re: Looking for oracle/sql tutorials and advice
    ... I'm teaching myself oracle and I am looking for some easy to follow ... step by step tutorials on oracle and sql. ... employees, and also for departments. ... I'm not sure this has much to do with foreign keys. ...
    (comp.databases.oracle.misc)
  • Looking for oracle/sql tutorials and advice
    ... I'm teaching myself oracle and I am looking for some easy to follow ... step by step tutorials on oracle and sql. ... Working with foreign keys. ... employees, and also for departments. ...
    (comp.databases.oracle.misc)
  • Re: New Topic - OLAP Server Performance etc (moved on from "Re: Hyperion Vs EPB and OFA")
    ... (then on his Rockport sabbatical from Oracle) ... I guess it's no longer possible for employees of ... which shows that Michael used to know that Applix had submitted TM1 to ...
    (comp.databases.olap)
  • Re: Difference in Left Join, Right Join
    ... RIGHT syntax exist. ... If you write SQL such that what you feel is the driving table is at ... The above is Oracle outer join syntax, ...
    (comp.databases.oracle.misc)
  • Re: oracle query questions
    ... I am looking for query questions of oracle 8i which i ... How many employees in scott.emp were hired in February? ... Puget Sound Oracle Users Group ...
    (comp.databases.oracle.server)