Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Programming languages that make DBA's lives easier
The same way as you do perl: external library....
> -----Original Message-----
> From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com]
> Sent: Tuesday, February 18, 2003 4:44 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Programming languages that make DBA's lives easier
>
>
> Cool! How'd you get Python to run from a DBMS_JOB?
>
> :D
>
> Rich
>
> Rich Jesse System/Database Administrator
> rich.jesse_at_qtiworld.com Quad/Tech International,
> Sussex, WI USA
>
> -----Original Message-----
> Sent: Tuesday, February 18, 2003 2:34 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 3, 4, 5, 6 can be replaced with Python or Jython with
> wx_Python for added
> GUI-ness. :-)
> http://www.networkcomputing.com/unixworld/tutorial/005/005.htm
> l#Others
> http://www.linuxjournal.com/article.php?sid=3882
> http://www.linuxworld.com/linuxworld/expo/lw-python.html
> To know Python is to love Python.
> Language redactionist, minimalist, extremist, pacifist...
>
>
> -----Original Message-----
> Sent: Tuesday, February 18, 2003 12:38 PM
> To: Multiple recipients of list ORACLE-L
> A list of languages doesn't do much good unless you know why
> they are needed
>
> and how important the language is to your Oracle implementation:
> 1) PL/SQL.
> Vital! Needed in order to create database triggers,
> functions,
> procedures, and packages. Know it and know how to write it
> well. This
> could be the single most important performance killer for systems.
> 2) Some Unix shell. I prefer Korn.
> Vital if you are maintaining Oracle DBs on a
> Unix/Linux platform to
> be able to debug Oracle problems by knowing where important
> Oracle files are
>
> located and how to examine and manipulate them. Also needed
> if you want to
> use Oracle Internet Directory on Windohs, via the CygWin
> environment. If
> you support Oracle on OpenVMS, extensive knowledge of DCL,
> the shell on
> OpenVMS, is a definite plus.
> 3) Perl.
> Very important. It's cross-platform, can do many OS
> functions with
> greater control over Korn/Bash/Csh (IMHO), and has a huge
> development base.
> I use it for DB functions like some hot backup-and-startup
> over multiple
> nodes as well as some external OS file manipulation (Oracle
> log and trace
> files) that was just too difficult to do in Korn from the OS and not
> applicable to do from Java in the DB. There's also the Perl
> for Oracle DBAs
>
> book, which is very popular among folks on this list.
> (Sorry, Jared! It's
> next on my Book List, though! Tax refund soon!)
> 4) Java.
> Not critical for us yet, but we are rolling out a few
> Java apps in
> one of our DBs. It's needed for us because it'll give us a
> way to replace
> some icky VB apps whose sole purpose is to e-mail from an
> app. I've also
> setup some PL/SQL procedures that allow a developer to enable
> 10046 tracing,
>
> turn it off, and call Java to tkprof and copy the protected
> trace file to
> their directory. I still don't know Java much, but have been
> able to glean
> enough to pull this off.
> 5) Tcl.
> We don't need it, but it would be helpful if you want
> to roll your
> own OEM events, at least up until now. Not sure what the
> upcoming OEM
> version uses on the server side.
> 6) Tk.
> Cool if you want to roll your own GUI apps in Perl or
> Tcl. :)
>
>
> That's my $.02. Enjoy! :)
> Rich
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net -- Author: Gogala, Mladen INET: MGogala_at_oxhp.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).Received on Wed Feb 19 2003 - 08:49:05 CST