It has been awhile since my last post. My pathetic excuses are all pretty much mentioned here. 🙂 Last month we’ve worked with the storage team to migrate the SAN storage of our Oracle 11gR1 database to a new one. The drive of migration is mainly for SAN consolidation which is, of course, ultimately for …
Online SAN Storage Migration for Oracle 11g RAC database with ASM Read More »
In our first large-scale Oracle 11g RAC with ASM deployment, we started this project by engaging Oracle. The primary goal of this engagement is to get as much technical input as possible especially when it comes to the areas of best practices. We’ve been advised by our Oracle account manager to use free RAC assessment …
If you’re using Informatica as ETL tool as we do, this may be useful if you’re working on upgrading it to the latest version 8.6.1 hot fix 2. During the testing, our ETL developers complained that the object check-in took a long time (sometime up to 2 minutes – compared to only a few seconds …
Informatica 8.6.1 Hot Fix 2 – Object Check-In is Slow Read More »
One of most exciting features of Oracle 11g is the Oracle Real Application Testing (RAT). Fortunately, Oracle extends support of this feature back to the previous versions. Even though the workload replay is only possible on Oracle 11g, the workload capture is now available in Oracle 9i and 10g. See the Metalink note: 560977.1 – …
Oracle RAT’s Workload Capture With Duration Set Does Not Stop Automatically Read More »
One of new exciting features of Oracle 11g is the Real Application Testing (RAT). The RAT has two solutions – Database Replay and SQL Performance Analyzer (SPA) to address two different issues. Both have the same concept (capture then replay), but are scoped differently. Database Replay applies at database-level workload for all activities (exclusion is …
As you all know, the transportable tablepsace (TTS) enables users to unplug a set of tablespaces from one database, and plug it into another database. It is very efficient to move bulk data because only metadata and data files are involved in file movement – this can be much faster than export/import. More detailed information …
asmcmd cp command on the test with transportable tablespace Read More »
