Oracle

Changing SID on RAC environment

Just a short note documenting a procedure that isn’t done frequently, and I didn’t see described anywhere else. Somewhere last month a customer asked for my help in changing the SIDs on one of his RAC databases to match the new corporate standard. The database name matched the standard so we could leave that alone, but the SID needed to be changed. Here’s what we did to change it

Temporary Tablespaces: to BIGFILE or not to BIGFILE

The environment was an Exadata environment undergoing pre-production stress testing. We used Real Application Testing to take a highly-concurrent OLTP workload, and replayed the workload with the synchronization parameter set to FALSE, effectively increasing concurrency beyond the original test system. AWR showed a large volume of buffer busy activity.

Still a Lot of Database Offerings …

The CORE database audience has been well served at this year’s version of the UKOUG forum. Many of the shows we attend concentrate on the late-breaking components of the vendors’ new offerings. The attendees are hungry for this information and having it delivered in a 4-5 day package is very helpful.

Un-horror show

The mix of presentations at the UKOUG this year offers a plethora of education for a variety of attendees’ areas of concentration and I, being primarily a CORE database person, will easily find food for thought for sessions to attend when not tied up elsewhere.

The Drum Roll to UKOUG Commences

A mere 5,018 minutes until the festivities start at the 2012 version of the UKOUG User Group Conference. The show is intense and hugely educational with some of the world’s finest in attendance and presenting. For us Pythian’ites the trek terminates on Wednesday evening with British football’s Manchester United. Keep a close eye out for RACAttack above the vendor forum. Pythian’s own Alex Gorbachev and others will help you attack the RAC. Not to be missed.

Pythian’s 9th Oracle ACE

I have just received notification of my acceptance into the Oracle ACE program and will enthusiastically support and continue to be an evangelist for the Oracle offerings though most of my heart lies in the same place as many current and previous personnel at this fine company – the CORE database technology.

Page 4 of 79« First...23456...102030...Last »