TweetShareSharePin0 SharesThere are many blogs about the product and so on. I want to recommend that you enable and give your developers access to it. Setting them up and getting them to scale the mountain of complexity that is the normal Enterprise Manager is probably not what you want to do. However, EM Express is a slimed down version focusing pretty much on just what a developer ought to care about, seeing the processes in the database and data about […]
Database
Add hint to SQL you cannot modify
TweetShareSharePin0 SharesThe last post showed how to lock the plan for a SQL that switched plan every now and then. Another common issue one can encounter is that of a SQL that uses a suboptimal plan and for which you’d want it to use a different plan. The way to instruct the optimiser to use a different plan is to use a hint to cause it to change how it accesses the table. But often the SQL is in application […]
Longs in SQL
TweetShareSharePin0 SharesUsing long datatype is a problem we seldom face with new applications. But some old may still have it if they have not managed to convert to somethings easier to work with. But where I most often encounter it is in Oracles tables. The place that by far most often pops up its ugly head is high_value in *_tab_partitions. Just the other day a colleague was stuck on how to grab a portion of its content in SQL. “You […]
Dumb Oracle refuses to use my great index
TweetShareSharePin0 SharesLet me tell you a story about a developer, let’s call her Sue, that had proved that Oracle was having mood swings and just didn’t use a perfectly good index even though it was the perfect index to use. This of course made Sue very upset and she spared nobody from her bitter words about how unreliable and temperamental the database was. It just wasn’t willing to use the index because it was stubborn. Poor Susan was the DBA […]
Oracle Tools Is Great, Start ATP With A Click
TweetShareSharePin0 SharesSometimes you’ve looked briefly at a product and when you return a couple of years later it is like opening a kinder egg. All sorts of new impressive things show up and you are left to wonder “are these old and I missed them or have they been added”. Oracle Developer Tools extension for Visual Code is one such product. I’ve looked at it before and have always had it installed, but have not looked at what it can […]
Database is the marquee feature again
TweetShareSharePin0 SharesSo every year before and during Oracle Open World we all complain about how data and database is brushed to the side. This year it is the feature. It is the one thing the big sign on Moscone West screams. “The Autonomous Database” Here is a picture from showing it. It is all about database. Every year there is talk about how Oracle needs to return to data and databases. Now that they do, I think we should be […]