Every …. single …. time….
Why does index monitoring make me scratch my head and charge off to google so many times…Well, I’m over it, so time to put it on my blog (even though its already on many other places) so I do not get caught out anymore :-)
It always starts like this:
- Turn on index monitoring on some indexes
- Come back later, and get ready to check on my results
I saw a load of 44 on a node of our production Exadata and it worried me. The AWR report looks like this:
CPUs Begin End %User %System %WIO %Idle
----- --------- --------- --------- --------- --------- ---------
16 10.66 44.73 68.3 4.3 0.0 26.8
So, why is the load average 44 and yet the CPU is 26% idle?
I started looking at ASH data and (more...)
(the first part can be found here)
Now let’s consider command line. There is a lot of things that can be done to improve user experience here as well.
1) Maintain a local script repository on the machine(s) you’re using the most. To make sqlplus search there, define SQLPATH variable (using Control Panel => System => Advanced => Environment variables on Windows, or shell initialization scripts such as .profile or .bash_profile on Unix).
Most of my servers tend to be Linux VMs on VMware ESX without any graphics desktops setup, so it can be disconcerting trying to install Oralce with it’s graphical “runInstaller” being the gate way we have to cross to achieve installation. Of course there is the silent install, but to do that requires knowing all the secret handshake responses to make the silent installer work. Often the easiest way to get a response file is to (more...)
This week I participated (online option) in HotSOS conference — the only conference that is focused entirely around Oracle database performance and internals. Like a year ago, it was a great conference, I really enjoyed it. Predictably, the number one topic was the in-memory option. Probably every third talk was about it. I learned a lot of stuff I didn’t know before (and I strongly suspect that this stuff wouldn’t be easy to find anywhere else).
It only works in version 12 :( That’s right, I didn’t test in previous versions and there was a bug. Please refer to the COMPARE_SYNC post for the new, improved version. Here is what I changed: The name is now COMPARE_SYNC. I don’t know what got into me to put those four meaningless letters in front. The […]
If a column or expression may be NULL, it is a pain to compare it to something else. Why? Because comparisons involving a NULL do not result in TRUE or FALSE: they result in NULL. I use the DECODE function to work around this problem: here's why - and how.
“Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in February 2015. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use… Publish Date TidBit 2-Feb #oratidbit […]
EM agents can end up in several different error states and each of them have their own error image. This one popped up in my environment this morning on one agent and all of its targets:
A bounce counter mismatch (represented by the ‘N’ in the icon?) occurs when the agent has been restored from a backup on the remote host. The agent is trying to upload metric data from timestampX but the repository contains (more...)
Looks like the nice PL/SQL facility for returning a set of updated rows is restricted when it comes to database links
(This tested on 188.8.131.52)
2 type int_list is table of number(12) index by pls_integer;
3 l_results int_list;
6 update MY_TABLE b
7 set b.my_col = ( select max(last_ddl_time) from user_objects@dblink where object_id = b.key_col)
8 where b.my_col is null
9 returning b. (more...)
We still use database authentication for our OEM Administrator accounts. Every once a while (like today) that list needs to be reviewed to evaluate contract employees and others that may have changed jobs. We use the USER_DESCRIPTION field to store people’s names in OEM so we poll the user_name and its description.
Here’s a simple query, run as SYSMAN user, that creates a list for you in SQL+
COL user_name FORMAT a20
COL user_description FORMAT a35 (more...)
Last year, I spent some time researching redo log related performance problems, which resulted in a mini-series, including one post devoted specifically to one previously unknown scenario of excessive log file sync waits.
I am happy to announce that a service request opened on the back of this research resulted in the MOS note on “log file parallel write” wait event (Doc ID 34583.1) having been updated with a general description of this scenario (more...)
While try to configure Backup exec agent in database server
“No Oracle instances were discovered do you want to enter one”
add the instance value in /etc/oratab
Does anyone know of any good contracts that would support mostly remote work?
I started this blog years ago with the idea that it would be a good place to search for work should I ever need it. I think the time has come to just ask to see if projects are available through this avenue. If you know of anything, I would love to speak with you. Would you mind commenting below or sending (more...)
photo by youflavio
In a recent blog post Eric D. Brown defined an Agile Data Center as
An Agile Data Center is one that allows organizations to efficiently and effectively add, remove and change services at the speed of the business, not the speed of technology - Eric D. Brown
In follow up post he said that a Agile Data Center could be implemented by Software Defined Data Center (SDDC) for example using machine (more...)
This is a reposting of an old blog post that was on dboptimizer.com but is no longer accessible
More trace file analyzer tools at http://ba6.us/node/177
Related blog post: Oracle “Physical I/O” ? not always physical
Often when I have a 10046 trace file, especially when looking at I/O issues, I want a histogram of I/O response time. To get I/O response time I’ve hacked out incomple awk scripts from time to time, (more...)
Create an army of clone databases and applications in minutes
Tomorrow Jan 28 we will be installing Delphix on people’s laptops at the BIWA conference at Oracle conference center at Oracle head quarters in Redwood Shores.
- Laptop, either
- Mac: VMware Fusion or VirtualBox
- Linux: VMware Fusion or VirtualBox
- Windows: VMware Workstation or VirtualBox
- at least 8 GB RAM
- at least 50 GB free disk space, but preferably 100 GB free
- at least 2 Ghz CPU, (more...)
Photo by Kevin Dooley
If you are in the Bay Area tomorrow, Jan 27, come see myself, Yann Ropars and Yury Velikanov talk about how to leverage social media to boost your career. We will be talking at Oracle head quarters at the NoCOUG/BIWA conference at 2:30 pm
Why use social media as an IT technician? Because
vibrant social networks are key to landing jobs, moving forward in your career, and securing personal happiness – (more...)
I often train experienced developers in new tools, and I’ve found that most underestimate what they can do – their actual skill level is higher than their own perceived skill level.
This is different from new developers, who tend to overestimate their skills.
The reason this happens to most experienced people is the “loss of control” feeling overcomes the feeling of accomplishment. If you are very skilled with one tool, you are acutely aware that (more...)