Redian新闻
>
请教。Toad for oracle setting. first 500 or whole table!
avatar
请教。Toad for oracle setting. first 500 or whole table!# Database - 数据库
s*r
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.
avatar
B*g
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.

avatar
c*d
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

avatar
B*g
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

avatar
s*r
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

avatar
c*e
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

avatar
s*r
7
thanks,
"top n" does not work. where rownum
【在 c*******e 的大作中提到】
: try to add "top n" in your query
:
: very
: *

avatar
B*g
8
他只会mysql,哈哈

【在 s******r 的大作中提到】
: thanks,
: "top n" does not work. where rownum
avatar
c*e
9
哈哈,我不会mysql

【在 B*****g 的大作中提到】
: 他只会mysql,哈哈
avatar
k*e
10
哈哈, top n是 MS SQL
mysql 是 OFFSET m LIMIT n
avatar
B*g
11
haha, I just play with bu guai

【在 k********e 的大作中提到】
: 哈哈, top n是 MS SQL
: mysql 是 OFFSET m LIMIT n

avatar
c*t
12
mysql use limit

【在 c*******e 的大作中提到】
: 哈哈,我不会mysql
相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。