When Something Is Simple It Must Be Simple To Prove
Provisioning high-performance storage has always been a chore. Care and concern over spindle count, RAID type, RAID attributes, number of controller arms involved and a long list of other complexities have burdened storage administrators. Some of these troubles were mitigated by the advent of Automatic Storage Management–but not entirely.
Wouldn’t it be nice if the complexity of storage provisioning could be boiled down to but (more...)
I joined twitter. I don’t really know how to use it. I’m setup as Bobby Durrett, @bobbydurrettdba if that means anything to you.
I’m really looking forward to speak at the Oracle User Group Norway Spring Seminar 2015, together with my dear colleague Joel Goodman! For sure it’s one of the highlights this year in terms of Oracle Events.
Joel will present about Oracle Automatic Parallel Execution on MAR-12, 6pm and about Oracle 12c Automatic Data Optimization and Heat Map on MAR-13, 9:30am
Yours sincerely will talk about The Data Guard Broker – Why it is recommended on (more...)
Get Access Manager 11gRel2 PS2 installed in a day
Goal is to get OAM installed and configured in a day - with full control; that is without using the Installation Wizard.
Start with Virtual Box. Allow plenty of memory (10GB), and disk (120GB).
Attach V33411-01.iso (Oracle Server V6.3) to the CD, and boot.
Minimal (not Basic server!) install, configure network with static IP
I wouldn’t believe the bad XMLType performance statement given stated in Martin Preiss’ blog post,…
This is a quick post on issues I faced while restoring a slave when GTID was enabled on master.
I have master created few days back and now I am trying to create a slave. I have GTID enabled on master.
root [mysql] >show master status G
*************************** 1. row ***************************
1 row in set (0.00 sec)
root [mysql] >show (more...)
Last week, I was letting you know about an opportunity to hear all about the Snap Clone functionality with EMC storage. This week, there’s a similar presentation on Wednesday, March 4 at 8AM PT (San Francisco), 11AM ET (New York), 4PM GMT (London) and 5PM CET (Paris), only this time we’re discussing Snap Clone with NetApp storage instead.
To register, go to this link.
At the end of last week I was contacted by the UKOUG who asked me if I would agree to be on the planning committee for the annual technical conference this year – Tech15. Not only that but I was privileged to be asked to repeat my role from Tech14 and be the Lead for the Database area. I am of course happy to do so.
Why do I mention this? Well, this year I (more...)
12c introduces the concurrent UNION ALL
operator that allows multiple branches below the UNION ALL to become active concurrently - which is a significant change. Before the introduction of this feature Oracle never executed multiple branches of an execution plan concurrently (in terms of Parallel Execution) - the parallelism so far was about executing the same operations of a particular branch of the execution plan by multiple processes / sessions. When we later look at (more...)
The 2nd of March 2015 was my first day as part of the Accenture Enkitec Group.
When I first started using Exadata back in 2011, the one thing I relied on more than anything else to get me up to speed was the original Expert Oracle Exadata book by Kerry Osborne, Randy Johnson, and Tanel Poder. I am equally sure the 2nd Edition will prove just as valuable.
I have thoroughly enjoyed my (more...)
I ran this test in Oracle 12.1. First I created a table, added some data to it and made sure that the bytes column was set to zero in every row:
SQL> conn system/manager
SQL> alter session set optimizer_mode = first_rows
SQL> create table t1
2 tablespace users
3 as select segment_name, bytes
4 from dba_segments
I mentioned this same effect in an earlier post about SQL profiles: link
I get a different plan_hash_value values for a query each time I run an explain plan or run the query. I see this in queries whose plan includes a system generated temporary segment like this:
| 1 | TEMP TABLE TRANSFORMATION | |
| 72 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D668C_764DD84C |
For some reason the system generated temporary table (more...)
The mother of all SQL “anti-patterns” is the ad-hoc query. Here, the end-user of the application can specify any combination of parameters—for example, the job_id, the dept_id, or a combination of both—and the data is retrieved using a catchall query. This antipattern has two sisters who are almost as evil. These two sisters arise from the requirement to paginate through the records retrieved by a query.(read more
“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 […]
Let me first confess. I don’t have double-digit years of experience in IT Capacity Management. But I would say, during last 9 years I have defined the process multiple times from scratch. I have seen capacity management process getting traction. Multiple times I was part of the journey where the process got matured from chaotic to efficient. I have also witnessed cases where management couldn’t justify the investment in the process and it got a (more...)