Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL Nested Tables and Memory
PL/SQL Nested Tables and Memory [message #187651] Mon, 14 August 2006 16:05 Go to next message
Messages: 505
Registered: March 2005
Senior Member
Let's say I have the following:
    TYPE tab_type IS TABLE OF VARCHAR2(32000);
    v_tab tab_type := tab_type();
    FOR i IN 1..1000 LOOP
        v_tab(v_tab.COUNT) := '0123456789';

Did I just tie up 32M or 10K of memory?
Re: PL/SQL Nested Tables and Memory [message #187661 is a reply to message #187651] Mon, 14 August 2006 17:15 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Take a look at 'session pga memory' before and after this block is run to see the exact number. Hint: It will be closer to your second number than the first.
Previous Topic: Oracle
Next Topic: Getting error 'ORA-01756: quoted string not properly terminated'
Goto Forum:

Current Time: Mon Oct 24 11:02:07 CDT 2016

Total time taken to generate the page: 0.23481 seconds