Session PGA increase
- From: Domagoj Smoljanovic <dsmoljanovic@xxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 19 Jan 2010 18:06:55 +0100
Hi all,
I have a procedure that loads data from file using external tables.
It bulk collects data from external table into a collection, does a
little transformations on the data and inserts into a database table.
At the end of procedure collections are deleted. This procedure is ran
from another plsql proc that runs it for each file that has arrived on
the server.
But what I have noticed is constant increase in session PGA usage
while the procedure is running. It starts small (cca 20 Mb) but after
about 5000 files "session pga usage" grows to about 1 gig. The size of
loaded data per file shouldn't be more than 10Mb.
It seems as some memory is not released, but the procedure is so
simple i really don't know in what part???
Any ideas what might be the cause for this?
Thanx in advance
Domagoj
--
//www.freelists.org/webpage/oracle-l
Other related posts:
