n number := ....;
tmp := n - ( bitand ((n / 2) ,3681400539))
- (bitand ((n / 4) ,1227133513));
tmp := mod ( bitand ((tmp + (tmp / 8)) , 3340530119) , 63 );
Google for "hakmem" to see how it (more...)
The role of IT in big data enterprises is changing as information technologies continue to evolve. As corporations expand, their production rates also increase. As such, decision-makers will need to make adjustments to their daily operations to accommodate this growth. If organizations fail to change the way they handle this (more...)
This is a very short post to demonstrate how to upgrade to Oracle Linux 6.5. My lab system was reasonably current, Oracle Linux 6.4 with some security patches (but not all). The upgrade to 6.5 (or “latest”) is very simple, and since Oracle announced they had beefed (more...)
As this is a blog on the technical aspects of the Oracle RDBMS and management in IT, it is not really the correct place to pass comment on the passing of a political figure, let alone touch on the politics of race and discrimination.
But I don’t care, it’s my (more...)
Another busy day at the Manchester Central complex. An early start with Martin Nash talking about RAC connectivity issues and bugettes. Very interesting but I don’t think my brain was fully in gear at 08:30 after a big hotel breakfast.
Straight into another two-man CERN presentation on Lost Writes. The (more...)
A user complained about ORA-00018 errors when trying to connect to an Oracle 11.1 database from PL/SQL Developer. I checked in the alert log and saw the following message several times:
Mon Nov 25 10:11:35 2013
Errors in file /oracle/app/oracle/product/diag/rdbms/nbacog3/NBACOG3/trace/NBACOG3_m001_11242.trc:
ORA-00018: maximum number of sessions exceeded
Cloud security is a topic of concern among enterprise decision-makers, but as this storage structure adapts to the needs of corporations, the conversation is becoming more positive. For instance, rather than accusing cloud providers of allowing data breaches to occur, IT experts are beginning to question the distribution of responsibility. (more...)
With cloud services, one primary goal is increased cost efficiency. As this storage strategy continues to evolve, decision-makers are being presented with new features that make leveraging the cloud easier and more customizable. According to eWeek, as more options are introduced to the market, competition between cloud providers is expected (more...)
Exadata Maximum Availability Architecture from Yunus Emre Baransel
7 gb shared pool with over 60 thousand different sql statements ...
This week I am reviewing my accomplishments for 2013 and thinking of possible goals for 2014 in preparation for my annual performance review. After reviewing my notes about what I did this year and brainstorming about what I want to do next year I thought of four categories to (more...)
Just a quick code snippit. I do a lot of data pumps to move schemas between different databases; for example taking a copy of a schema to an internal database to try to reproduce a problem. Some of these schemas have some very large tables. The large tables aren’t always (more...)
Yesterday, during the talk “The Query Optimizer in Oracle Database 12c – What’s New?” at OakTable World UK 2013, an attendee asked me an interesting question that can be summarized as follows: does ASH show the switch of execution plan that takes place for an adaptive plan?
Top 5 Key Reasons Why Oracle VM is Best for Oracle Database When: Tuesday December 17th , 10am PST Register Here: http://event.on24.com/r.htm?e=725350&s=1&k=1512E332202610FE9518AB8B01354C6A&partnerref=Francisco Oracle VM application-driven architecture is designed for rapid deployment and ease of lifecycle management providing IT a highly scalable and cost effective virtualization solution for Oracle (more...)
When I started out as an Oracle DBA on Oracle 7.3, nearly everyone would tell you to avoid doing a "shutdown abort" if at all possible since it leaves the database open to possible corruptions. In the years and versions since, that thinking has softened greatly, to the point (more...)
As cloud providers create new features for enterprise infrastructures, more big data companies are beginning to consider how their digital architectures could be improved by leveraging one of these options. The widespread description of the cloud is also evolving, but according to ZDNet, what the media portrays the cloud to (more...)
Yesterday I did my UKOUG Tech13 presentation “Best Practices for Installing Oracle Fusion Middleware Products”. You can download it here.
I have not done any conference presentations since 2007, so I was a bit nervous
It did not go perfect, but after a little bit, I warmed up and it (more...)
A couple of years ago I left the warmth and comfort of the database world and joined the storage industry – a harsh unrelenting world full of cut-throat competition and vendor rivalries, where marketing is treated less as a way of communicating with customers and more as a form of (more...)
UKOUG conference day 2 opened up with Tom Kyte talking about 5 PL/SQL things you probably didn’t know. It did have 12c in the title but I think 4 out of the 5 were pre 12C. Implicit conversions are EVIL is my main take-away and he made me aware of (more...)