Free Java dba monitoring tool and Java source code

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
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: jkstill_at_cybcon.com

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sam P. Roberts (ZADCO ITIS)
  INET: roberts_at_zadco.co.ae

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).