Posts by Christo Kutrovsky
My team and I still use old-style rollback segments for one of my client’s 10g production databases. We just never found the need to switch to automatic undo management. There are a number of 1GB rollback segments. They are that size because they need to be able to support large transactions. At the same time, we don’t want to have transactions bigger than 1GB as this is an OLTP system. For the past few weeks we’ve had a strange problem. One of the web calls would cause one of the rollback segments to become full by using 1GB of undo data.
I had been asked by a client to try out Oracle 10g’s transparent encryption. I’ve created the wallet, set it up into the sqlnet.ora file, and opened it. I initialized the certificate, created a test table, and encrypted a column with it. Maybe you’ve done the same, and thought, “now my data is safe and encrypted”. Are you sure? Did you check? I did. And here’s what I found.
Let me tell you the story of the on-site beta testing of Oracle 11g, where success is measured by the number of times you caused Oracle to misbehave. And let me tell you, it’s very hard to do so, even in the beta. It takes a specific mindset and a bit of adjustment to get in the mood to make things not work.
This year, there are three Pythian employees (Christo Kutrovsky, Alex Gorbachev, and Babette Turner-Underwood) going to Collaborate 07. All three of us ( will be presenting from the IOUG side. We provide our abstracts and presentation materials here.
So, you just installed the Oracle 10g clusterware, you just ran root.sh and got an error, you just went to metalink Note:316583.1 or Note:387691.1 the given interface(s), “eth0″ is not public, public interfaces should be used to configure virtual IPs, it just failed, and now you are relying on Google to help you with what Metalink couldn’t. Well look no more, and here’s the solution.
Linux is a wonderful operating system. However there are a number of things that one needs to do to make sure it runs as efficiently as possible. Today, I would like to share one of them. It has to do with using ASM (Automatic Storage Manager) disks.
In this new installment of Pythian Goodies Doug Burns discusses Parallel Basics. This video is a good introduction to using Oracle Parallel features and most importantly, what problems you may have with it.
Two weeks ago, I released a video about Flash Recovery Area as part of the Pythian Goodies project. Here is the next video in the sequence, Oracle I/O Basics.
I got a call from a developer who had a table with a primary key populated by a sequence, a timestamp column with the current date and some other columns. He had a specific set of data that, when ordered by the primary key had out of order timestamps. He was puzzled how this could be. We changed the sequence to “ordered” and increased the cache to 1000. Now selecting on either node gets the next number as he expected. I warned him that there would be some performance implications due to cluster synchronization. Him being a responsive developer, asked me what the impact would be, so I tested it out.
On Friday, I announced the Pythian Goodies project, and now here it is, the very first video of the series. The topic is “Flash Recovery Area,” and how can it make your life easier.