ramana1212 Posted January 6, 2016 Report Posted January 6, 2016 Ma prod environment Open cursors limit 400 undi...... Oka session 357 Open cursors chupistundi though it is INACTIVE open cursors are increasing Program: "JDBC Thin Client" Blocking_sesison_status = No Holder -------------------------------------- Simple solution is to increase the limit But last time 300 to 400 chessa same problem ... ------------------------------------------------------------------------------- Session Cursor leaks ela kanukovali...I was able to find the sessions and how many cursors they are running. Kaani is there a straight way to find the exact reason why the cursors are not closing by themselves. What do you do in your environments ??
Bondu_Babu Posted January 6, 2016 Report Posted January 6, 2016 Query plan okay naa ... Any changes ..?
ramana1212 Posted January 6, 2016 Author Report Posted January 6, 2016 I think they connections from Users to the application....Query's will not be static rite ? Query plan okay naa ... Any changes ..?
andhravodu Posted January 6, 2016 Report Posted January 6, 2016 Ma prod environment Open cursors limit 400 undi...... Oka session 357 Open cursors chupistundi though it is INACTIVE open cursors are increasing Program: "JDBC Thin Client" Blocking_sesison_status = No Holder -------------------------------------- Simple solution is to increase the limit But last time 300 to 400 chessa same problem ... ------------------------------------------------------------------------------- Session Cursor leaks ela kanukovali...I was able to find the sessions and how many cursors they are running. Kaani is there a straight way to find the exact reason why the cursors are not closing by themselves. What do you do in your environments ?? Don't overthink, cursors increase cheyatame. Generally 1500 daka vellochu rac node ayite, non rac ki 1000, no issues
andhravodu Posted January 6, 2016 Report Posted January 6, 2016 Inka why ani alochiste Mee app users increase ayyara eeadhya kalam lo? ala kadante meedi java or bi app aa?
ramana1212 Posted January 6, 2016 Author Report Posted January 6, 2016 Not a prob to inc to 1000 dude, It is sometimes with multiple sessions, with 400 open cursors. It will be a memory issue if more users connect...Workaround is ok but a solution will make us Happy kada. Don't overthink, cursors increase cheyatame. Generally 1500 daka vellochu rac node ayite, non rac ki 1000, no issues
andhravodu Posted January 6, 2016 Report Posted January 6, 2016 Not a prob to inc to 1000 dude, It is sometimes with multiple sessions, with 400 open cursors. It will be a memory issue if more users connect...Workaround is ok but a solution will make us Happy kada. User connections ki memory increase avakudadu man. Vallu app ise chestunnappudu memory issue vastundi ante mee devteam code revisit cheyali. Sharedpool vadakunda edo chestunnaru ani ardham appudu, all bind variables vadu, packages lo rayali code
Gajala frm Washington DC Posted January 7, 2016 Report Posted January 7, 2016 bayya performance tuning videos unte pm chestara evaru aina pls..or P.T ekkada nunchi start cheyali cheppandi, suggest some books from scratch
andhravodu Posted January 7, 2016 Report Posted January 7, 2016 bayya performance tuning videos unte pm chestara evaru aina pls..or P.T ekkada nunchi start cheyali cheppandi, suggest some books from scratch 11g, 12c performance tuning docs oracle vadu website lone untayi, excellent place to start For all things oracle, google tom kyte blog
Gajala frm Washington DC Posted January 7, 2016 Report Posted January 7, 2016 11g, 12c performance tuning docs oracle vadu website lone untayi, excellent place to start For all things oracle, google tom kyte blog Thank you...
KillChillPandey Posted January 7, 2016 Report Posted January 7, 2016 Thank you... Youtube lo chala videos unnai .. start working on your queries for tuning..
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts