dragonemp
asked on
Is there memory leak in oracle?
there's several times oracle in one of my servers ate all the memory.
first I thought it's maybe my code cause the problem, but then i shut down everything, wrote a simple asp page with only open adodb.connection object connect to a oracle 8i database, run a simple select sql script, then close the connection, if i let the page run enough times, oracle.exe will eat all my memory.
the memory leak occure either with microsoft odbc driver for oracle or oracle obdc driver, so it's not driver problem.
first I thought it's maybe my code cause the problem, but then i shut down everything, wrote a simple asp page with only open adodb.connection object connect to a oracle 8i database, run a simple select sql script, then close the connection, if i let the page run enough times, oracle.exe will eat all my memory.
the memory leak occure either with microsoft odbc driver for oracle or oracle obdc driver, so it's not driver problem.
Hi dragonemp, What is your OS version ? What is the machine type ?
Oracle can not ate the whole memory.
The main component of oracle placed in the memory is the SGA.
You can see the size of the SGA so:
SQL> show sga;
Total System Global Area 386998364 bytes
Fixed Size 454748 bytes
Variable Size 360710144 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
SQL>
Look at this parameter. You can change the size if it is too high.
The main component of oracle placed in the memory is the SGA.
You can see the size of the SGA so:
SQL> show sga;
Total System Global Area 386998364 bytes
Fixed Size 454748 bytes
Variable Size 360710144 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
SQL>
Look at this parameter. You can change the size if it is too high.
ASKER
My OS is win2k server with sp4 on a pentium 4 2.4G.
Total System Global Area 185710620 bytes
Fixed Size 75804 bytes
Variable Size 66846720 bytes
Database Buffers 118710272 bytes
Redo Buffers 77824 bytes
and before I stop the service and restart again, oracle.exe took 300M RAM + 200M VM.......
Total System Global Area 185710620 bytes
Fixed Size 75804 bytes
Variable Size 66846720 bytes
Database Buffers 118710272 bytes
Redo Buffers 77824 bytes
and before I stop the service and restart again, oracle.exe took 300M RAM + 200M VM.......
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Look v$process view (as sys) or via Oracle Enterprise Manager. If there are to much processes, try to figure out why. You can limit the number of the processes using init<sid>.ora processes parameter.
ASKER
accepted Pontis's comment. thanks.