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.
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.
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;
Click Here to Expand Forum to Full Width