Loading Tables in memory
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Loading Tables in memory

  1. #1
    Join Date
    Nov 2000
    Location
    London
    Posts
    94

    Question

    Any ideas how to load static data tables into memory.
    I'm under the impression that dbms_shared_pool.keep is for packages and procedures only?

  2. #2
    Join Date
    Jun 2000
    Location
    Chennai/India
    Posts
    90
    pls use the keep option while creating the table.
    Rgds
    Ganesh .R
    A Winner never Quits, A Quitter never Wins
    Ganesh .R

  3. #3
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    alter table table_name cache;

  4. #4
    Join Date
    Sep 2000
    Posts
    384
    Before pinning any table in buffer do a analyze table .see that the number of free blocks.See to it that they are as much as low as possible.if the free blocks are more use the alter table move command and recreate the table till you get the desired levels .

    then do pinning of the objects (tables)in memory.Inthis manner your will use the resourese in a proper manner.
    Radhakrishnan.M

  5. #5
    Join Date
    Nov 2000
    Location
    London
    Posts
    94

    Wink

    thanks for the input

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width