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: 508
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: "ORA 3114 Not connected to oracle" error after an "ORA-00054: resource busy and acqui
Next Topic: pls
Goto Forum:

Current Time: Sat Aug 19 06:23:48 CDT 2017

Total time taken to generate the page: 0.10774 seconds