Oracle: Event 10046 and trace levels

10046 EVENT levels have four trace levels:
1 - Enable standard SQL_TRACE functionality (Default)
4 - As Level 1 PLUS trace bind values
8 - As Level 1 PLUS trace waits
12 - As Level 1 PLUS both trace bind values and waits

Oracle: Rotate Listener logfile

One of the larger growing log fileon Oracle RDBMS is listener.log located at $TNS_ADMIN. You can clean it up and put the logfile to rotation without shutting down the listener.

$ ls -l *.log
-rw-r----- 1 oracle dba 13387343 Mar 18 09:53 listener.log

Truncate file/ Clear the logfile:

cat /dev/null > listener.log

or

echo "" > listener.log

Now, listener.log will be of 0 bytes.

Mac: YouTube videos stop playing on Safari

Des Moines, IA: I was having a problem accessing YouTube on Safari. I used to get a black screen. I tried updating Safari Application, updating the flash plugin on my mac. It didn't really work out.

Here is a workaround:

Open the url http://www.youtube.com/swf_test.html on a new window. Right click on the video screen and select 'settings'. You can see a check box 'Enable Hardware Acceleration' on Display tab of the small pop-up window. Uncheck the option.

The alternate option is to Quit Safari application, Open 'Applications' folder in the Finder. Right-click on Safari, select 'Get Info', check 'Open in 32-bit mode' option.

Again make sure you have latest Safari, Flash Plugin on you machine.