Could PL/SQL Scripts be eating up disk space?
672252Jul 28 2009 — edited Jul 29 2009Hi all,
I'm new to the DBA/developer field.
I have started writing a few scripts to pull data from our database. A couple of the latest ones include ref cursors (2 for one program and 5 for another) that pull data from several tables. A couple of these tables have 100K+ records in them. I'm doing all the computations for the scripts in memory and then writing output to a text file. All the text (output) files are less than 1 MB.
However, we've been having some problems with space lately. We're running out of disk space on our Oracle drive. I don't know if I'm the problem or not. I don't think I am but would like to prove that for sure. I just don't know how to do that.
I've seen some information on http://asktom.oracle.com/tkyte/Misc/free.html for database free space report, but don't know if that will help me or not pinpoint the issue, rather than freeing up some space. I looked for ref cursors on the SQL & PL/SQL forum, but didn't see anything that told me about them related to disk space. I don't know if my computations are being written to disk and that's taking the memory or not.
Any ideas?
Vic