#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    4
    Rep Power
    0

    Lightbulb Associative Arrays...How are they managed?


    Hi I have a question about how the associative arrays(table data structure in pl/sql) are managed by oracle. Does Oracle keep the data in memory and start paging it to disk once they reach a certain size or does it keep certain amount in memory and use some temporary table to which it insert and retrieve data as and when needed.
    This is important to me as I feel that I may end up putting a lot of data in the associative arrays and I know for certain that paging is really slow.

    Thanks for your insight..

    Regards,
    Sumit
    Last edited by sumit192; January 20th, 2004 at 07:01 PM.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    Have you created a test case and run stats while doing so? This is an opinionated question as we are not privy to your os, configuration, oracle version, memory, application, etc.
    El éxito consiste en una serie de pequeñas victorias día a día

    MySQL, MS SQL, MS ACCESS, Oracle Database Manager - http://victorpendleton.net/products/psdviewer.html

IMN logo majestic logo threadwatch logo seochat tools logo