Re: Tool recommendation
- From: Cary Millsap <cary.millsap@xxxxxxxxxxxx>
- To: nupendra@xxxxxxxxxxx
- Date: Tue, 17 Aug 2010 14:54:11 -0500
All these thoughts of people who don't know SQL writing SQL, returning
results sets with six-figure cardinalities, ...quite arousing.
Sounds like the opening chapter of an interesting story. :-)
Giddy-up!
Cary Millsap
Method R Corporation
http://method-r.com
http://carymillsap.blogspot.com
On Tue, Aug 17, 2010 at 2:40 PM, Upendra N <nupendra@xxxxxxxxxxx> wrote:
> 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:
