#1 05 Mar 2007 21:48

Simon Sheppard
Super Administrator
Registered: 27 Aug 2005
Posts: 866
Website

Post your favourite Oracle utilities

You've probably already seen my list of handy utilities ( http://ss64.com/links/oralinks.html ) but I thought I'd start a thread where you can post links to any other tools you find useful..

Offline

#2 01 Aug 2008 12:48

Anand Kumar
Member
Registered: 16 May 2008
Posts: 13

Re: Post your favourite Oracle utilities

Hi,

I would like to introduce Oracle (10g) Data Archiving. Oracle data archiving is an efficient solution to enhance application performance through smaller production database sizes, shorter backup and recovery times, reduced labor costs to maintain the production system and lower storage costs. For more information visit http://www.solix.com/oracle_data_archiving.htm.

Offline

#3 28 Jul 2009 14:52

bcarrdba
Member
From: Ohio
Registered: 28 Jul 2009
Posts: 9
Website

Re: Post your favourite Oracle utilities

For beginners it is probably worth mentioning Oracle SQL Developer (http://www.oracle.com/technology/produc … index.html)

It's nice because it is free.  It certainly is no TOAD, but again, its free.

Offline

#4 31 Oct 2011 14:29

Tux me
Member
From: Copenhagen
Registered: 31 Oct 2011
Posts: 2

Re: Post your favourite Oracle utilities

Well it's not really a utility but i still think thet the Oracle by example (OBE) i a nice site.

http://apex.oracle.com/pls/apex/f?p=447 … 46130:::::

Edit: fixed URL

If you become a regular poster you will get rights to edit your own posts (we had to limit that to stop spammers from silently adding dodgy links to old threads)

Last edited by Simon Sheppard (31 Oct 2011 19:16)


"Do not speak unless you can improve the silence"

Offline

#5 16 Dec 2011 00:24

Opus
Member
Registered: 15 Dec 2011
Posts: 17

Re: Post your favourite Oracle utilities

TOAD!!!!!!

The DBA Suite is a little pricey, but it is an essential program for any professional DBA.  I prefer it hands down over any other similar tool because it does not take you too far from the nuts and bolts.  If my company did not provide it, I would buy my own copy.  Even at $9K for the RAC edition, it is well worth the money.  (Free is good when you can get what you need, but sometimes you have to pay the big bucks.)

SQLPlus

Here's another important utility.  When you work on a DBA team that manages more than 500 separate databases, scripting is definitely your friend.  Forget the GUIs.  When it comes to getting things done repeatedly and reliably, SQLPlus makes it all happen.

KornShell!

That's right!  This is a great Oracle utility because it can be used to produce powerful administrative applications that are both efficient and elegant.  I wouldn't use any other shell.  Well...ahem...except CMD on Windows--which is actually surprisingly useful too.

Plus, I LOVE the way Oracle works on Windows.  When you shutdown a database remotely on *NIX, you cannot restart it remotely.  You have to login (SSH) to the server and bring it up there.  (Anyone know if there is a trick here that I'm missing?)  On Windows, the Oracle process continues running after a shutdown because it is maintained as a Windows Service.  So, if I need to stop a database that is on the other side of the world where I have no O/S access, I can restart it without needing local touch labor.  Very helpful!

Cheers,
Opus

Offline

Board footer

Powered by FluxBB