Current Position:Home > Table in memory

Table in memory

Update:11-30Source: network consolidation
Advertisement
Hi all,
is there a possibility in 11g to load tables at database starttime from disk to memory and therefore all further "read"-access to this table will handled in memory?
best regards
georg

The Best Answer

Advertisement
It is possible to keep -especially small- tables in memory, by putting them into the keep pool.
The steps to take are:
- Determine size of the table
- Adjust size of the keep-pool so the table fits into it, using:
alter system set db_keep_cache_size=<size of table + 20%> scope=both;After tha 'pin' the table into the pool using:
ALTER TABLE <table> STORAGE ( BUFFER_POOL KEEP );
MAKE SURE that your SGA is large enough for the keep pool to be created. It is preffered to increase the SGA with the size the keep pool will become.
In that case no other memory buffers will be reduced in size
HTH
FJFranken
  • Export internal table to memory in User Exit FM Update:10-11

    Hi all, My scenario here is to export an internal table in one user exit FM and import it back in another user exit FM. I was trying to use Export lt_table to memory id 'LABEL'. then Import lt_table from memory id 'LABEL'. But then i hit error in the

  • Export a table to memory ID and import it in the Workflow. Update:10-11

    Hi, For a particular requirement, We are triggering Workflow from the User Exit MV45AFZZ. Before triggering this WF, I am trying to export an internal table to a memory ID and trying to Import it back from the same memory ID into an internal table in

  • Exporting an internal table to memory Update:10-11

    Hi   I want to call an program from another program and want the values stored in an internal table used in the called program. how can i export an internal table to memory id an then import it. Regards ArunSo to be clear, for your requirement it wou

  • Save Internal table to memory - problem Update:10-11

    Hi everybody , I need to extract one Internal table to memory , every 1st in the Month . Then every day I will be reading this table for my report ( in order to avoid running every day same and same database selections) . My originall idea wos with E

  • Pass Internal Table to Memory Update:10-11

    Dear Experts. I have the following problem. I am using a User-Exit for Travel  that is called from a program standard with use the T.Code TRIP. The program standard use a structure that when entry in the user exit not is. I need use this structure in

  • Export internal table to memory. Update:10-11

    How can I export and import an internal table to memory? This: export messtab to memory id 'TAB'. (in program 1) import messtab=messtab from memory id 'TAB'. (in program 2) does not work.Even without the brackets it doesn't work. In program 1 I have:

  • Passing Dynamic Internal Tables to Memory Update:10-11

    I have a bit of a conundrum right now that I can't seem to correct. I am working on adding an ALV report to an existing report program. I was able to write a simple helper program that builds a custom object that I defined that translates my raw data

  • Table in memory Update:11-30

    Hi all, is there a possibility in 11g to load tables at database starttime from disk to memory and therefore all further "read"-access to this table will handled in memory? best regards georgIt is possible to keep -especially small- tables in me

  • It cannot reference the dynamic internal table in memory as an object. Update:11-30

    Hi, I am getting the syntax error in the second select. I guest it cannot reference the dynamic internal table in memory as an object. The internal table contains different fields from multiple tables and it gets created OK. Then the first select wit

  • Tables in memory (Nested tables ?) Update:11-30

    For performance reasons, I would like to insert, update, etc... a table in memory. Can I use a nested table as if it was a normal table ? Can I do updates on nested tables with values from normal database tables ?? Statement like : Update <nested-tab