FAQ
I have a large associative array (index-by pl/sql table), that is indexed
by varchar2. A procedure that uses this array deletes and adds array
elements over and over again. Will this cause memory fragmentation which
can cause performance issues? Is there a way for me to see this
fragmentation?
Here is a short example of what I'm talking about. Imagine this type of
thing done with hundreds or thousands of array elements:

DECLARE
TYPE t_tbl IS TABLE OF VARCHAR(1) INDEX BY VARCHAR2(1);
l_tbl t_tbl;
BEGIN
l_tbl('a') := 1;
l_tbl('b') := 2;
l_tbl('c') := 3;

l_tbl.delete('b');

l_tbl('e') := 4;

END;


Thanks,
Christoph
http://ruepprich.wordpress.com

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedApr 16, '12 at 3:24p
activeApr 16, '12 at 3:24p
posts1
users1
websiteoracle.com

1 user in discussion

Christoph: 1 post

People

Translate

site design / logo © 2022 Grokbase