Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Programming languages that make DBA's lives easier

RE: Programming languages that make DBA's lives easier

From: Orr, Steve <sorr_at_rightnow.com>
Date: Tue, 18 Feb 2003 12:34:00 -0800
Message-ID: <F001.00550BEA.20030218123400@fatcity.com>


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.html#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: Orr, Steve
  INET: sorr_at_rightnow.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 Tue Feb 18 2003 - 14:34:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US