Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Performance problem

Performance problem

From: <nmk_1970_at_hotmail.com>
Date: 1997/10/02
Message-ID: <875716596.16499@dejanews.com>#1/1

Hi netters,

   I have a table which consists of 24 M Rows with the data size of    8 GB which is spread across 8*1 GB each. I have a need to join    these table with a small table of 112 rows . The small table has    to be joined twice with the big table to achieve the task. when I do    this it is really sucks. Also I have to do group by with 10    columns on this query. I have temp segment size of 1.2 GB .    Currently I am running oracle 7.3.2.3 on sun solaris 2.5.    Even after 12 hours I am not able to get the output.

   Any suggestions are welcome.

   Thanks in advance.

/muralikrishna

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Thu Oct 02 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US