So the new place I work has some small applications built in Apex. I'm getting ready to build some monitoring tools and wanted to integrate their functionality into the apps that are already available. Oracle publishes a document called the "2 Day + Application Express…
Looks like Oracle has finally come around and made it easier to incorporate the DBI module into the Oracle HTTP Server. The 10gR2 HTTP Server Administrators guide also has a laundry list of other modules that are enabled by default or easily turned on. Here…
If you haven't seen this optimizermagic.blogspot.com post already, check it out. It covers the standard Execution Plan stuff, but also covers use of the dbms_xplan package including using dbms_xplan.display to format output and using dbms_xplan.display_cursor to see Bind Variables used to generate a plan! Click…
I haven't look at Oracle's Remote Diagnostic Agent (RDA) tool in a couple of years. Back when we ran our systems on Windows I remember using a clunky version of RDA that looked like it was cobbled together with batch files and VB code. What…
So I have mentioned before about the replication product that we use that is based on Archived Redo Logs (Golden Gate). Well sometimes the replication process abends before the RMAN backup. Since there is no communication between the two processes, RMAN happily removes archived logs…
So I took my first hands-on class from Oracle this month. I'm usually of the 'sit down with a book and computer' camp when I need to learn something new, but where I work we needed RMAN proficiency quickly. I thought it might be better…
Statspack Reports can be useful for diagnosing performance problems, but they are only useful if they are generated and available! I wanted to set up an operating system job to generate statspacks. First I wrote a cron job to execute statspack.snap() at intervals during our…
There may come a time when you need to return an error code from SQLPlus, either to a calling batch file, shell script, or Perl script. SQLPlus has a WHENEVER directive available for handling errors it encounters. This command controls the behavior of SQLPlus when…
Did you know you can make your own Long Running Operation that is available to the V$SESSION_LONGOPS system view? At the bottom of the Oracle documentation for DBMS_APPLICATION_INFO is some example code: http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_appinf.htm#i999254 In a previous post I posted Perl source code for a script…
If you have a lot of LOB data to move around with Oracle import/export utilities this might help you out. The default for the COMMIT parameter is No. COMMIT=N : For tables that have a LOB column, commit is performed after loading each table This…
Tired of updating scripts by searching and replacing until your fingers fall off? Have a SQL statement you have to run against every table in your schema? Next to Regular Expressions, this is one of the most useful tools in my arsenal. Common uses for…