1. Found this gem of a song thanks to my buddy Brian at ReviewTheWorld.com

    (Source: Spotify)

  2. Linux, Unix: Use PS to List Top Memory, CPU Eating Processes

    The ps command is a versatile and configurable way to look at the processes running on your system, though I’ve generally gotten by with a lazy ps -ef to find out whatever I needed to know. Recently, though, a client’s server began running out of memory, and as a number of processes were running on the server, the culprit was not immediately clear. I wanted to provide them with a quick, simple diagnostic tool they could use the next time they received an alert.

    If you look at the man page for ps you’ll find a number of options available for sorting the list of processes returned as well as for filtering the columns displayed.

    Some examples of ps options, from RHEL 5.6:

    -e select all processes
    -a select all “child” processes
    -U <user> select all processes for a specified user
    -p <pid> select by process id
    -f full-format listing; adds columns and shows process arguments
    -o user-defined format

    Many others are available, of course, but in order to keep it simple for the client I wanted to show the top 10 processes in terms of memory utilization, with the pid, memory usage, and process name displayed. Here is what I came up with:

    $ ps -eo pid,user,pmem,args O R | tail -n 10

    And here is an explanation:

    ps shows running processes
          -e show all processes
          -o pid,user,poem,args show the pid, %mem, and process columns
          O R sort by memory usage (ascending)
    tail shows only the last lines
          -n 10 show the last 10 lines

    I liked the concept so much that I decided to adapt it for OS X, where the ps command takes a slightly different set of arguments. To my .bash_profile file I added the following lines:

    alias psmem="while :; do clear; ps -ecm -o %mem,rss,pid,user,state,args | head -n 10; sleep 5; done"
    alias pscpu="while :; do clear; ps -ecr -o %cpu,pid,user,state,args | head -n 10; sleep 2; done"

    I have one alias for retrieving my top memory-utilizing processes and one for my top CPU-utilizing processes. The while loop in the alias implements a functionality similar to that of the Linux watch command, clearing the screen and running the process indefinitely until it is forcibly quit. For my own purposes I wanted to display some additional columns, like username and process state. I also changed the sort ordering to display the largest processes at the top of the list.

  3. A Texas 4th of July

  4. 16:12

    Tags: os x

    A nice solution for viewing man pages that eliminates the necessity of having to download 3rd party apps or Dashboard widgets

  5. Fix SQL Developer on a Retina Display Mac(book)

    I just purchased a new Macbook Pro 13-inch with Retina Display and was horrified to see how fuzzy SQL Developer looked on the high-res screen. Thanks to Thunderforge on the Stack Overflow forums for this tip:

    Java 7u40 Early Access now supports HiDPI (Retina) displays, as shown by this changelog. So retina support is now available on Java 6, Java 7u40 or higher, and Java 8.

    I am currently running the Early Adopter release of SQL Developer 4.0 which requires JDK 1.7. I’m not sure what the state of Java 8 is on the Mac, so I opted to upgrade my JDK from 1.7.0_25 to 1.7.0_40. After that I had nice, sharp lines back in SQL Developer and all my other Java apps.

    Thanks to Oracle’s Java team for addressing this!

  6. Resetting Page Numbering Between Document Sections in BI Publisher’s Template Builder for Word

    Under normal circumstances, it is fairly easy in Microsoft Word to reset page numbering when starting a new section of your document. However, such a simple thing can be non-trivial when dealing with the BI Publisher Template Builder plugin for Microsoft Office (available from Oracle — see BI Publisher Desktop).

    In short, doing this the normal way did not work for me, and in researching the issue I ran across a number of folks who were having the same problem. Page numbering was simply not being reset between sections, or worse, did not take into account a fluid document size based upon available data.

    One suggestion I read said to wrap the page number cells in a BI Publisher repeating group using for-each@section, like so:

    <?for-each@section:ID?> x/y <?end for-each?>

    But this also didn’t work for me. Finally I had to edit the RTF file directly.

    The RTF specification was of some help to me in doing this, as well as this explanatory page from Microsoft.

    RTF files can be a little confusing, but most of the “junk” in the files is just special codes for formatting the text. I was able to find my way around easily enough by searching for labels or keywords from the document. By searching for the first few words from the second section of the document (in this case, “Sender’s Receipt”), I was able to spot where the section break should go.

    Checking the RTF spec, I could see that the \page directive shown above was the page break between two sections of my document where I wanted to reset the page numbering. To create the section break, I inserted the following RTF directives at that point:

    \sect \sectd \pgnstarts1\pgnrestart

    Since the default behavior of the section break is to start on a new page, I found I had to remove the \page directive to avoid an extra page being inserted between the document sections.

    Interestingly, resetting the page numbering also works when calculating total number of pages, whereby the total is from the section, not the entire document, even though the NumPages field is used instead of SectionPages! Go figure, but it worked for me.

  7. image: Download

    I don&#8217;t think I&#8217;ve ever enjoyed a spring as much as this one.

    I don’t think I’ve ever enjoyed a spring as much as this one.

  8. Button Hotkeys in SQL Developer on OS X

    In Windows, most applications provide menu and button accelerator keys that allow you to control the application without having to use a mouse. Java Swing apps like SQL Developer allow you to do the same, ostensibly in a cross-platform compatible manner.

    One place I use this frequently is the Enter Binds dialog window that pops up when running a query using bind variables.

    In Java 6 on OS X, the hotkey for pressing the Help and Apply buttons was OPTION-H and OPTION-A, respectively.

    I initially thought this capability had been broken in Java 7 on OS X, but I discovered today that it has been merely changed to CONTROL-OPTION-H and CONTROL-OPTION-A.

    Does anyone know if this is a configurable property of the application or Java virtual machine? If possible, I’d like to set it back to the simpler 1.6 way.

  9. Using Jaspersoft’s free iReport Designer tool and the open source PL-JRXML2PDF project, you can generate PDF reports from Oracle Apex for free, without having to install the JasperReports and JasperReports Server components. Watch my video tutorial to find out how.

    (Source: vimeo.com)

  10. Fall is almost over, but it hardly feels like winter here in Dallas.