Re: Performance problem

From: Dmitriy Evinshteyn <Dmitriy.Evinshteyn_at_lgtna.com>
Date: 1997/10/07
Message-ID: <01bcd35f$2db45c80$b40174c6@dmitriye>#1/1

Did you analyze these tables? Let Oracle know how big is your table before it creates execution plan.

nmk_1970_at_hotmail.com wrote in article <875716596.16499_at_dejanews.com>...
> 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 Tue Oct 07 1997 - 00:00:00 CDT