Re: How to optimize server for cartesian join?

On Jan 31, 1:02 am, "Jack" <n...@xxxxxxxxxxxxxxx> wrote:
We have business need to do some countings.

It is using  MERGE JOIN [CARTESIAN], it will go fast with 10.000 count, but
with 200.000 end sum it will take very long time.
It is using Reports 6i (a bit old;)

It does utilize very complez views etc, and plan is long as you would
assume.
I am not going to send plan.

One solution would be redesing it, but not quite sure it would help.

Server is 9.2.0.8 (multi prosessor, quite good one), parameters are now very
small, and
not optimized.

Is there some good parameters in server side which could help?

Who could know? No one here, not with the details you presented (or,
more appropriately, failed to present). If you're not going to post
the explain plan and the init.ora parameters you do have set then
you're really on your own.

Oracle Corp. has stopped distributing crystal balls to DBAs.


David Fitzjarrell
.

Relevant Pages

  • How to optimize server for cartesian join? RESULSTS
    ... It is using MERGE JOIN [CARTESIAN], it will go fast with 10.000 count, ... with 200.000 end sum it will take very long time. ... I am not going to send plan. ... Server is 9.2.0.8, parameters are now ...
    (comp.databases.oracle.server)
  • How to optimize server for cartesian join?
    ... It is using MERGE JOIN [CARTESIAN], it will go fast with 10.000 count, but ... with 200.000 end sum it will take very long time. ... I am not going to send plan. ... Server is 9.2.0.8, parameters are now very ...
    (comp.databases.oracle.server)
  • Re: Working with task durations of minutes
    ... Just tell me I'm responsible for updating the server, everything will be "go" for me to do it starting Tuesday afternoon, and then get out of my way and let me do my job. ... From a project managment perspective it's usually enough for the PM to say "Update Server with Module Package X, 5 hours duration, starting Tuesday 1pm" and leave it up to Joe how he organizaes the details. ... If I'm painting a room and the painter and his assistant will box up the computers in it, move the furniture out, remove fixtures from the wall, mix and apply the paint I'll just list it as one task "Paint the Room." ... On the plan there are about 250 tasks that need ...
    (microsoft.public.project)
  • Re: Backing up SBS 2003 for Disaster Recovery
    ... You will also need a backup with some disaster recover plan on how to use ... Modern backup software gives you specific DR capabilities. ... backup job that backs up the whole server, and then it will provide a CD ... you should test your plan. ...
    (microsoft.public.windows.server.general)
  • Re: [9fans] 9vx and local file systems
    ... For about seven years I had the luxury of running Plan 9 ... I have a second Plan 9 server with a bigger, ... I've used drawterm to connect to it, edit and compile venti, ... doesn't require a cpu server. ...
    (comp.os.plan9)