Search

Top 60 Oracle Blogs

Recent comments

August 2014

Quiz night

Here’s a script to create a table, with index, and collect stats on it. Once I’ve collected stats I’ve checked the execution plan to discover that a hint has been ignored (for a well-known reason):

LinkedIn Anniversary Messages

Thank you to everyone who has sent congratulations messages via LinkedIn, but I think LinkedIn might have mislead you somewhat… :)

When I left a previous job I switched my LinkedIn profile to say I was employed by ORACLE-BASE.com. That was in August 2008. I’ve never changed it since then, so now it says I’ve been “employed” by ORACLE-BASE.com for 6 years, hence the “anniversary”…

I bought my first domain and started putting articles on the net in July 2000. In August 2001 I renamed the site to oracle-base.com, so depending on how you look at it, the site is a little over 14 years old, or 13 with the current name…

Alex Fatkulin's Blog

AZORA Rises Like the Phoenix!

The Arizona Oracle User Group (AZORA) was reincarnated Tuesday July 29 by a group of six Oracle specialists interested in focusing the Oracle User Community in Arizona. A board was elected and began review of the organization bylaws (dated 1990) to be completed and presented at AZORA’s inaugural Educational Workshop tentatively scheduled for October. The new board includes: President, John King (King Training Resources); Vice-President Danny Carrizosa (OneNeck IT Solutions), Treasurer, Raj Chotalla (Intel), Secretary, Carlos Aquilar (GoNet USA), and Past-President Stephen Andert (IBM). Two of AZORA’s past presidents Steve Lemme (Oracle) and Stephen Andert (IBM)  are actively involved and lending their experiences and expertise. Visit the “AZORA – Arizona Oracle User Group” LinkedIn page to learn more.

Exciting Oracle Developments

The summer has brought us a new version of Oracle’s flagship database and the Introduction of Oracle Mobile Application Framework. Both, truly big news.

Oracle 12c 12.1.0.2 was released in July! This is a full release and includes many new features including:

  • In-Memory Database
  • Big Data SQL
  • JSON Support
  • RESTful Data Services
  • Improved Index Compression
  • Zone Maps
  • Attribute Clustering
  • Full Database Caching
  • Enhanced Multi-Tenant Features
  • Rapid Home Provisioning
  • Approximate Count Distinct

For complete documentation; see Oracle’s web site: http://docs.oracle.com/database/121/NEWFT/chapter12102.htm#NEWFT003

Who deserves the title “Expert” or (even worse) “Guru”?

I wanted to expand on a thread in a LinkedIn group I’m part of, where one of the members wrote “It’s funny when 2 experts are arguing about who is better”, using Tom Kyte and Jonathan Lewis as examples of people they say are “Experts”.

Disclaimer: I have not spoken to Jonathan or Tom in regard to their viewpoints on this subject, so this shouldn’t be taken as them saying any of this, just my interpretation.

My perspective on that is I think you will rarely find two people who deserve the title of “Expert” will argue about “who is better”.  They would discuss the technical merits of a point instead.  In fact, most people I know that are generally accepted as “experts” really don’t believe they are, and most of them REALLY don’t like the term “Guru”.

Multitenant : PDB CONTAINERS Clause

I forgot to mention, I put another multitenant article live at the weekend.

I’m not sure I will ever use it, but it’s good to know it’s there.

I was originally working on an article on a completely different multitenant feature, but the examples I was using highlighted a bug, which kind-of scuppered that article. I’ve raised an SR and I’m waiting on the acknowledgement and possible fix. I’ll hold that article back until the fix is in place.

Cheers

Tim…

New Tips and Techniques page

In case you haven’t noticed it – and chances are you haven’t noticed because I just created it! :) – I’ve added a new page called “Tips and Techniques” to the website. It’s where I keep a random collection of odd items I’ve come across that might be of interest yet don’t deserve a full blog post. It’s sort of like a FAQ list, but not necessarily with the “F”. :)

You can reach it either via the link I’ve just given, or from the menu on the top of each page. I’ve only created a couple of entries so far, but will slowly add to that page as time goes on. Hope you find the tips and techniques of some use!

LOB Length

It’s funny how you can make little savings in work all over the place in Oracle if you’re prepared to look a little closely at what’s going on. Here’s a quirky little example with LOBs and function calls that might just have some greater relevance in other situations. Here’s a little data set, and two queries that I might run against it:

Zone Map Zone ID's

Just a quick follow up to my previous post on how Zone ID's are calculated.

Let's take the following example:

SQL> select rid, sys_op_zone_id(rid) zone_id
2 from
3 (
4 select chartorowid('AAAS5KAAHAAABYDAAA') rid
5 from dual
6 );

RID ZONE_ID
------------------ ------------