how to keep objects permenantly?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: how to keep objects permenantly?

  1. #1
    Join Date
    Jan 2008
    Posts
    39

    how to keep objects permenantly?

    Hello,

    Can any one give me answers of following questions?

    how can oracle will decide which objects are larger and which are smaller?

    how can we keep objects permenantly in library cache with keep procedure after startup?


    --Thanks
    Prashant

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    1) by looking at the size of it?

    2) why do you think you need to

  3. #3
    Join Date
    Jan 2008
    Posts
    39
    Hello Davey,

    thanks for reply.

    can you explain me in deep? i want to know the internal procedure. how oracle will jusyify that particular object is large or small? what all are the things that come into picture while deciding the object sizes.

    For my second question i want some packages to be there permanantly in my system. so can you please guide me how to keep objects permanantly in library cache after startup?

    --Thanks
    Prashant

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    when you pin things you are stopping oracle do its job, so why do you want to pin it?

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