Subscribe to Blog via Email
Join 1,053 other subscribersArchives
Category Archives: Uncategorized
Delphix upgrade in twenty minutes
Just got off of a Webex with Delphix support. They upgraded our Delphix server from version 3.0.3.1 to 3.2.5.1. It took about twenty minutes. Pretty nice compared to an Oracle database upgrade I think! The only thing that took some … Continue reading
Posted in Uncategorized
3 Comments
Cool Picture of Instance/Database from 12c Concepts
I just think this is a cool picture of an Oracle 12c instance and database from Oracle’s 12c Concepts manual (not my own work): This is from the concepts manual found here: url – Bobby
Posted in Uncategorized
2 Comments
Finished reading Oracle Core
Just finished reading the book by Jonathan Lewis titled “Oracle Core: Essential Internals for DBAs and Developers“. I think I picked it up at the Collaborate 13 conference in Denver last April but haven’t had time (or taken the time) … Continue reading
Posted in Uncategorized
3 Comments
Top Ten Posts So Far
Just for fun I’ve pasted in a table listing the top 10 most viewed posts on this blog as links and including total number views since this blog began in March 2012. I based this on WordPress’s statistics so I’m … Continue reading
Posted in Uncategorized
Leave a comment
Exadata compression reduces row chaining > 255 columns
After I did my previous post on how adding a column to a table with more than 255 columns can cause a ton of row chaining the question came up about Exadata and the form of compression we use on … Continue reading
Posted in Uncategorized
4 Comments
Exchange Partition Example
I put together an example of how to do an exchange partition to meet a specific need in our environment. It might be helpful to others though your situation may vary. It is a self-contained test script in a zip. … Continue reading
Posted in Uncategorized
Leave a comment
Full scan performance on tables with more than 255 columns
Production issue We have some production tables with more than 255 columns and are experiencing performance degradation on queries that access certain columns. I was able to show that a full table scan with a where clause condition including one … Continue reading
Posted in Uncategorized
1 Comment
Testing removing subpartitions from a table with query testing package
I thought I would start this blog post before I finished this testing so I wouldn’t forget what I’m doing along the way. Usually I just write something up after I’m done and then I may forget all I’ve done … Continue reading
Posted in Uncategorized
Leave a comment
Four Dimensions of DBA Activity
This week I am reviewing my accomplishments for 2013 and thinking of possible goals for 2014 in preparation for my annual performance review. After reviewing my notes about what I did this year and brainstorming about what I want to … Continue reading
Posted in Uncategorized
1 Comment
Good blog post – OK to be the DBA I am
This is a good blog post. I’ve come back to it multiple times to get perspective on my career and involvement in the Oracle community: Tim Hall blog post on why you shouldn’t try to become an Oracle ACE I … Continue reading
Posted in Uncategorized
Leave a comment