Monthly Archives: November 2009
Extend Oracle SQL Developer (2) – XML extension – Archivelog Size over X days
Well, this time is to show archivelog over a period which DBA feel interested in. The idea is simple: Visualize ARCHIVELOG generated over X days. It is quick and fast to finish this small task. Feel much more easier when … Continue reading
Hurry UP! Drop database efficiently and effectively – SQL> Drop database;
Oracle 10g allows us to drop database quickly. It takes care of all files listed in controlfile: datafile, redo logs, controlfile and spfile if it is there. Well we have to clean up archivelogs and backup. Fine enough. Got be … Continue reading
Oracle website outage
Obviously, they are experiencing upgrade of Flash server, think about metalink issues couple of days ago.
Oracle 11g OCM upgrade exam landed
It is time to upgrade my 10g OCM certificate to 11g. Reference: "Oracle Database 11g Certified Master Upgrade Exam"
GoldenGate? Oracle Streams?
Oracle Streams: replicate Oracle-Oracle data, available from Enterprise Edition, special process, parameters and views to work with.GoldenGate: replicate between non-Oracle and Oracle, Oracle-Oracle as well, faster than Streams, no limitation on Oracle standard/enterprise edition. Why Oracle buy GoldenGate?To acquire replication … Continue reading
5 Years!!! Light with the world – Firefox
Firefox is good stuff and no alternative so far 🙂 See more details and 1 video at http://www.spreadfirefox.com/5years/en-US/ Screen shot of this video, worth checking out.
Extend Oracle SQL Developer (1) – XML extension – RMAN backup over X days
The idea is simple: Visualize RMAN backup from X days ago. I would like to see these things: backupset size, how long it took, compression ratio and backup type. Well, good enough, We can create Oracle SQL Developer XML extension … Continue reading
老庞闲话 