Storing a large record in a BDB queue

994490 Mar 3, 2013 1:32 PM

Hi,
I'm using a the BDB in the queue access method, to store some stuff. their size vary from 64B to 4Mb.
My problem is, that i didn't find a way of storing this large (4Mb) records in the queue, since the page size cannot exceed 64Kb, and for some reason the record (in queue) must be smaller then the page size.
Thanks in advance.

1. Re: Storing a large record in a BDB queue

userBDBDMS-Oracle Mar 19, 2013 10:30 AM (in response to 994490)

The queue access method is designed for storing fixed length records and the record size needs to be less than page size. If you want to store variable length records, then switch over to the BTREE access method.

thanks
mike
Like Show 0 Likes (0)

Actions