why did this sql statement always fail in oracle? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

why did this sql statement always fail in oracle?

why did this sql statement always fail in oracle?# Database - 数据库

e*r2008-11-15 08:11

1 楼

I tried to find duplicate records from a table of 30,000,000 records:
select count(*), link, id from table group by link, id having count(*) > 1;
It always died. any suggestions ?
thanks

e*r2008-11-15 08:11

2 楼

toad complains that it is out of menory.

any

w*r2008-11-15 08:11

3 楼

Table maybe created with parallel level too high and it ran out of PGA .
try add parallel hint in the query to make it sequential.

【在 e******r 的大作中提到】

: toad complains that it is out of menory.
:
: any

e*r2008-11-15 08:11

4 楼

I have already alter the table from parallel to nonparallel, but
it is still too slow to progress 30 million records

【在 w*r 的大作中提到】

: Table maybe created with parallel level too high and it ran out of PGA .
: try add parallel hint in the query to make it sequential.

c*d2008-11-15 08:11

5 楼

30 million records take some time

【在 e******r 的大作中提到】

: I have already alter the table from parallel to nonparallel, but
: it is still too slow to progress 30 million records

e*r2008-11-15 08:11

6 楼

The current problem is not that it takes time, but my PC crashed once
it was lauched a while.

【在 c*****d 的大作中提到】

: 30 million records take some time

w*r2008-11-15 08:11

7 楼

ur pc?????
not the process on oracle???
are u pulling records from oracle?
what tool?

once

【在 e******r 的大作中提到】

: The current problem is not that it takes time, but my PC crashed once
: it was lauched a while.

B*g2008-11-15 08:11

8 楼

If toad version is lower than 9, upgrade now.
发信人: eecareer (没睡醒, 明天接着睡), 信区: Database
标题: Re: why did this sql statement always fail in oracle?
发信站: BBS 未名空间站 (Sun Nov 16 13:59:01 2008)
toad complains that it is out of menory.

【在 w*r 的大作中提到】

: ur pc?????
: not the process on oracle???
: are u pulling records from oracle?
: what tool?
:
: once

a*t2008-11-15 08:11

9 楼

query against 30M records without knowing how much data it is returning?
1st of all, I don't think it's a good idea to query against 30M records
2nd, if it is returning millions rows of of results all at once, no PC or
server can handle that.

【在 e******r 的大作中提到】

: The current problem is not that it takes time, but my PC crashed once
: it was lauched a while.