e******r
发帖数: 220 | 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******r
发帖数: 220 | 2 toad complains that it is out of menory.
any |
w*r
发帖数: 2421 | 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******r
发帖数: 220 | 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*****d
发帖数: 6045 | 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******r
发帖数: 220 | 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*r
发帖数: 2421 | 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*****g
发帖数: 34098 | 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*******t
发帖数: 891 | 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.
|
