msgbartop
News, views, tips and tricks on Oracle and other fun stuff
msgbarbottom

Oracle Magazine PL/SQL Columns by Steven Feuerstein, the Whole List ↗

Dating back to January 2003.

Comments Off | Filed in Oracle | Tags:


Traditional Programming Language Job Trends ↗

Robert Diana:

Unsurprisingly, Objective-C has the most growth, but the growth has slowed since our last update. C# growth is solid, hovering around 100% for the past 3 years. Visual Basic and C++ continue to decline. Perl and Java are still showing signs of life, but the growth is not very significant. What does all this mean? First, it is clear the iOS development is hot as is all mobile development. However, mobile development does not seem to be affecting Java or the growth of mobile is offsetting the decline of Java in the enterprise space. Why does Java and some of the others show relative growth, but not strong growth in the trend graphs? Basically, we are seeing that while some of the languages are still showing increasing job postings the relative growth chart, the percentage of postings is less than before. So, other languages not in this list may be increasing in demand quicker than these traditional languages.
Comments Off | Filed in Technology | Tags: ,


The History of the @ Symbol ↗

William F. Allman, Smithsonian magazine:

Tomlinson’s eyes fell on @, poised above “P” on his Model 33 teletype. “I was mostly looking for a symbol that wasn’t used much,” he told Smithsonian. “And there weren’t a lot of options—an exclamation point or a comma. I could have used an equal sign, but that wouldn’t have made much sense.” Tomlinson chose @—”probably saving it from going the way of the ‘cent’ sign on computer keyboards,” he says. Using his naming system, he sent himself an e-mail, which traveled from one teletype in his room, through Arpanet, and back to a different teletype in his room.
Comments Off | Filed in Interesting


Interesting Things You May Have Missed on August 20, 2012

Comments Off | Filed in Links


Handy Oracle EBS Trading Community Architecture (TCA) Diagram ↗

Via Puneet Rajkumar.

Comments Off | Filed in Oracle | Tags:


Extended SQL Trace (Event 10046) Full List of Levels ↗

Christian Antognini published a handy list of currently available levels.

Comments Off | Filed in Oracle | Tags:


Delete Column Histograms to Improve SQL Plan Stability ↗

Carlos Sierra:

If you are on 10g, or if on 11g but ACS (Adaptive Cursor Sharing) is not an option, then deleting column Histograms may be your best option to improve your plan stability. Like any other change, you rather test first on a non-production environment. Even in such test environment, you may want to restrict your test to only those tables accessed by your SQL. On 11g, DBMS_STATS.DELETE_COLUMN_STATS provides an option to delete just the Histograms while preserving all other column statistics. This is by using parameter COL_STAT_TYPE with value HISTOGRAM. If you want to do the same on 10g, you may want to use the SQLT HGRM module. In any case you can always restore column statistics using DBMS_STATS.RESTORE_TABLE_STATS.

Carlos gives us a tip on how to disable the use of Histograms with a hidden parameter:

If you are considering deleting Histograms to test the effect on an execution plan and the performance of your SQL, you may want to test first asking the CBO to simply ignore them. If patch for bug 9550277 has been applied in your system then you can command below.
ALTER SESSION SET “_FIX_CONTROL”=’9550277:1′;

Worth noting that Jonathan Lewis was very successful in tuning a customer’s query by simply deleting histograms:

The most critical piece of advice I had given them was to get rid of ALL the histograms they had on their system, and then watch very carefully for any signs that they might need to re-introduce a handful of histograms over the next few weeks. One of their critical queries completed in less that 2 seconds when histograms were removed, but took 33 seconds to complete when histograms were in place.
Comments Off | Filed in Oracle | Tags:


Interesting Things You May Have Missed on August 9, 2012

Comments Off | Filed in Links


Interesting Things You May Have Missed on August 8, 2012

Comments Off | Filed in Links


Interesting Things You May Have Missed on August 7, 2012

Comments Off | Filed in Links