Once again this year, the German Oracle Users Group has its annual conference and exhibition in Nuremberg. (DOAG Konferenz und Ausstellung 2011, Nürnberg). Being there is nearly a must for Oracle guys in German speaking countries. As usual, here comes my unordered, incomplete and ad-hoc list of things I wrote down to have a closer […]
Year: 2011
Oracle Clusterware 11.2: ASM crashes at startup
These days, a customer’s Oracle Clusterware (2 nodes) crashed one ASM instance at every startup. More Facts: It was not possible to start it manually, too. The CSSD was running. For obvious reasons, CRSD did not start. The other ASM instance in the cluster recognized CLUSTER RECONFIGURATION for a short period of time. The ASM […]
Linux Network bonding – setup guide
After looking up Linux bonding stuff for the thrid time, I planned to write an article aubout it. But there are lots of good blog posts on this, so just click here at unixfoo: Linux Network bonding – setup guide (strange link, I know, but it works) Hope it helps for you next high avaliability […]
Oracle: Manage the lifetime of trace files et al. with ADRCI (purge interval)
Oracle Database 11g and above offers a great feature by managing its trace files by itself. In combination with the new “incident” system, a tool was necessary to handle those without enterprise manager: ADRCI. It has several other cool functions, such as a tail-like log file display, but today I just want to show a […]
Oracle Grid Infrastructure: How to recover from a messed up ASM/CSSD diskstring
Oracle Grid Infrastructure 11.2 with voting files and OCR in an ASM diskgroup can be a little tricky if you mess up the voting file voodoo. You know the basic situation? With Oracle Grid Infrastructure aka Oracle Clusterware, we are storing your cluster quorum and config repository (OCR) into a disk group. But CSSD needs […]
Oracle ASM / CloudFS licensing policy
Sad to see, at least from June 1st 2011 the new Grid Infrastructure ASM features “ACFS” (ASM cluster file system) and “ADVM” (ASM dynamic volume manager) are now licensed as “Cluster FIle System” (ClusterFS). As far as I can see from the Technology Global Price List, it’s US$ 5000 per CPU, US$ 1100 perpetual. Alternatively, […]
Microsoft SQL server fragmentation and reorganization
Oh really, there ARE guys with deep insight into Microsoft SQL server. This notes absolutely look like a willing professional who did learn something new: http://blogs.technet.com/b/josebda/archive/2009/03/20/sql-server-2008-fragmentation.aspx But what about me? I am still looking for a course or material giving me the SQL Server architecture and logic in a way I can understand. At least […]
How to find out the (biggest) table size in MS SQL Server?
How to find out the (biggest) table size in MS SQL Server? To find the answer in your preferred search engine is difficult – not because there are no hits, but there is that lot of crap to see, it’s just unbelievable. If you don’t want to enjoy this experience, maybe have a look into […]
CREATE TABLE AS SELECT (CTAS) in MS SQL Server
In Oracle often we are using CREATE TABLE TABLE_B AS SELECT * FROM TABLE_A; But in SQL Server, this syntax does not work. Use SELECT * INTO TABLE_B FROM TABLE_A; COMMIT; instead. Hope this helps Martin […]
Oracle Performance Firefighting with Craig Shallahamer (Frankfurt, April 2011)
In early April, I had the honour to attend Craig Shallahamer’s Oracle Performance Firefighting and Advanced Performance Analysis courses. It was a great opportunity, since he came to Frankfurt which is just a three hours drive away. It was the second time meeting him – and it was great, again. The last two days have […]
Terrifying Execution Plan with cost of 18E (exa)
The newest piece of my bloomer collection is a query with an execution plan that has 18E of cost. I am no believer in absolute cost numbers, but this one is just nice. This exa-executionplan is the new definition of Exadata…. Keep your fingers off 😉 Usn […]
Glancing into MS SQL Server
I have not been able to blog for a while. My family has grown, and so there have been different priorities. In the meantime, I was told to become responsible for a few MS SQL Server databases as well. I took it for a challenge, and started digging into a different world. Well, sometimes different, […]