Wednesday, July 31, 2013

Oracle: explain plan how to

SELECT * FROM TABLE(dbms_xplan.display);
EXPLAIN PLAN FOR SELECT ...

Saturday, July 27, 2013

How to print an MP3 CD insert

Front cover: use iTunes print CD insert functionality
Back cover: use MACCC + cdlabelgen

MACCC does not work under OSX 10.8 or Linux (no GUI), so you need to use Windows.
NB: Use it fullscreen or tables remain empty (don't know why).
The options to be selected are as follows:


Then you can use the txt output file into cdlabelgen, as shown below:

And the PS output file can directly be printed on OSX.

OSX iTunes 11: How to burn a MP3 CD with folders

If you want to use an iTunes playlist composed of multiple albums and create a folder for each of these albums onto the disk to burn, you can do it by clicking on the Album column header.

If you don’t click on the Album column then the MP3 CD will be created with all of the songs in one folder.
Beware to not select Album by artist while clicking on the Album column header, or you might get some crap, e.g. folder 1 Will.i.am , folder 2 Will.i.am Featuring Britney Spears, etc. for the same album.

OSX: use TAB to switch between buttons in dialogs

  • System Preferences
  • Keyboards
  • In the bottom of the dialog, in Full Keyboard Access section, check the All controls radio button

OSX screen capture

Shift + Command + 4

Thursday, July 18, 2013

Oracle Enterprise Linux: add oracle user to sudoers

su - root
oracle
/usr/sbin/visudo
Add
oracle ALL=(ALL) ALL
or if no password prompt wanted
oracle ALL=(ALL) NOPASSWD:ALL

Change to UK keyboard on X86 Linux

setxkbmap gb

Wednesday, July 10, 2013

Show Oracle current jobs which name starts with

SELECT COUNT(*) FROM DBA_SCHEDULER_JOBS WHERE JOB_NAME LIKE 'MBQT_DEQ%';