I have an example of paging in some Exadata OS Watcher log files. We got an error in the alert log about a high load but reviewing AWR reports it did not seem like we had an unusual number of active sessions. Also, the CPU use seemed low but the system load was high. Reviewing the OS Watcher logs and finding a similar case on Oracle’s support site convinced me that our (more...)
Every new Oracle Database patch introduces not only documented features, but also undocumented ones. In this short post I would like to provide information about an enhancement of the RESULT_CACHE hint.
According the documentation, the RESULT_CACHE hint has no parameter. But, as of 188.8.131.52, at least the SNAPSHOT parameter is supported. Its purpose is to specify how much time (in seconds) after the creation the result cache entry has to (more...)
This just in from OTN Database Forum – a surprising little bug with “group by elimination” exclusive to 12c.
alter session set nls_date_format='dd-Mon-yyyy hh24:mi:ss'; select /* optimizer_features_enable('184.108.40.206')*/ trunc (ts,'DD') ts1, sum(fieldb) fieldb from ( select ts, max(fieldb) fieldb from ( select trunc(sysdate) - 1/24 ts, 1 fieldb from dual union all select trunc(sysdate) - 2/24 ts, 2 fieldb from dual union all select trunc(sysdate) - 3/24 ts, 3 fieldb from dual union (more...)
Oracle OpenWorld is an annual conference organized by Oracle, which provides Oracle users and technologists a unique opportunity to learn and socialize. Oracle OpenWorld 2014 is scheduled to take place from September 28 – October 2, 2014 in San Francisco. The conference is designed to provide Oracle users a platform to find best suited Oracle […]
You can set and review your Oracke Identity Server setting in the 11g Enterprise Manager console for ODSM by opening the EM console for a server and clicking through to the Identity and Access Server oid1. Once you’re on the EM page for the Oracle Identity Manager, click on Oracle Internet Directory drop-down, then select Administration, then Server Properties. If all is well, you change things like anonymous binds and the LDAP ports. When it’s (more...)
This is going to be a “KISS”, (Keep it Simple, Silly) post. I was offered a second Windows cluster to test on when my original one was required for QA. It was a gracious offer, but I also found out why a cluster should be kept simple and this cluster was anything but simple. Many times, issues are created and we’ll never see them coming until we go through the pain and (more...)
SQL> create table t1
Databases receive much attention so they will not become THE risk factor of IT. Budgeting DRPs, backups, top of the line DBAs – and yet, they still pose a major threat. Why?
In a fast-moving competitive market, if your competitor delivers relevant products, faster and with better quality, you’re eventually going to lose market share. This is exactly why companies need to be agile. They need to have better control over information, make (more...)
This is another guest post from my buddy Nate Fuzi, who performs the same role as me for Violin but is based in the US instead of EMEA. Because he’s an American, Nate believes that “football” is played using your hands and that the ball is actually egg-shaped. This is of course ridiculous, because as the entire rest of the world knows, this is football whereas the game Nate is thinking of is (more...)
Overview only :
Complete prerequisites on target server see my step by step document
Step 2 :
run adpreclone procedure on database tier and application tier
Step 3 :
copy db, apps, inst to target machine and also change ownership
db — database user
apps,inst — appl user
Step 4 :
take rman backup and copy to target machine
Restore database to target machine using rman
change database name
Today’s the first day of school in my city, and the plethora of “OMG 1st day of school!” posts of Facebook and my own kids heading back in to slog through another year of fundamentals got me thinking about education. My own kids (12/daughter and 10/son) came home and went swimming since it was about 104 degrees today…the hottest day of the summer, as it were.
Anyways, after that activity my son decided to (more...)
One response to my series on reading execution plans was an email request asking me to clarify what I meant by the “order of operation” of the lines of an execution plan. Looking through the set of articles I’d written I realised that I hadn’t made any sort of formal declaration of what I meant, all I had was a passing reference in the introduction to part 4; so here’s the explanation.
By “order of operation” (more...)
You can export an LDAP tree for ODSM using the ldifwrite utility with this syntax:
ldifwrite basedn=”dc=oracle,dc=com” ldiffile=$HOME/ldifprod.lst connect=orcl verbose=true
Careful: Lines that start with a space are concatenated into the line before during ldif import. Resist the temptation to unwrap those lines to make your file easier for people to read.
For instance, let’s say this appears in your ldifwrite file:
The SLOB kit comes with a little script that extracts interesting information from the awr.txt file produced at the end of a SLOB test. This is just a quick blog entry to point folks to a patched version of awr_info.sh that works properly with all Oracle Database 11g releases as well as Oracle Database 12c.
Oracle changed AWR format in the 220.127.116.11 and 12c releases so the old awr_info.sh (more...)
Five Reasons to Attend OSCON: Get straight to the epicenter of all things open source and get better at what you do, Learn from (more...)
Last year, I wrote a post on how to setup Oracle Enterprise Manger 12c (18.104.22.168) with Oracle Database 12c (22.214.171.124) and what you could expect. At the time the configuration was not supported by Oracle and I only did it to see if it could be done. If you would like to read that post it can be found here.
This past May (2014), I attended the Oracle Customer (more...)
I'll update this post to provide a link to the recording shortly.
Come back in November for Part 2. Hope to see you then!
This year I’ll be presenting at Oracle Open World with many of the best in the industry. If you are going to be in the San Francisco area between September 28 thru October 2 2014, stop by and check out the conference. Registration information can be found here.
The topics which I’ll be presenting or assisting with this year are:
- OTN RAC Attack – Sunday, September 28, 2014 – 9 am – 3 pm PST (more...)
12c gave us two new features among others: DBMS_UTILITY.EXPAND_SQL_TEXT and temporal validity. DBMS_UTILITY.EXPAND_SQL_TEXT is advertised as a means to expand SQL text that is using views, but it is also very useful to see how Oracle internally rewrites some SQL queries. Here I'm going to use it to see how temporal validity queries are actually executed. All tests are done using 126.96.36.199 Enterprise Edition.
First I'll create a table for (more...)