Oracle DB growing - CR 9 1

[CalgaryCR9]

On our oracle server we have a file that is growing at a huge rate.

/u02/oradata/GENN/temp01.dbf is now over 10gb, when it was 2 gb back in June.

The oracle dba is our corporate office is putting the blame on Crystal reports. I can't see how my reports would consume 8gb of space on the oracle server when I do not save data with report.

Question: Does crystal reports 9 increase the size of the oracle database? I don't believe it does as crystal reports simply queries the database.

I am not an oracle dba or oracle proficeint to even know where to start looking for verification.

 

[synapsevampire]

I can't think of how, Crystal doesn't write to the database unless you're specifically doing an EXPORT to a database, and it cannot write to existing tables that way. Or if you have stored procedures that are writing to tables. The only other instances where this might happen is writes to the log files, or to temp/cache files, which shouldn't be the database.

Saving data with the report would simply increase the size of the report file, not the database.

Ask them to qualify specifically what is growing in the database, if they say that they don't know, then they are saying that they're incompetent and guessing.

-k

 

[Turkbear]

Hi,
Ask your DBA if
/u02/oradata/GENN/temp01.dbf
Is a data file for a TEMPORARY tablespace...
If so, it will grow ( up to the MAX set by your DBA) with any usage of the Oracle database and never shrink..It reuses space even when it appears to be full...

Are you using that database as your CMS?
As your Auditing database?





To Paraphrase:"The Help you get is proportional to the Help you give.."