s******r
发帖数: 1524 | 1 Anyone has the experience with Toad for Oracle?
I used to do lots of "select * from ****". It sounds everytime toad give me
back first 500 and will read more if I scrolled down. Since there is an
obvious delay, I thought toad only read first 500 records.
Today I got message from DBA. He told me my toad tried to download whole
table and used up the memory.
Anyone know the default setting of toad. whether it only read first 500
records or the whole table?
Thank a lot. |
B*****g
发帖数: 34098 | 2 What is the OCI Buffer Array Size option for in the View - Options - Oracle
- General section?
After a SELECT query is executed, we must retrieve the rows from the Oracle
server to your PC. We do not retrieve the rows all at once, nor do we
retrieve them one at a time (unless there is a LONG or LOB column involved).
We retrieve the rows in blocks. The number of rows retrieved in each block
is the number of rows you specify with "OCI Array Buffer Size". TOAD
defaults to 25 because SQL*Plus defaul
【在 s******r 的大作中提到】
: Anyone has the experience with Toad for Oracle?
: I used to do lots of "select * from ****". It sounds everytime toad give me
: back first 500 and will read more if I scrolled down. Since there is an
: obvious delay, I thought toad only read first 500 records.
: Today I got message from DBA. He told me my toad tried to download whole
: table and used up the memory.
: Anyone know the default setting of toad. whether it only read first 500
: records or the whole table?
: Thank a lot.
|
c*****d
发帖数: 6045 | 3 呵呵，Beijing对toad真是很熟悉，连这参数你都看过
惭愧
Oracle
Oracle
).
block
40
【在 B*****g 的大作中提到】
: What is the OCI Buffer Array Size option for in the View - Options - Oracle
: - General section?
: After a SELECT query is executed, we must retrieve the rows from the Oracle
: server to your PC. We do not retrieve the rows all at once, nor do we
: retrieve them one at a time (unless there is a LONG or LOB column involved).
: We retrieve the rows in blocks. The number of rows retrieved in each block
: is the number of rows you specify with "OCI Array Buffer Size". TOAD
: defaults to 25 because SQL*Plus defaul
|
B*****g
发帖数: 34098 | 4 ft, 10 seconds for google.
also find a trick I want to solve for a long time.
【在 c*****d 的大作中提到】
: 呵呵，Beijing对toad真是很熟悉，连这参数你都看过
: 惭愧
:
: Oracle
: Oracle
: ).
: block
: 40
|
s******r
发帖数: 1524 | 5 I set it as 500. That's the result I got from google. However still not very
clear how toad utilize memory on server.
Let's say there are 10,000 records in the table. While I keyed in "select *
from ***. How much memory toad requested on the server, 10,000 or only 500
records?
Oracle
Oracle
).
block
40
【在 B*****g 的大作中提到】
: What is the OCI Buffer Array Size option for in the View - Options - Oracle
: - General section?
: After a SELECT query is executed, we must retrieve the rows from the Oracle
: server to your PC. We do not retrieve the rows all at once, nor do we
: retrieve them one at a time (unless there is a LONG or LOB column involved).
: We retrieve the rows in blocks. The number of rows retrieved in each block
: is the number of rows you specify with "OCI Array Buffer Size". TOAD
: defaults to 25 because SQL*Plus defaul
|
c*******e
发帖数: 8624 | 6 try to add "top n" in your query
very
*
【在 s******r 的大作中提到】
: I set it as 500. That's the result I got from google. However still not very
: clear how toad utilize memory on server.
: Let's say there are 10,000 records in the table. While I keyed in "select *
: from ***. How much memory toad requested on the server, 10,000 or only 500
: records?
:
: Oracle
: Oracle
: ).
: block
|
s******r
发帖数: 1524 | 7 thanks,
"top n" does not work. where rownum
【在 c*******e 的大作中提到】
: try to add "top n" in your query
:
: very
: *
|
B*****g
发帖数: 34098 | 8 他只会mysql，哈哈
【在 s******r 的大作中提到】
: thanks,
: "top n" does not work. where rownum
|
c*******e
发帖数: 8624 | 9 哈哈,我不会mysql
【在 B*****g 的大作中提到】
: 他只会mysql，哈哈
|
k********e
发帖数: 702 | 10 哈哈， top n是 MS SQL
mysql 是 OFFSET m LIMIT n |
B*****g
发帖数: 34098 | 11 haha, I just play with bu guai
【在 k********e 的大作中提到】
: 哈哈， top n是 MS SQL
: mysql 是 OFFSET m LIMIT n
|
c**t
发帖数: 2744 | 12 mysql use limit
【在 c*******e 的大作中提到】
: 哈哈,我不会mysql
|
