import buffers and huge BLOBS

[rogerF]

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

[sreddy]

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

[sreddy]

On Solaris
<font face=courier>
devt2% sysdef|grep -i buf
drv/lebuffer
strmod/bufmod
10403840 maximum memory allowed in buffer cache (bufhwm)
</font>