TweetShareSharePin0 SharesI’ll give myself a quota for no more than one rant a month. However, one of my pet peeves is how Oracle licenses the database. I’l probably return to why I dislike the general model in a future rant, but this on e will be specific to partitioning. To use partitioning, you have to pay for the Enterprise Edition of the database at $40,000 per CPU and then pay an additional $10,000 for the partitioning option. That is a […]
DBA
Optimistic Locking with ORA_ROWSCN
TweetShareSharePin0 SharesAre you using 9i/10G and still implement optimistic locking with your own column rather than through Oracle’s pseudo column? So am I, but I couldn’t really explain why. My main (defensive) argument would be that the system was built long before 9i. Still, it would make sense for us to change it. Let’s look at a, hopefully, quick example. Let’s first create a user with two tables and add the same data to both tables. Two tables with just […]
SQL Access to the alert log
TweetShareSharePin0 SharesI’m going to discuss how to get SQL access to your alert log in this entry. I will then build on that to make it even more useful in future posts. Browsing the alert log can be convenient if you’re already on the server. However, it is often not possible or at least not overly convenient. You may find that as the developer DBA you do not have access to the production server, or you have to log in […]