Category: Uncategorized

I’m trying to upgrade a system’s Grid Infrastucture to the latest/greatest version. The OUI says that I need 7GB of free space and I’m a little short. This is on virtual machines so we can grow the disk easily enough. Everything is installed in the root partition (this isn’t production) and my SysAdmin is asking …

Continue reading

Most of my Oracle databases run on Linux. And prior to that, one form of Unix or another. I’ve grown quite accustomed to using scp to quickly transfer a file between systems. While my databases may live in a *nix world, my workstation is normally a Windows OS. Natively, Windows has ftp, but not scp …

Continue reading

SQL Developer 4.1 was released on Monday. Here is the link to download the latest/greatest version.   ThatJeffSmith has a nice recap of the new features on his blog. I like the new formatting options and the Multi-Cursor Support is awesome! The Instance Viewer is cool, but I typically have a session on in EM12c which …

Continue reading

This really isn’t a new topic. I’m not first one to publish something like this. But I had a need to get these instructions posted on my blog. So here is how I created a two-node Oracle RAC testbed on my laptop. An earlier blog post shows why I think testbeds are important. When I …

Continue reading

We recently had one of our SQL Server instances experience a very large volume of change. Not suprisingly, the transaction log grew really big and was very close to filling up the disk. I had our SysAdmins add more space to the transaction log disk. The process that generated the large volume of transactions is …

Continue reading

I am proud to announce that my book is now available for purchase! Please order Oracle RAC Performance Tuning today! http://www.amazon.com/Oracle-RAC-Performance-Tuning–Focus/dp/0986119415/ref=sr_1_2?ie=UTF8&qid=1423756491&sr=8-2&keywords=peasland   Generic drugs and meds are buy tadalafil in australia as safe and effective as the original medication. On the buy levitra http://mouthsofthesouth.com/wp-content/uploads/2020/02/MOTS-03.07.20-Dixon-.pdf contrary, in acidic condition, they stop working. Basing the actual treatment …

Continue reading

The rumors started flying shortly after Oracle 12c was released with its new multi-tenant architecture that someday, there would be no Oracle databases that were not multi-tenant. Today, the Twitterverse has had a number of posts that reference this part of the Oracle documentation: https://docs.oracle.com/database/121/UPGRD/deprecated.htm#BABDBCJI   So the non-CDB architecture is deprecated now. Better start learning …

Continue reading

As the end of the year is right upon us, I thought it was time to look at this year’s stats for my blog. I’m averaging over 30,000 hits per month and about 3,000 unique visitors each month. I’m pleased with the attention my poor little blog is receiving. 🙂   Here are the stats: …

Continue reading

Is this a good time to be a DBA? My biased opinion is that any time is a good time to be a DBA. The US Bureau of Labor Statistics released an outlook indicating that DBA positions are expected to increase 15% between 2012 and 2022. Now comes this article that says about 50% of DBAs …

Continue reading

I am working on upgrading all of our production databases to the Oracle 11.2.0.4 version. My company’s most important database serves a custom, in-house developed application so we have the luxury (and sometime the curse) of having complete control over the application source code. If I discover a version-specific issue with a their party application, …

Continue reading