Re: Free Java dba monitoring tool and Java source code

Hi,

in my opinion, Jared is only partly right. PL/SQL is a handy procedural language extension to plain SQL. Since SQL derives from the family of declarative languages (by the way, what happened to all the research in the late 80s/ early 90s about hooking up PROLOG engines to RDBMSs ? AFAIK, the major withdraw was execution speed of logical queries ...), but the three together (SQL,PL/SQL and Java) give you a great opportunity to use the OO paradigm within the Oracle engine (or at least you're getting closer to it ;). This might be valuable for developer databases, since they won't have to set up a complete 3-Tier infrastructure just in order to test drive their stuff (besides from within the IDE). I don't know about the usability for production databases (yet), since it might be too messy to monitor and tune stuff once you have both the database and the application running mixed altogether within the DB. I know that a lot of this is done with PL/SQL, but I personally think it's clearer to distinguish between the data and the application unless you run some administrative things. Just my 2 Cent ...

"Sam P. Roberts (ZADCO ITIS)" schrieb:
>
> Dear List
>
> To quote Jared recently 'And if you are wondering 'Should I learn Java?',
> the
> answer is 'definitely', as it is capable of many
> things that PL/SQL is not.'
>
> I have to totally agree with him and I think DBA's can enhance their profile
> by becoming competent in the technology.
>
> As part of my masters dissertation I have developed an SQL monitoring tool
> using Java/JDBC/thin drivers that allows the DBA to see who is taking up the
> resources currently in a database. The default is physical reads but any
> statistic can be selected. It displays like Instance manager but gives added
> functionality that it will extract the SQL that is running currently and
> allow you to Explain it online. You can sort the session data, kill
> sessions, etc.. It is a good tool especially if you suddenly get a dip in
> performance and need to quickly find which process is taking up all the
> resources. It is also good for ad-hoc monitoring.
>
> I know there are better/professional tools out there but not all companies
> can afford them,this is free and has been built in limited time. I work for
> an oil company and we have no monitoring tools, we had to rely on our own
> scripts. Most importantly I will give the source code to all that give me
> comments on the tool. This is not at all a commercial venture, purely
> academic. Plus if you want to learn about Java/JDBC this can be an
> invaluable asset/starting point as you know the subject well and you can see
> how the tool has been built.
>
> The tool is thin client - i.e. no oracle client installation necessary
> All you need to do is download Java 1.3 from Sun. If you e-mail me offline I
> will send you my website address where you can download (396kb-takes no
> time). There is also a link to the sun site for Java 2 download (this takes
> a little longer as its ABOUT 30MB).But it has all the latest swing classes
> and is the latest version.
>
> As an ex Cobol programmer in the 80's, Java is a wonderfully elegant
> language to learn and once studied is not as difficult as imagined (I
> imagined anyway).
>
> Sam
>
> -----Original Message-----
> Sent: Tuesday, March 27, 2001 12:21 AM
> To: Multiple recipients of list ORACLE-L
>
> Oracle has repeatedly stated that PL/SQL is not
> going away.
>
> One good reason for this is that PL/SQL is highly
> optimized for DML in the database. Java is not,
> and will not likely ever be as efficient PL/SQL
> for manipulating large amounts of data. At least
> IMO.
>
> OOP has many benefits, but large scale DML is not
> one of them, at least not yet.
>
> PL/SQL will be around for awhile yet.
>
> And if you are wondering 'Should I learn Java?', the
> answer is 'definitely', as it is capable of many
> things that PL/SQL is not.
>
> Jared
>
> On Thu, 22 Mar 2001, Jeff Cox wrote:
>
> > Dear List,
> >
> > I haven't really seen a question on this list regarding SQLJ, and it makes
> > me wonder how many people on this list actually use SQLJ. A DBA friend of
> > mine told me that eventually SQLJ will replace PL/SQL in preference, and I
> > wanted to know the truth regarding his statement - so who better to ask
> than
> > the experts of this list?
> >
> > What have you heard, or better yet, what is your opinion of SQLJ? Is SQLJ
> > the future? Will PL/SQL die a slow death? Can you do everything in SQLJ
> > that you can do in PL/SQL?
> >
> >
> > Cheers,
> >
> > Jeff Cox
> > IPS-Sendero
> > Scottsdale, AZ
> >

-- 
Regards,
Stefan Jahnke
BOV AG
@:D2 Vodafone, Abt.: FIBM
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stefan Jahnke
  INET: stefan.jahnke_at_d2vodafone.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).