At the end of the previous installment we saw that a single big batch delete would (apparently) attach all the “reusable” chunks into a single freepool, and asked the questions:
- Why would the Oracle developer think that this use of one freepool is a good idea ?
- Why might it be a bad idea ?
- What happens when we start inserting more data ?
(Okay, I’ll admit it, the third question is a clue about the answer (more...)
I am not going to post how to convert to extended data type since there are many blogs on that already.
Just a reminder, there’s no going back; hence have backup and possibly minimize changes during testing to be able to restore (which is ideal and may not be feasible).
Before reverting to MAX_STRING_SIZE=STANDARD, columns affected by extended data type need to be identified.
From Oracle documentation, MAX_STRING_SIZE controls the maximum size of VARCHAR2, NVARCHAR2, (more...)
I wrote a Tweet about triggers yesterday that seemed to get a strong reaction, so I thought I would clarify some things. 🙂
Guns don’t kill people, people do (or is that rappers). In the same way, triggers are not inherently evil, but their misuse is. Toon Koppelaars, of Helsinki Declaration fame, wrote some posts about triggers, which amongst other things highlights the problem of stigmatising something because it is being misused. With all that (more...)
Specialized graph databases such as Neo4J specialize in traversing graphs of relationships – such as those you might find in a social network. Many non-graph databases have been incorporating Graph Compute Engines to perform similar tasks. In the MongoDB 3.3 release, we now have the ability to perform simple graph traversal using the $graphLookup aggregation framework function. This will become a production feature in the 3.4 release.
The new feature (more...)
It’s frustrating to have to spend time jumping off into web security and wordpress configurations when there are so many other things that are important to be doing. Today the DoS continued and the Jetpack solution didn’t seem to work. The other two solutions from Digital Ocean didn’t seem reasonable. One was to re-install wordpress with there install version. Nice that they offer a better security protected version but I didn’t feel like re-installing my (more...)
On the first or second year after I became a DBA (somewhere in the year 2000, give or take), I heard about this magical event that is taking place in the Oracle realm. All the top Oracle DBAs and professionals in the world (and maybe a couple of unicorns, I’m not sure) are gathering in a small but beautiful village by the name of San Francisco – and talk about databases. I found this story (more...)
Last week, I had a chance to read the latest book of my friend Porus Homi Havewala. If you’re interested in Oracle Enterprise Manager, you already knew him or at least read one of his articles/blog posts. He’s a Subject Matter Expert (SME) on Oracle Enterprise Manager Technology, Oracle Certified Master (OCM) and Oracle ACE Director. Porus created one of the world’s first blogs dedicated to Enterprise Manager (http://enterprise-manager.blogspot.com), and he (more...)
I tweeted and mentioned reasons why people should attend Oracle Open World, but apparently I haven’t written an actual post about it, so I decided to do that now. This post won’t be too long, but it will contain the things I like most in this amazing conference. I divided the experience of OOW to […]
I wrote some blog posts about Enterprise Manager Cloud Control 13c a little over 6 months ago.
Since those posts we’ve had bigger fish to fry, so I pretty much put 13c on hold until now. I’ve just built a new 13c server and in the coming weeks will be (more...)
Yes, it’s that crazy time of the year again, when the city of San Francisco turns red – it’s Oracle Open World (OOW) 2016! If you’re planning on going this year, I hope you have your hotel room booked, because they disappear very, VERY quickly!
Every year just before OOW, the product teams produce what we call Focus On documents, that show you all the sessions (both customer and Oracle presented) around a particular area. (more...)
A customer recently asked me about whether they can convert numerous cron jobs to EM’s Job System. It reminded me that a former manager of mine had posted an article on just how to do this conversion. That manager has since left Oracle, and since his posting was on his own website, I wanted to make sure the intellectual capital wasn’t lost to us if he decided to remove it. The article was written in (more...)
This site had been running for a years with no big issues.
I had performance and system saturation issues about 3 years ago and then move the site to DigitalOcean.com.
They are inexpensive and the performance is awesome.
Then last Monday and every day since the site had been going down.
Simplest “solution” for me was just to get on and bounce the machine.
That cleared it up.
After this went on for a (more...)
In the previous article in this mini-series I described how the option for setting freepools N when defining Basicfile LOBs was a feature aimed at giving you improved concurrency for inserts and deletes that worked by splitting the LOBINDEX into 2N sections: N sections to index the current LOB chunks by LOB id, alternating with N sections to map the reusable LOB chunks by deletion time.
In this article we’ll look a little further into (more...)
Proud “parent” of a bouncing baby book
Today a box arrived from Oracle Press. In it were a few copies of “Real-World SQL and PL/SQL” which I co-authored with Arup Nanda, Brendan Tierney, Heli Helskyaho and Alex Nuitjen. I know I only blogged about the book a couple of weeks back, how I became involved and the impact it had on my life for several months, but as I can now physically handle and read (more...)
Some of my sessions this year at OpenWorld are at the Park Central.
So…you’ve arrived at the Moscone Center, and you’re wondering “How do I get to the Park Central ? After all…that’s where all of the hot talks will be”
Here’s my simple guide:
1) From Howard St, head up the stairs next to the Moscone Center entrance
2) Walk down through Yerba Buena Gardens… You can’t miss them, they are a great grassy (more...)
In a few short weeks I’ll be jetting off to Oracle OpenWorld 2016. It’s pretty crazy to think this will be my 11th visit to OOW and San Francisco…
The rough itinerary for the trip will be…
New York City. I’m going to break my flight in NYC for a few days on my way to San Francisco. I’ve only recently confirmed my flights, but as soon as I did I reached out to NYOUG (more...)
Oracle Enterprise Manager supports 3rd party plugins which can help you to extend its monitoring and manageability capabilities. There are already developers and companies specialized in plugin development. Blue Medora is one of them (and probably the most famous one). In this blog post, I’ll show you how we can use Blue Medora’s EM PostgreSQL plugin, which is part of their True Visibility Suite for Oracle. I’ll download and deploy the plugin on the OMS (more...)
This blog post is centered on All-Flash Array(AFA) technology. I mostly work with EMC XtremIO but the majority of my points will be relevant for any AFA. I’ll specifically call out an array that doesn’t fit any of the value propositions / methods I’m writing about in this post.
Oracle Automatic Storage Management (ASM) is a very good volume manager and since it is purpose-built for Oracle Database it is the most popular storage presentation (more...)