httpd keep the memory allocated even after the script ends

Hi. I am testing some ways to insert bin amounts of data in a oracle database and i encountered the following problem. During the script execution the memory usage of httpd daemon grows a lot and even after the script is ended the httpd process keeps the memory allocated. After two runs of the script the httpd process is using 28.7% of 512 MB of RAM. I'm using PHP 4.3.1, Oracle 9.2.1.0.1 and apache 1.3.27. Hope you can help. The oracle table in wich the data is inserted ha the following structure: SQL> describe adrian_test;

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 NAME                                               VARCHAR2(255)
 NR                                                 NUMBER
 VAL                                                NUMBER

the script is attached: <? OCIInternalDebug (1); function bulk_test($link,$nr_query){ // Create three types number, float, text $my_q="create or replace type mname as varray($nr_query) of varchar(255)"; $my_res=OCIParse($link,$my_q); OCIExecute($my_res); if(!OCIFreeStatement($my_res)){ echo "\n<p> Problems to free the statement mname<p>\n"; return 5; }; $my_q="create or replace type mnr as varray($nr_query) of number"; $my_res=OCIParse($link,$my_q); OCIExecute($my_res); OCIFreeStatement($my_res); $my_q="create or replace type mval as varray($nr_query) of number"; $my_res=OCIParse($link,$my_q); OCIExecute($my_res); OCIFreeStatement($my_res); //Create collections $cname=OCINewCollection($link,"MNAME"); $cnr=OCINewCollection($link,"MNR"); $cval=OCINewCollection($link,"MVAL"); //Create bulk data for($i=0;$i<$nr_query;$i++){ $cname->append("Nume".$i); $cval->append($i); $cnr->append($i+100); }; //Create the PLSQL query $mbstr="begin forall i in 1..".$nr_query." insert into adrian_test (name,nr,val) values (:vname(i),:vnr(i),:vval(i));end;"; $mbq=OCIParse($link,$mbstr); //Bind collections OCIBindByName($mbq,":vname",$cname,sizeof($cname),OCI_B_SQLT_NTY); OCIBindByName($mbq,":vnr",$cnr,sizeof($cnr),OCI_B_SQLT_NTY); OCIBindByName($mbq,":vval",$cval,sizeof($cval),OCI_B_SQLT_NTY); //Execute Query OCIExecute($mbq); OCIFreeStatement($mbq); echo "\n<p> Before free :".$cname->size()."<p>\n"; //Free Collections $cname->free(); $cnr->free(); $cval->free(); //Drop types $dtque=OCIParse($link,"drop type mname"); if(!OCIExecute($dtque)){ echo("Problems with dropping MNAME type <p>"); return 5; }; OCIFreeStatement($dtque); $dtque=OCIParse($link,"drop type mnr"); OCIExecute($dtque); OCIFreeStatement($dtque); $dtque=OCIParse($link,"drop type mval"); OCIExecute($dtque); OCIFreeStatement($dtque); }; function query_num($link){ $qres=OCIParse($link, "select count(*) from adrian_test"); $retv=OCIExecute($qres,OCI_COMMIT_ON_SUCCESS); OCIFetchInto($qres, $rdata, OCI_RETURN_NULLS); OCIFreeStatement($qres); return $rdata[0]; }; function trash_all($link){ $qres=OCIParse($link, "delete from adrian_test"); OCIExecute($qres,OCI_COMMIT_ON_SUCCESS); OCIFreeStatement($qres); }; $linkid = OCINLogon("user", "pass", "db"); if (!$linkid) { echo "Connection failed"; echo "Error Message: [" . OCIError($linkid) . "]"; exit; }; trash_all($linkid); for($cc=0;$cc<20;$cc++){ echo "\n\n\n<p>-----------------------------TEST $cc START-------------------------------------------------<p>\n"; bulk_test($linkid,100000); if(query_num($linkid)!=100000) echo "\n<p> ------------------------- Error in step $cc ----------------------------------<p>\n"; trash_all($linkid); flush(); OCICommit($linkid); echo "\n\n\n<p>-----------------------------TEST $cc END-------------------------------------------------<p>\n"; }; OciLogOff($linkid); ?>