Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

On PL/SQL Varray implementation

2900726Oct 22 2018 — edited Oct 24 2018

Hello,

I need some details on varray collection internal implementation.

It seems that when I declare a variable of varray type some memory sufficient to  N elements storage is marked as busy. But physically an allocation is performed when extend method is called.

Beacause of absenсe of C-like sizeof function I can't check this hypothesis by myself, and also I can't find any information on it in Oracle documentation.

Is there any information/documentation/knowledge authoritative about the proccess?

Thank u.

This post has been answered by Billy Verreynne on Oct 23 2018
Jump to Answer
Comments
Post Details
Added on Oct 22 2018
14 comments
1,156 views