One day I came up with the following neat idea. Start a second listener, on a different port, calling it the emergency listener. Then renice the listener process with higher priority. Now, every time I connect to the database via my emergency listener, my connection gets higher priority, and thus feels like there’s no problem with the database’s resource use.
There is one little caveat however. You need to either have access to root, or have a nice SA that will add renice to your sudoers file .Read More >
I have submitted an abstract for my new presentation about linux/unix memory and Oracle to the Rocky Mountain Oracle Users Group for the Training Days in Denver on February 14-15, 2007. I pilot tested it at the Ottawa Oracle User Group in June. The feedback was good and since then I have kept developing the presentation. Soon to be submitted for HotSos 2007.Read More >
A client asked me, “How can I move a table to another schema in Oracle?” The quick answer I gave him is, “not possible”. You have to rebuild it via “create table as select”. You might ask, justifiably, why would you want to do that anyway? His problem was that the application has been split into 2 parts, and he wanted to have separate schemas for each part, to ensure that there is no cross-schema table access.Read More >
It’s time for vacation for me.
I am off to Europe and then vising home – Sofia, Bulgaria. I will be back in 4 weeks. Yes I did earn to have a long vacation, and yes, Pythian is really nice in allowing me to have it all at once.Read More >
There’s always these little things that you discover when you read the manuals. For example the “duration” option for RMAN backup. It looks very neat, and is actually in RMAN from 10g Release 1.Read More >
James Foronda sent a link to his blog entry about silent data corruption in an Oracle-l discussion. He points out a new file system called ZFS that has self-healing features.I read all the slides and it really looks like something cool to try out. It has some features similar to Oracle’s ASM, such as dynamic adding of disks, self balancing etc. It’s fully transactional, supports snapshots, online everything. Auto striping (not sure how this would work). Very feature rich.Read More >
I was installing RAC, and during the clusterware install I picked up the wrong interfaces for public and private. What had happened was I had a 10.x.x.x IP on both eth0 and eth1, which was messing up the routing. The solution? Simply modify the VIP in the cluster configuration.Read More >
If you have the ability to combine disk spindles at both the SAN level and Oracle (ASM) level, which one is better? Should you combine all your spindles on the SAN and present 1 big disk to OS and give that to ASM? Or should you present each individual disk spindle to ASM and let ASM do the mirroring? The disk group with 2 disks is slower! Those results are consistent, and confirmed with diagnostic output from iostat. You may start to wonder why would 2 be slower then 1. It should be twice as fast!Read More >
After I actually woke up I found myself attending a session about LogMiner by Chet Watmough. Log Miner in my opinion is a vastly under-used utility. It has such great versatility. Chet showed some techniques to add additional logging. By inserting the client info information into a dummy table, just to produce a record in the redo stream, he can identify who did what.Read More >
So I made my decision and went to “RAC & ASM best practices” presented by Kirk McGowan of Oracle. I wanted to see how far the documentation / common sense was from what will actually work. It wasnt that far from the docs, which is good. It means Oracle got it right.Read More >