Monthly Archives: May 2009
Clone VirtualBox VM via Open Virtualization Format (OVF)
From VirtualBox 2.2, We can clone and distribute VM much more easily by Export/Import Appliance in menu. It utilize Open Virtualization Format (OVF) standard to distribute VM on demand. Note: if you are using VirtualBox 2.1.4 or lower version, clone … Continue reading
User-defined Metrics (1) – Integrate existing OS scripts
We can use scripts or SQL query to extend monitoring capability of Oracle OEM Grid Control. Basically, it works in this way. Utilized existing monitoring OS level scripts for machine monitoring, it doesn’t care it use Perl or Shell. And … Continue reading
400 miles drving : Ottawa Syracuse
This was what I did yesterday. Got couple of notes : 1) to prepare 2.5 us$ when crossed Canada-U.S border here (thousand islands area) , they don’t care you can’t see this beautiful area at night 🙂 2) to show … Continue reading
huge UNDO usage in history– What was happening? (4)
Who caused 99% UNDO tablespace usage yesterday? fortunately , Oracle 10g AWR allows you to find what SQL statements was consuming most of UNDO segments. Views to check out:DBA_HIST_UNDOSTATDBA_HIST_SQLTEXTTop 10 UNDO usage SQLselect SQL_TEXT from DBA_HIST_SQLTEXT where SQL_ID in … Continue reading
Oracle Buys Virtual Iron – Oracle VM looks better?
Oracle moved on to add value to existing Oracle VM. See report at "Oracle buys Virtual Iron". Note: there is a pdf inside this article. Oracle stated that major reason to reach this deal is Oracle VM can’t but Virtual … Continue reading
let Putty run command in remote server
In some case, putty command line can help us run remote command in this way: Examplec:> putty.exe -ssh -2 -l username -pw password -m c:remote.cmd remote_hostc:> type c:remote.cmdecho `date`;exit 0; Note:For full Putty command line options, check out "Putty User … Continue reading
let Perl work as crontab
You don’t have permission to schedule script in crontab? np, Let Perl help you. Example:#!/usr/bin/perldie "usage: $0 command_to_run interval" unless 2==@ARGV;while(1){ eval{ system("$ARGV[0]");}; warn $@ if $@; sleep $ARGV[1];} Note: for more details, check eval and sleep usage with command … Continue reading
bulk export emails in thunderbird – smartsave extension
we can use smartsave thunderbird extension to bulk export emails . It supports: – export all folders and subfolder – export emails selected – support local folder or from IMAP folder – save email as .eml files – prompt you to speicify direcotry … Continue reading
Borland gone!
"Borland Software Corporation to be Acquired by Micro Focus International plc" AUSTIN, Texas – May 06, 2009 : Borland Software Corporation (NASDAQ: BORL) (“Borland”), the global leader in Open Application Lifecycle Management (ALM), today announced that Micro Focus International … Continue reading
system level trigger – Who is running risky DDL
Let me show how to kick DBA ass if he is rying to run risky DDL, i.e alter table struture in production database. Oracle allow us to create system level trigger. So I can stop DBA doing that, don’t allow … Continue reading
老庞闲话 