Re: Session Killed...!!
- From: Bryan Wells <bunjibry@xxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 15 Sep 2005 09:11:51 -0600
i have seen this type of behavior before, especially in TOAD sessions. On
TOAD, it usually will show a session as 'killed' until the app is closed on
the client site.
On 9/15/05, Yongping Yao <yaoyongping@xxxxxxxxx> wrote:
>
>
> SSBhZ3JlZSB0aGF0IGl0J3MgdmVyeSBzdHJhbmdlIHRvIGtpbGwgYSBzZXNzaW9uIGluIE9yYWNs
>
> ZS4gQXMgSQpleHBlcmllbmNlZCwgU0VMRUNUcyBhcmUgbW9yZSBlYXNpZXIgdG8ga2lsbCB0aGFu
>
> IERNTHMgYW5kIFNFTEVDVHMKcnVubmluZyBhZnRlciBhIGxvbmcgdGltZSBhcmUgbW9yZSBkaWZm
>
> aWN1bHQgdG8ga2lsbC4gVVBEQVRFIGlzIHRoZQptb3N0IGRpZmZpY3VsdCB0byBraWxsLiBPcmFj
>
> bGUgYWx3YXlzIHJlcG9uZHMgYXMgIndlIGhhdmUgbWFya2VkIHRoZQpzZXNzaW9uIGtpbGxlZCIg
>
> YnV0IHRoZSBzZXNzaW9uIGlzIHN0aWxsIHRoZXJlIGFuZCB0aGUgbG9jayByZW1haW5lZApob2xk
>
> LiBBbnlvbmUgd2l0aCBnb29kIHJlY29tbWVuZGF0aW9ucz8KCjIwMDUvOS8xNSwgQ2hlbiwgU2Fy
>
> YWggPFNhcmFoX0NoZW5AYnVkY28uY29tPjoKPiAgCj4gSSBhbHdheXMgY2hlY2sgcHJvY2VzcyBp
>
> ZCBhcyB3ZWxsIGFzIHNpZCBhbmQgc2VyaWFsIyB3aGlsZSBraWxsaW5nIGEgc2Vzc2lvbgo+IGZy
>
> b20gT3JhY2xlLiAKPiAgIAo+IEkgd2lsbCBhbHdheXMgcXVlcnkgdiRzZXNzaW9uIGJlZm9yZSBh
>
> bmQgYWZ0ZXIsIGFuZCBpZiB0aGUgc3RhdHVzIG9mCj4gdiRzZXNzaW9uIG1hcmtlZCAia2lsbGVk
>
> IiwgYW5kIHRoZW4gSSB3aWxsIGdvIGFoZWFkIGtpbGwgT1MgcHJvY2VzcyB0byBjbGVhbgo+IHRo
>
> aXMgc2Vzc2lvbi4gSXQgYWx3YXlzIHdvcmtzIG9uIFNvbGFyaXMuIAo+ICAgCj4gU2FyYWgKPiAg
>
> Cj4gIAo+IC0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tCj4gRnJvbTogb3JhY2xlLWwtYm91bmNl
>
> QGZyZWVsaXN0cy5vcmcgW21haWx0bzpvcmFjbGUtbC1ib3VuY2VAZnJlZWxpc3RzLm9yZ11Pbgo+
>
> IEJlaGFsZiBPZiBNZXJjYWRhbnRlLCBUaG9tYXMgRiAoTEFCT1IpCj4gU2VudDogVGh1cnNkYXks
>
> IFNlcHRlbWJlciAxNSwgMjAwNSAxMDo0NyBBTQo+IFRvOiBjaGlyYWdkYmFAZ21haWwuY29tOyBP
>
> cmFjbGUtTCBGcmVlbGlzdHMKPiBTdWJqZWN0OiBSRTogU2Vzc2lvbiBLaWxsZWQuLi4hIQo+IAo+
>
> ICAKPiAgCj4gCj4gSWYgeW91IGtpbGwgdGhlIHVuaXggcHJvY2VzcyBhc3NvY2lhdGVkIHdpdGgg
>
> dGhpcyBzZXNzaW9uIGZpcnN0LCBhbmQgdGhlbgo+IHRoZSBzZXNzaW9uIGl0IHdpbGwgZ28gYXdh
>
> eS4gCj4gCj4gICAKPiAKPiBLaWxsaW5nIHNlc3Npb25zIGluIE9yYWNsZSBoYXMgYWx3YXlzIGJl
>
> ZW4gd2VpcmQuICBTb21ldGltZXMgdGhleSBnbyBhd2F5Cj4gYW5kIHNvbWV0aW1lcyBub3QsIGRl
>
> cGVuZGluZyBvbiBPUy4gIEluIFdpbmRvd3MsIHVzZSBvcmFraWxsIHRvIGtpbGwgdGhlCj4gc2Vz
>
> c2lvbiCoQyB0aGlzIGFsd2F5cyBzZWVtcyB0byB3b3JrIGluIHdpbmRvd3MuICBBbmQga2lsbGlu
>
> ZyB0aGUgdW5peAo+IHNlc3Npb24gdGhlbiB0aGUgT3JhY2xlIHNlc3Npb24gc2VlbXMgdG8gd29y
>
> ayBqdXN0IGZpbmUgaW4gQUlYLiAKPiAKPiAgIAo+ICAKPiAgX19fX19fX19fX19fX19fX19fX19f
>
> X19fX19fX19fX18KPiAgCj4gCj4gRnJvbTogb3JhY2xlLWwtYm91bmNlQGZyZWVsaXN0cy5vcmcg
>
> W21haWx0bzpvcmFjbGUtbC1ib3VuY2VAZnJlZWxpc3RzLm9yZ10KPiBPbiBCZWhhbGYgT2YgQ2hp
>
> cmFnIERCQQo+IFNlbnQ6IFRodXJzZGF5LCBTZXB0ZW1iZXIgMTUsIDIwMDUgMTA6MzYgQU0KPiBU
>
> bzogYXNrZGJhQGZyZWVsaXN0cy5vcmc7IE9yYWNsZS1MIEZyZWVsaXN0cwo+IFN1YmplY3Q6IFNl
>
> c3Npb24gS2lsbGVkLi4uISEgCj4gCj4gICAKPiAgCj4gCj4gSGkgLCAKPiAgCj4gCj4gICAKPiAg
>
> Cj4gCj4gSSBzYXcgbWFueSB1c2VycyBvbiBteSBkYXRhYmFzZSBjb25uZWN0ZWQgZm9yIG1vcmUg
>
> dGhhbiA2IGRheXMgd2l0aG91dCBhbnkKPiBhY3Rpdml0eS4gCj4gIAo+IAo+ICAgCj4gIAo+IAo+
>
> IEkga2lsbGVkIDEgdXNlciBhbmQgc3RpbGwgdGhlIHN0YXR1cyBpbiB2JHNlc3Npb24gaXMgc2hv
>
> d2luZyBhcyBraWxsZWQuIAo+ICAKPiAKPiAgIAo+ICAKPiAKPiBidXQgaXQgaXQgbm90IGdldHRp
>
> bmcgcmVtb3ZlZCBmcm9tIHRoZSB2JHNlc3Npb24uIAo+ICAKPiAKPiAgIAo+ICAKPiAKPiBJIGFt
>
> IHJ1bm5pbmcgOS4wLjEuMyBvbiBzb2xhcmlzLiAKPiAgCj4gCj4gICAKPiAgCj4gCj4gYW55IGlk
>
> ZWE/IFdlIGFscmVhZHkgaGl0IHRoZSBidWcgb3JhLTA3NDQyLiAKPiAgCj4gCj4gICAKPiAgCj4g
>
> Cj4gcmVnYXJkcyAtIGNoaXJhZyAKCgotLSAKWWFvIFlvbmdwaW5nCkxlYXJuaW5nIE9yYWNsZSwg
>
> VU5JWC9MaW51eC4uLgpMb3ZlIFJlYWRpbmcsIENsYXNzaWNhbCBNdXNpYywgUGhpbG9zb3BoeSwg
>
> RWNvbm9taWNzIGV0Yy4KQmxvZzogaHR0cDovL2Jsb2cuY3Nkbi5uZXQvZXJuCiAgICAgICAgIGh0
> dHA6Ly9zcGFjZXMubXNuLmNvbS9tZW1iZXJzL3lhb3lwLwo=
> --
> //www.freelists.org/webpage/oracle-l
>
--
Bryan Wells
bunjibry@xxxxxxxxx
Oracle DBA hopeful
Other related posts:
