Quick, which database is the biggest space consumer on this system?
Database Total Size Total Storage
-------------------- --------------- ---------------
SAD99PS 635.53 GB 1.24 TB
ANGLL 9.15 TB 18.3 TB
FRI_W1 2.14 TB 4.29 TB
DEMO 6.62 TB 13.24 TB
H111D16 7.81 TB 15.63 TB
HAANT 1.1 TB 2.2 TB
FSU 7.41 TB 14.81 TB
BYNANK 2.69 TB 5.38 TB
Among movements like Agile
, Lean Startup
, and Design Thinking
these days, you hear the term fail fast
. The principle of failing fast
is vital to efficiency, but I’ve seen project managers and business partners be offended or even agitated by the term fail fast
. I’ve seen it come out like, “Why the hell would I want to fail fast
?! I don’t want to fail at all
.” The implication, of course: “Failing is (more...)
Within Accenture Enkitec Group,
we have recently been discussing the Oracle db_block_checksum
parameter and how difficult it is to get clients to set it to a safer setting.
Clients are always concerned about the performance impact of features like this. Several years ago, I met a lot of people who had—in response to some expensive advice with which I strongly disagreed—turned off redo logging with an underscore parameter. The performance they would get from doing (more...)
Once upon a time, I told my friend Chet Justice
why he should start using one space instead of two after a sentence-ending period. I’m glad I did.
Here’s the story.
When you type, you’re inputting data into a machine. I know you like feeling like you’re in charge, but really you’re not in charge of all the rules you have to follow while you’re inputting your data. Other people—like the designers of the machine (more...)
I met Terry Bradshaw
one time. It was about ten years ago, in front of a movie theater near where I live.
When I was little, Terry Bradshaw was my enemy because, unforgivably to a young boy, he and his Pittsburgh Steelers kept beating
my beloved Dallas Cowboys in Super Bowls. As I grew up, though, his personality on TV talk shows won me over, and I enjoy watching him to this day on Fox NFL (more...)
The fundamental challenge of computer system performance is for your system to have enough power to handle the work you ask it to do.
It sounds really simple, but helping people meet this challenge has been the point of my whole career. It has kept me busy for 26 years, and there’s no end in sight.
Capacity and Workload
Our challenge is the relationship between a computer’s capacity
and its workload
. I think of capacity as (more...)
Today’s Messed-Up App of the Day is the “Crux CCH-01W rear-view camera for select 2007-up Jeep Wrangler models.”
A rear-view camera is an especially good idea in the Jeep Wrangler, because it is very difficult to see behind the vehicle. The rear seat headrests, the wiper motor housing, the spare tire, and the center brake light all conspire to obstruct much of what little view the window had given you to begin with.
I flew home yesterday from Karen’s memorial service
in Jacksonville, on a connecting flight through Charlotte. When I landed in Charlotte, I walked with all my stuff from my JAX arrival gate (D7) to my DFW departure gate (B15). The walk was more stressful than usual because the airport was so crowded.
I set my stuff down at B15, a passenger with expensive clothes and one of those permanent grins established eye contact, (more...)
My friend Karen Morton
passed away on July 23, 2015 after a four-month battle against cancer. You can hear her voice here
I met Karen Morton in February 2002. The day I met her, I knew she was awesome. She told me the story that, as a consultant, she had been doing something that was unheard-of. She guaranteed her clients that if she couldn’t make things on their systems go at least X much faster (more...)
On January 5, I received an email called “Video” from my friend and former employee Guđmundur Jósepsson from Iceland. His friends call him Gummi (rhymes with “who-me”). Gummi is the guy whose name is set in the ridiculous monospace font on page xxiv of Optimizing Oracle Performance
, apparently because O’Reilly’s Linotype Birka font didn’t have the letter eth (đ)
in it. Gummi once modestly teased me that this is what he is best known for. (more...)
In LinkedIn, a new connection asked me a very nice question. He asked, “I know this might sound stupid, but how did you learn so much stuff about Oracle. :)”
Good one. I like the presumption that I know a lot of stuff about Oracle. I suppose that I do, at least about some some aspects of it, although I often feel like I don’t know enough. It occurred to me that answering publicly might (more...)
At last week’s Dallas Oracle Users Group meeting
, an Oracle DBA asked me, “With all the new database alternatives out there today, like all these open source NoSQL databases, would you recommend for us to learn some of those?”
I told him I had a theory about how (more...)
First, I want to thank everyone who responded to my prior blog post and its accompanying survey, where I asked when video is better than a paper
. As I mentioned already in the comment section for that blog post, the results were loud and clear: 53.9% of respondents indicated (more...)
Ok, I’m stuck, and I need your help.
At my company
, we sell software tools
that help Oracle application developers and database administrators see exactly where their code spends their users’ time. I want to publish better information at our web page that will allow people who are interested (more...)
My friend Chester (Chet Justice
in real life; oraclenerd
when he puts his cape on) tweeted
can’t lives on won’t street - i’m sure my son will hate me when he’s older for saying that all the time.
I like it. It reminds me of an article (more...)
One of the biggest problems in software performance today occurs when the people who write software are different from the people who are required to solve the performance problems that their software causes. It works like this:
- Architects design a system and pass the specification off to the developers.
- The (more...)
I gave my two boys an old puzzle to solve yesterday. I told them that I’d give them each $10 if they could solve it for me. It’s one of the ways we do the “allowance” thing around the house sometimes.
Here’s the puzzle. A piece of string is stretched (more...)
If you haven’t seen Gwen Shapira’s article about de-confusing SSD
, I recommend that you read it soon.
One statement stood out as an idea on which I wanted to comment:
If you don’t see significant number of physical reads and sequential read wait events in your AWR report, you (more...)
The first product I ever created after leaving Oracle Corporation in 1999 was a 3-day course about optimizing Oracle performance. The experiences of teaching this course from 2000 through 2003 (heavily revising the material each time I taught it) added up to the knowledge that Jeff Holt and I needed (more...)
What’s the best way to make a presentation on Agile practices? Practice Agile practices.
You could write a presentation “big bang” style, delivering version 1.0 in front of your big audience of 200+ people at Kscope 2011
before anybody has seen it. Of course, if you do it that (more...)