RE: Open cursors and 8i

--openmail-part-09bbc234-00000001

Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT"
Content-Disposition: inline; filename="BDY.TXT"
Content-Transfer-Encoding: 7bit

> Doesn anyone know if open cursors are handled better
> in 8i compare to 7.3.3.
>
> One of our developer is running out of open_cursors
> in 7.3.3 but he doesn't have any problem with 8i
> database. Both database are set to same open cursors
> limit.

Ashish,

8i has a new 'CURSOR_SHARING' parameter that can force statements with similar statements to share cursors. This could be specifically set at session or instance level (dynamically as well) which could be the reason for this 'problem'!

John Kanagaraj
Brunei Shell Petroleum
http://www.geocities.com/john_sharmila

Moving out of Brunei soon! My 'permanent' address is 'john_sharmila_at_yahoo.com'!!

• Opinions expressed here are solely mine and not necessarily those of my employer **

--openmail-part-09bbc234-00000001

Content-Type: application/ms-tnef; name="WINMAIL.DAT"
Content-Disposition: attachment; filename="WINMAIL.DAT"
Content-Transfer-Encoding: base64

eJ8+Ipl5AQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5N aWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEgAEAGAAAAFJFOiBPcGVuIGN1 cnNvcnMgYW5kIDhpAMgHAQWAAwAOAAAA0AcIABIABwA0ACUABQBWAQEAgAAAoAAAAAQAoABC AE4ASm9obiBKLiBLYW5hZ2FyYWogL0ZJQzMyMSxPUEVOTUFJTC9vPUJSVU5FSSBTSEVMTCBQ RVRST0xFVU0gU0VSSUEAT1BFTk1BSUw6Sm9obiBKLiBLYW5hZ2FyYWogL0ZJQzMyMSxPUEVO TUFJTC9vPUJSVU5FSVwgU0hFTExcIFBFVFJPTEVVTVwgU0VSSUEAAAAAAAAAAAAnKgEggAMA DgAAANAHCAASAAcAMQA3AAUAZQEBCYABACEAAAAwOEU2REI2RTk1NzRENDExOTM4QjAwNjA5 Nzk5MTFCMwD8BgEEkAYAKAYAAAMAAAAQAAAAAwAAMAQAAAALAA8OAAAAAAIB/w8BAAAAVQAA AAAAAACNVUzQ7DwRzoH/CAAJsQN6AQAAAAsAAAAAAAAAMR1PUkFDTEUtTB41HW1pbWUeMTYd SFBNRVhUMR4xNx1PUkFDTEUtTEBmYXRjaXR5LmNvbQAAAAAeAAIwAQAAAAkAAABPUEVOTUFJ TAAAAAAeAAMwAQAAACYAAABPUkFDTEUtTCAvbWltZSAoT1JBQ0xFLUxAZmF0Y2l0eS5jb20p AAAAAwAVDAEAAAADAP4PBgAAAB4AATABAAAAJgAAAE9SQUNMRS1MIC9taW1lIChPUkFDTEUt TEBmYXRjaXR5LmNvbSkAAAACAQswAQAAAC8AAABPUEVOTUFJTDpPUkFDTEUtTCAvbWltZSAo T1JBQ0xFLUxAZmF0Y2l0eS5jb20pAAADAAA5AAAAAAsAQDoBAAAAHgD2XwEAAAAmAAAAT1JB Q0xFLUwgL21pbWUgKE9SQUNMRS1MQGZhdGNpdHkuY29tKQAAAAIB918BAAAAVQAAAAAAAACN VUzQ7DwRzoH/CAAJsQN6AQAAAAsAAAAAAAAAMR1PUkFDTEUtTB41HW1pbWUeMTYdSFBNRVhU MR4xNx1PUkFDTEUtTEBmYXRjaXR5LmNvbQAAAAADAP1fAQAAAAMA/18AAAAAAgH2DwEAAAAE AAAAAAAABBAAAAADAAAwBQAAAAsADw4AAAAAAgH/DwEAAABaAAAAAAAAAI1VTNDsPBHOgf8I AAmxA3oBAAAACwAAAAAAAAAxHW9yYWNsZWRiYR41HW1pbWUeMTYdSFBNRVhUMR4xNx1vcmFj bGVkYmFAcXVpY2tkb2MuY28udWsAAAAeAAIwAQAAAAkAAABPUEVOTUFJTAAAAAAeAAMwAQAA ACsAAABvcmFjbGVkYmEgL21pbWUgKG9yYWNsZWRiYUBxdWlja2RvYy5jby51aykAAAMAFQwB AAAAAwD+DwYAAAAeAAEwAQAAACsAAABvcmFjbGVkYmEgL21pbWUgKG9yYWNsZWRiYUBxdWlj a2RvYy5jby51aykAAAIBCzABAAAANAAAAE9QRU5NQUlMOm9yYWNsZWRiYSAvbWltZSAob3Jh Y2xlZGJhQHF1aWNrZG9jLmNvLnVrKQADAAA5AAAAAAsAQDoBAAAAHgD2XwEAAAArAAAAb3Jh Y2xlZGJhIC9taW1lIChvcmFjbGVkYmFAcXVpY2tkb2MuY28udWspAAACAfdfAQAAAFoAAAAA AAAAjVVM0Ow8Ec6B/wgACbEDegEAAAALAAAAAAAAADEdb3JhY2xlZGJhHjUdbWltZR4xNh1I UE1FWFQxHjE3HW9yYWNsZWRiYUBxdWlja2RvYy5jby51awAAAAMA/V8BAAAAAwD/XwAAAAAC AfYPAQAAAAQAAAAAAAAFEAAAAAMAADAGAAAACwAPDgAAAAACAf8PAQAAAFEAAAAAAAAAjVVM 0Ow8Ec6B/wgACbEDegEAAAALAAAAAAAAADEdYXIuc2hhaB41HW1pbWUeMTYdSFBNRVhUMR4x Nx1hcl9zaGFoQHlhaG9vLmNvbQAAAAAeAAIwAQAAAAkAAABPUEVOTUFJTAAAAAAeAAMwAQAA ACIAAABhci5zaGFoIC9taW1lIChhcl9zaGFoQHlhaG9vLmNvbSkAAAADABUMAgAAAAMA/g8G AAAAHgABMAEAAAAiAAAAYXIuc2hhaCAvbWltZSAoYXJfc2hhaEB5YWhvby5jb20pAAAAAgEL MAEAAAArAAAAT1BFTk1BSUw6YXIuc2hhaCAvbWltZSAoYXJfc2hhaEB5YWhvby5jb20pAAAD AAA5AAAAAAsAQDoBAAAAHgD2XwEAAAAiAAAAYXIuc2hhaCAvbWltZSAoYXJfc2hhaEB5YWhv by5jb20pAAAAAgH3XwEAAABRAAAAAAAAAI1VTNDsPBHOgf8IAAmxA3oBAAAACwAAAAAAAAAx HWFyLnNoYWgeNR1taW1lHjE2HUhQTUVYVDEeMTcdYXJfc2hhaEB5YWhvby5jb20AAAAAAwD9 XwEAAAADAP9fAAAAAAIB9g8BAAAABAAAAAAAAAZgVwEDkAYARAQAACYAAAALAAIAAQAAAAsA IwAAAAAAAwAmAAAAAAALACkAAAAAAAsAKwAAAAAAAwAuAAAAAAACATEAAQAAAAEAAAAAAAAA AwA2AAAAAABAADkAwBOcOKYIwAEeAEIAAQAAAEIAAABKb2huIEouIEthbmFnYXJhaiAvRklD MzIxLE9QRU5NQUlML289QlJVTkVJIFNIRUxMIFBFVFJPTEVVTSBTRVJJQQAAAEAASAAAXKQ5 pgjAAR4AcAABAAAAFAAAAE9wZW4gY3Vyc29ycyBhbmQgOGkAAgFxAAEAAAAWAAAAAcAIpjiL btvmCXSVEdSTiwBgl5kRswAAHgAaDAEAAABCAAAASm9obiBKLiBLYW5hZ2FyYWogL0ZJQzMy MSxPUEVOTUFJTC9vPUJSVU5FSSBTSEVMTCBQRVRST0xFVU0gU0VSSUEAAAACAR0MAQAAAE4A AABPUEVOTUFJTDpKT0hOIEouIEtBTkFHQVJBSiAvRklDMzIxLE9QRU5NQUlML089QlJVTkVJ XCBTSEVMTFwgUEVUUk9MRVVNXCBTRVJJQQAAAB4AHgwBAAAACQAAAE9QRU5NQUlMAAAAAB4A HwwBAAAARQAAAEpvaG4gSi4gS2FuYWdhcmFqIC9GSUMzMjEsT1BFTk1BSUwvbz1CUlVORUlc IFNIRUxMXCBQRVRST0xFVU1cIFNFUklBAAAAAB4AQhABAAAAAQAAAAAAAAADAIAQ/////0AA BzAQsR7YpQjAAUAACDAQsR7YpQjAAQMA3j+vbwAACwAAgAggBgAAAAAAwAAAAAAAAEYAAAAA A4UAAAAAAAADAAKACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMACIAIIAYAAAAAAMAA AAAAAABGAAAAAAGFAAAAAAAAAwAWgAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAADACeA CCAGAAAAAADAAAAAAAAARgAAAABShQAA4xUAAB4AKIAIIAYAAAAAAMAAAAAAAABGAAAAAFSF AAABAAAABAAAADguNQALACmACCAGAAAAAADAAAAAAAAARgAAAAAGhQAAAAAAAAsALYAIIAYA AAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwAvgAggBgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAA AAAeAD2ACCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAAAAEAAAAAAAAAHgA+gAggBgAAAAAA wAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAB4AP4AIIAYAAAAAAMAAAAAAAABGAAAAADiF AAABAAAAAQAAAAAAAAALAEqACyAGAAAAAADAAAAAAAAARgAAAAAAiAAAAAAAAAsATIALIAYA AAAAAMAAAAAAAABGAAAAAAWIAAAAAAAAHgA9AAEAAAAFAAAAUkU6IAAAAAADAA00/TcAAIKj Received on Thu Aug 17 2000 - 18:52:38 CDT