RE: Tool recommendation
- From: Upendra N <nupendra@xxxxxxxxxxx>
- To: <freek.dhooge@xxxxxxxxx>, <mark.powell2@xxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 17 Aug 2010 15:40:11 -0400
Thanks for everyone who responded.
I'll enable sqlnet.expire_time, that should handle the dead connections.
I checked out SQL Developer, it is a nice query tool but not intuitive enough
for some one who doesn't know SQL.
Right now in MS Access the business users drag/drop columns to build a query,
anything similar in nature would be easier for me to sell.
Am I just being paranoid or Access is capable of handling large queries (upto
~200K records)?
-Upendra
> From: Freek.DHooge@xxxxxxxxx
> To: mark.powell2@xxxxxx; oracle-l@xxxxxxxxxxxxx
> Date: Tue, 17 Aug 2010 16:40:48 +0200
> Subject: RE: Tool recommendation
>
> Hi,
>
> Another solution (depending if the session is really dead) could be to enable
> dcd (dead client detection, sqlnet.expire_time) in de sqlnet.ora file on de
> server.
>
> http://download.oracle.com/docs/cd/B19306_01/network.102/b14213/sqlnet.htm#sthref475
>
>
>
> regards,
>
> Freek D'Hooge
> Uptime
> Oracle Database Administrator
> email: freek.dhooge@xxxxxxxxx
> tel +32(0)3 451 23 82
> http://www.uptime.be
> disclaimer: www.uptime.be/disclaimer
> --
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
> Behalf Of Powell, Mark
> Sent: dinsdag 17 augustus 2010 16:09
> To: oracle-l@xxxxxxxxxxxxx
> Subject: RE: Tool recommendation
>
> Why not write a dead session detection script that looks for and clears these
> sessions out and schedule it to run every X minutes?
>
> Or maybe create an on-demand script that is launched via a web application or
> by the operators.
> --
> //www.freelists.org/webpage/oracle-l
>
>
Other related posts: