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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
