![]() Typically, this will be at least 32K bytes and much larger in many cases.īecause LOB columns are used for storing RAW payload, the Oracle Streams AQ administrator can choose the LOB tablespace and configure the LOB storage by constructing a LOB storage string in the storage_clause parameter during queue table creation time. In OCI, the maximum size of your RAW data will be limited to the maximum amount of contiguous memory (as an OCIRaw is simply an array of bytes) that the OCI Object Cache can allocate. Because the PL/SQL enqueue and dequeue interfaces accept RAW buffers as the payload parameters you will be limited to 32K bytes. For PL/SQL, Java and precompilers the limit is 32K for the OCI the limit is 4G. However, the maximum size of the payload is determined by which programmatic environment you use to access Oracle Streams AQ. The theoretical maximum size of the message payload is the maximum amount of data that can be stored in a LOB column. To store payload of type RAW, Oracle Streams AQ creates a queue table with a LOB column as the payload repository. Maximum number of attributes in the object type is limited to 900. Table 21-3 Type Name Attributes Attribute The type_name data structure defines queue types. Queue names and queue table names can be up to 24 bytes long. Schema names, agent names, and object type names can be up to 30 bytes long. The name must follow object name guidelines in Oracle Database SQL Language Reference with regard to reserved characters. If the schema name is not specified, the current schema is assumed. Names for objects are specified by an optional schema name and a name. ![]() It applies to queues, queue tables, agent names, and object types. The object_name data structure names database objects. Specifies the user-defined PL/SQL procedure, defined in the database to be invoked on message notification Table 21-2 DBMS_AQ Data Structures Data Structures
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |