RE: Free Java dba monitoring tool and Java source code
Title: Free Java dba monitoring tool and Java source code I still have not finished it, I assume you are refering to QuickSite? it is still very basic, I will be happy to send it with source later this evening if that is what you are looking for. I am completely re-writing it into web interface app. but it is fun to look at, right now all it does monitor multiple databases hit ratios. -Original Message-From: Yttri, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 22, 2001 3:56 PMTo: Multiple recipients of list ORACLE-LSubject: Free Java dba monitoring tool and Java source code Hi - There was a post a couple of months ago from someone who had written this java tool and you could e-mail him to get a copy. Does anyone have his e-mail or a web site where the software can be found? Thanks - Lisa
Free Java dba monitoring tool and Java source code
Title: Free Java dba monitoring tool and Java source code Hi - There was a post a couple of months ago from someone who had written this java tool and you could e-mail him to get a copy. Does anyone have his e-mail or a web site where the software can be found? Thanks - Lisa
Re: Free Java dba monitoring tool and Java source code
Title: Free Java dba monitoring tool and Java source code lisa I posted about a java SQL monitoring tool that I developed. The source code is also available - please e-mail me offline for details Sam - Original Message - From: Yttri, Lisa To: Multiple recipients of list ORACLE-L Sent: Tuesday, May 22, 2001 11:55 PM Subject: Free Java dba monitoring tool and Java source code Hi - There was a post a couple of months ago from someone who had written this java tool and you could e-mail him to get a copy. Does anyone have his e-mail or a web site where the software can be found? Thanks - Lisa
RE: Free Java dba monitoring tool and Java source code
Andy any luck with installing the tool. I enclose word doc about the tool Any problems with installation, please dont hesitate to contact me. The initial setting up of a Java application is always tricky, but once youve done one, you can get a clear picture. Thanks Sam -Original Message- Sent: Tuesday, April 17, 2001 9:31 PM To: Multiple recipients of list ORACLE-L Hi Sam, 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. 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. I'd love to see your Java Oracle DBA Open Source tool, up on a public internet site somewhere for download! :-) Some other Java-Oracle type Open Source links you might want to look at, to help further your own work, are: Apache JServ = http://java.apache.org/jserv/index.html DB Prism, Java/Oracle servlet engine = http://www.plenix.com/dbprism/doc/Home.html Tomcat (replacement for JServ) = http://jakarta.apache.org/tomcat/index.html jDBA, another Java Oracle DBA tool = http://www.jdba.org ViennaSQL, Java/Oracle SQL tool = http://vienna.sourceforge.net jDBA may the one you're most interested in, but using Java as the programming language for Open source projects, including Oracle ones, is growing rapidly in popularity! :-) Hope this is of some use 8) Rgds, AndyD = [EMAIL PROTECTED] O'Reilly's "Oracle and Open Source": = http://www.oreilly.com/catalog/oracleopen/ Orac, Perl/Tk and Perl DBI Database DBA Development Tool: = http://www.perl.com/CPAN-local/modules/by-module/DBI/ANDYDUNC/ __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andy Duncan 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).
RE: Free Java dba monitoring tool and Java source code
Hi Sam, Andy any luck with installing the tool. I enclose word doc about the tool Unfortunately, I've been on the road and living out of suitcases, in hotels, for the last 3 weeks, teaching Perl for Learning Tree. Also, our O'Reilly book, "Oracle and Open Source" has been printed this week, and I've had to write some articles to go with the launch, when it will be available to buy in a week or two, once it gets from the printers to the retail warehouses! Once life has settled down, I'll get onto your tool, and hopefully we'll be able to run a section on it, once you've made it into a Java/Oracle world leader, in our 2nd edition, IF we make it that far. I'm hoping the subscribers to this list, will help make that possible! :-) Rgds, AndyD = [EMAIL PROTECTED] O'Reilly's "Oracle and Open Source": = http://www.oreilly.com/catalog/oracleopen/ Orac, Perl/Tk and Perl DBI Database DBA Development Tool: = http://www.perl.com/CPAN-local/modules/by-module/DBI/ANDYDUNC/ __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andy Duncan 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).
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: [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
Re: Free Java dba monitoring tool and Java source code
Hi Sam, 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. 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. I'd love to see your Java Oracle DBA Open Source tool, up on a public internet site somewhere for download! :-) Some other Java-Oracle type Open Source links you might want to look at, to help further your own work, are: Apache JServ = http://java.apache.org/jserv/index.html DB Prism, Java/Oracle servlet engine = http://www.plenix.com/dbprism/doc/Home.html Tomcat (replacement for JServ) = http://jakarta.apache.org/tomcat/index.html jDBA, another Java Oracle DBA tool = http://www.jdba.org ViennaSQL, Java/Oracle SQL tool = http://vienna.sourceforge.net jDBA may the one you're most interested in, but using Java as the programming language for Open source projects, including Oracle ones, is growing rapidly in popularity! :-) Hope this is of some use 8) Rgds, AndyD = [EMAIL PROTECTED] O'Reilly's "Oracle and Open Source": = http://www.oreilly.com/catalog/oracleopen/ Orac, Perl/Tk and Perl DBI Database DBA Development Tool: = http://www.perl.com/CPAN-local/modules/by-module/DBI/ANDYDUNC/ __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andy Duncan 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).