Pro*C application take huge amount of memory. Why?

Hi all, I have been programming some cgi application in Pro*C for a website. I link the executable with the Oracle shared Library (Dynamicly linked). The executable are only 300K in size. Unfortunatly, in memory, the programs are running with 7Mb to 9Mb!!! Since the website is a high traffic website, the memory get's filled pretty quicly. I would like to know why in memory each processes is using about 8Mb and the filesize is only 300K. My programs are not allocating huge arrays so I do not know where all this memory usage come from.

in top:
21034 nobody 1 13 0 7152K 4424K sleep 0:00 0.17% test.cgi

file size:
-rwxrwxrwx 1 nobody nogroup 213076 Aug 19 20:22 test.cgi

Also, I noticed that I have a number of processes running as 'oracle' with 28Mb each. Sometimes, there's 15 of them running at the same time. I do not think it is normal.

from top:

21018 nobody     1 -11    0   18M   10M run     0:00  0.33% oracle
  469 oracle    18  33    0   27M   11M sleep  22:46  0.31% oracle
26055 daemon     1  33    0   26M   17M sleep   0:00  0.20% oracle

Did anyone had the same kind of problem as me and how did you fix it? I would appreciate that you CC your answer to me.

OS:
SunOS sun1 5.6 Generic_105181-03 sun4u sparc SUNW,Ultra-4

COMPILER:
CC: WorkShop Compilers 4.2 30 Oct 1996 C++ 4.2

DATABASE:
Oracle8 Enterprise Edition Release 8.0.4.0.0 - Production

Thank you.

--

Christian Roy
- CGI (HTML,Javascript,Perl,C,C++)

• Developer/Programmer

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 20 1998 - 12:18:00 CDT