-
Oracle People:
I've just imported a 22M attachment(as part of a table) by using an extremely large BUFFER in my import command:
imp file=cqdb.dmp.01.01.31 log=again buffer=30000000 fromuser=CQ06 tables=attachments_blob
Is there a limit to the size of the buffer ? Can you crash oracle this way ? If people keep putting in huge blobs will import just not be able to create a big enough buffer to import them ?
Thanks,
Roger
-
Oracle will not crash for giving max buffersize. AFAIK, size is Hardware Dependent. Unfortunately, I forgot the command which is real handy and gives me the max buffersize on the box. If some one knows it I would request 'em to post here.
For this box its 42131456
SunOS appserv7 5.6 Generic_105181-19 sun4u sparc SUNW,Ultra-4
-
Here is the command
On Solaris
devt2% sysdef|grep -i buf
drv/lebuffer
strmod/bufmod
10403840 maximum memory allowed in buffer cache (bufhwm)