re:Storage for Stored Procedures
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: re:Storage for Stored Procedures

Hybrid View

  1. #1
    Join Date
    Nov 2001
    Location
    Visalia, California
    Posts
    20

    Question

    I'm not a DBA, but I was given the task to convert one system to another, and we decided to use stored procedures to do this. My question is does stored procedures,because being compiled take up a lot of disk space or not? Could you please help with this matter.

    Thanks any information would be very appreciated.

  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Stored proc's are kept in the SYSTEM tablespace. They're stored in a long column in plain text. You'll need space in the system tablespace for the sum of the char's of your code. But don't cut this too close.

    You can "pin" the procedures (compiled code) in memory or choose to have it stored in memory just prior to it's execution. It'll get dumped from memory based on an inventory algorithm that depends on your database version.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Procedures, functions, packages, ... store in system table :
    SYS.SOURCE$ line by line.
    U should get object# for requered objects from (for example all_objects) and
    then:

    select source from sys.source$ where obj# = xxx order by line;

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