Editor’s note: Another cross-post from VoX, this one from Julian Orr. User experience works best when you understand your users. So, help us understand you and your mobile strategy by completing this painless and fun questionnaire. What is your perspective on enterprise mobility? Tell us! By Julian Orr, Oracle Applications User Experience Is there a […]
Category Archives: Uncategorized
Here are the slides of some of my previous presentations (that I haven’t made public yet, other than delivering these at conferences and training sessions): Scripts and Tools That Make Your Life Easier and Help to Troubleshoot Better: I delivered this presentation at the Hotsos Symposium Training Day in year 2010: Troubleshooting Complex Performance […]
It’s interesting how from time to time something happens that makes sense and seems logical afterwards, but at the time it causes a bit of a surprise. Part of the fun of working with this type of software!
A few days ago we had an incident in an Oracle DW database when a developer tried to load an infinitely big file from a very large source. Yeah, you got it: big-data-ish!
Suffice to say:
After a Tanel Poder pointed out to me that someone had blogged my article verbatim, which I don’t really care about, but they had copied the article verbatim without crediting me, which I do care about, I decided I’d just re-blog this. The article is best formatted at link:http://tinyurl.com/ybyjazq ——— Waits on the cache buffer chains […]
Bobby Durrett just put together a great little post on “outer joins : where do I put the (+)“. I also have hard time remembering, and below is my cheat sheet using graphics. If English and French both have a unique key on the “ordinal_id” then it’s basically one-to-one relationship We add an arrow in […]
On Exadata (or when setting cell_offload_plan_display = always on non-Exadata) you may see the storage() predicate in addition to the usual access() and filter() predicates in an execution plan: SQL> SELECT * FROM dual WHERE dummy = ‘X’; D – X Check the plan: SQL> @x Display execution plan for last statement for this session […]
Another day, another airport lounge – another quick note: one of the changes that appeared in 12c was a tweak to the “broadcast” distribution option of parallel queries. I mentioned this in a footnote to a longer article a couple of months ago; this note simply expands on that brief comment with an example. We’ll […]
As Connor pointed out in his comment on the last post, Incremental Statistics might still turn out to be a bit trickier than you thought once you start using them on many or very large tables, even once you’ve got the basics right.
Which is why there’s still a place for the detailed technical blog posts, once you’ve got the basics clear. The problem with not having the basics clear is that I’ve had people tell me things about Incremental Stats based on the blog posts and, when I read them, they make sense to me but I can also see why they might confuse others. Anyway, for completeness, here are some terrific posts about Incremental Stats.
Read blogs, by all means, but maybe start off with White Papers and the documentation and full presentations?
I just saw a link to a post by Steve Karam on an ISACA list and went for a look. The post is titled ” Password Verification Security Loophole “. This is an interesting post discussing the fact that ALTER….[Read More] Posted by Pete On 22/07/13 A…
There has been some big new security items added to 12cR1 such as SHA2 in DBMS_CRYPTO, code based security in PL/SQL, Data Redaction, unified audit or even privilege analysis but also as I hinted in some previous blogs there are….[Read More] Pos…