Procedure to create excel report
I have been trying to resolve an issue with generating an excel report and eventually save it into a BLOB column in a table. Environment:
Oracle 10.2.0.4 database
Sun Solaris 5.9
4 CPU of 1.2GHz each
Memory size: 8192 Megabytes
The CPU and memory usage goes up to 100% every time i run this report.
This report is based on a query that returns a total of 18,000 records. The code extensively uses DBMS_LOB package in generating the excel file. I am also using DBMS_LOB.CREATETEMPORARY to store excel report in a temporary BLOB variable before writing it to OS directory. My initial attempt to directly write into BLOB column has resulted in taking up almost 1.5GB of space in tablespace for a 10MB excel file. I am going to utilize BFILE concept to resolve the space issue. But i am still not able to resolve the issue of 100% CPU usage while excel file is
Oracle 10.2.0.4 database
Sun Solaris 5.9
4 CPU of 1.2GHz each
Memory size: 8192 Megabytes
The CPU and memory usage goes up to 100% every time i run this report.
This report is based on a query that returns a total of 18,000 records. The code extensively uses DBMS_LOB package in generating the excel file. I am also using DBMS_LOB.CREATETEMPORARY to store excel report in a temporary BLOB variable before writing it to OS directory. My initial attempt to directly write into BLOB column has resulted in taking up almost 1.5GB of space in tablespace for a 10MB excel file. I am going to utilize BFILE concept to resolve the space issue. But i am still not able to resolve the issue of 100% CPU usage while excel file is
0