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

Thread: re:Storage for Stored Procedures

  1. #1
    Join Date
    Nov 2001
    Visalia, California


    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
    Mesa, Arizona
    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
    NJ, USA
    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

    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