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.
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.