Oracle 10g Release 1 is Out of Premier Support

During the Premier Support time-frame, Oracle is committed to providing interim patches for the most current patchset (and if you can persuade them, even for older patchsets). Oracle 10.1 is only supported as part of Extended Support, a purchasable option providing customers with an option to get one-off patches for their critical issues.

Testing a Physical Standby Database in Oracle 10g

If you don’t want to deal with missteps, I recommend that you test your standby database to facilitate the failover or switchover process. This procedure is very useful when you have physical standby databases for testing and other purposes that require read-write access to the standby database. Also, it improves your checklist in the event of an error or disaster. Here is how to do it.

Hitting Oracle with a Hammer

Recently, I had an opportunity to participate in a database stress-testing exercise. The objective is to make sure the particular hardware can handle the expected load and also to test where the physical limit of the machine lies if we keep increasing the number of concurrent users. I searched for tools available out there. The open source Hammerora turned out to be excellent tool for the purpose of simulating a typical transactions load in any number of threads. It’s built with the Tcl scripting language and it can simulate a real workload with as many client user sessions as your system can handle. If you’re looking for an easy way to measure throughput performance of your database, keep reading.

Page 90 of 140« First Page...10...8889909192...100...Last Page »