i***c
发帖数: 301 | |
M*****r
发帖数: 1536 | 2 I don't think you want to (or really can) turn off the log
1. put the database to simple recovery mode
2. http://support.microsoft.com/kb/272318
【在 i***c 的大作中提到】
: log变得太大了，如何关掉?
|
j*****n
发帖数: 1781 | 3 I guess you want to free the space of log file:
BACKUP LOG dbname WITH TRUNCATE_ONLY
go |
i***c
发帖数: 301 | 4 one more question,
I try to run 200,000 insert query into 4 table in one time
comeout error System.OutOfMemoryException
the server has 1.5G memory
can I config "min memory per query Option" to make the query run?
or how to fix?
【在 j*****n 的大作中提到】
: I guess you want to free the space of log file:
: BACKUP LOG dbname WITH TRUNCATE_ONLY
: go
|
B*****g
发帖数: 34098 | 5 Oracle可以停log。不过一般我们developer都没权利要求BDA这么做。咱们一般就是500
0一commit。
【在 i***c 的大作中提到】
: one more question,
: I try to run 200,000 insert query into 4 table in one time
: comeout error System.OutOfMemoryException
: the server has 1.5G memory
: can I config "min memory per query Option" to make the query run?
: or how to fix?
|
j*****n
发帖数: 1781 | 6 No.
Use the "min memory per query option" to specify the minimum amount of
memory (in kilobytes) that will be allocated for the execution of a query.
which means that you cannot limit the max amount of memory.
Solutions:
1. BCP with -b option to specify the number of rows per batch of data copied.
2. BULK INSERT...WITH(ROWS_PER_BATCH = #ofRowsPerBatch)
3. DTS/SSIS for your data load.
【在 i***c 的大作中提到】
: one more question,
: I try to run 200,000 insert query into 4 table in one time
: comeout error System.OutOfMemoryException
: the server has 1.5G memory
: can I config "min memory per query Option" to make the query run?
: or how to fix?
|
c*****d
发帖数: 6045 | 7 oracle也不能停log，只能产生minimum log
beijing概念错误
500
【在 B*****g 的大作中提到】
: Oracle可以停log。不过一般我们developer都没权利要求BDA这么做。咱们一般就是500
: 0一commit。
|
B*****g
发帖数: 34098 | 8 我想说停redo log。
【在 c*****d 的大作中提到】
: oracle也不能停log，只能产生minimum log
: beijing概念错误
:
: 500
|
w*******e
发帖数: 1622 | 9 ft....偶还一直想怎么停oracle的log呢
【在 B*****g 的大作中提到】
: 我想说停redo log。
|
