Memory leak
Hi,
memory leak is been observed in the load report and my DBA points its all application code drives the memory leak and he has nothing to dig on memeory leak on DB side so he is pushing onus to development.
In my code i have a bulk fetch for every minute 100 records will be fetched but its a unique scan. C++ application calls this procedure
the load ran for 21 hours below is the sheet which tells the memory utilization for every hour on two nodes ( node 1& node 2)
my point is if the application behavoiur causes the memory leak then the leak should be consistently same on both the nodes.
but node 1 and node 2 behaviours are not same the leak is varying on both the nodes so is this still a code behaviour ?
our DBA is technically limited always pushing issues to Development team saying application causing these issues. Log file sync issue came he pushed to development team
stating application issue.
please look below the chart which tells the memory utilization behaviour. so what to be done on memory leak my bulk fetch is requirment if 100 records every minute is a trouble
then is it a limitation on oracle side or anything on DBA still to tune on his DB please explain
S.No Memory Utilization
Node 1 Node 2
1 HOUR 6773.00 7284.75
2 HOUR 6981.00 7418.25
3 HOUR 6847.00 7213.00
4 HOUR 6942.25 7255.50
5 HOUR 7017.50 7273.00
6 HOUR 7081.75 6986.00
7 HOUR 7119.50 6913.75
8 HOUR 7158.50 6941.50
9 HOUR 7182.75 6961.25
10 HOUR 7204.00 6982.00
11 HOUR 7224.50 6990.25
12 HOUR 7241.75 6996.50
13 HOUR 7255.50 7004.50
14 HOUR 7272.75 7010.50
15 HOUR 7282.50 7017.50
16 HOUR 7255.50 7019.25
17 HOUR 7265.00 7023.50
18 HOUR 7265.75 7025.75
19 HOUR 7270.25 7027.00
20 HOUR 7276.50 7031.75
Thanks in advance
Naveen
Edited by: Naveenkumar on Feb 18, 2013 4:39 PM