Feed aggregator

UltraEdit 4.0 has been released for Mac and Linux. The downloads are in the usual place. You can see the latest changelogs here (Mac, Linux).

Fun, fun, fun…

Cheers

Tim…

UltraEdit 4.0 for Mac/Linux… was first posted on May 9, 2013 at 2:25 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}

Today as part of our WebCenter Partners Week, we'll be hearing from across the pond in the UK, where our partner, Extended Content Solutions creates WebCenter Solutions to enhance our customer's experiences.

If you are just joining us today for the first time this week, you'll want to check out the past few days of posts from our partners, TekStream, FishBowl and Lingotek for some interesting reading and video views.

And for any of you WebCenter partners out there that are feeling left out - fear not - there is always room for you at the Oracle WebCenter Blog. We'd love to hear from you and feature your solutions to our readers in upcoming weeks. Contact me directly @ michael.snow@oracle.com  and we'll take care of you.

Extended Content Solutions

Founded in 2000 Extended Content Solutions (ECS) are an Oracle Gold Partner and WebCenter Specialist based in the UK. We pride ourselves on understanding customer requirements and delivering the finest solutions. All our staff are actively encouraged to undertake Oracle specialization training and we have experience in all aspects of Oracle WebCenter including Sites, Portal, Content and bespoke ADF development.

How do you manage your Digital Assets?

ECS produce a number of full product solutions based on the WebCenter platform. One of these is MediaStore which provides Rich Media asset management for enterprises.

MediaStore utilizes the underlying functionality of the WebCenter platform and enhances it with enterprise features such as bulk uploads and approvals, collaboration areas, copyright control, embargoes and integration with Oracle ATG commerce and WebCenter Sites.

MediaStore is being used by a number of organizations in the UK where it has been extremely successful in;

• Reducing transport costs and project time by allowing third parties to share media and collaborate on new designs 
• Enforcing corporate logos and branding
• Reducing storage costs by providing a single repository for all digital assets
• Enhancing digital asset management capabilities of Oracle ATG commerce

MediaStore is available as an online trial just get in touch for details of how to access it. For more information about MediaStore features and customer success stories please see the MediaStore pages on our websites at http://www.extended-content.com/mediastore/.

Other products include Case Management, Scanning and Know Your Client (KYC) solutions all encompassing our unique and accessible user interfaces. For more information please see our website at http://www.extended-content.com

WebCenter for Financial Services

At ECS we recently completed a WebCenter Portal and Content implementation for the UK Fund Manager, CCLA. The results of this project have significantly reduced the time to process transactions, virtually eliminated paper from the processing team and saved costs by providing clear tracking of item status and ownership.

The CCLA implementation uses Oracle Document Capture (ODC) to scan mail items. These are then stored in WebCenter Content where they are indexed and validated including signature checking. Integration with Customer information allows transactions to be posted and reports are generated in Content for sending to Customers. WebCenter Portal is used to provide collaboration areas and dashboard overviews of item processing.

Videos describing the WebCenter implementation at CCLA are available below. 

CCLA Reduce Costs with Oracle Universal Content Management

CCLA Increase Efficiency with Oracle UCM

For more information about the use of WebCenter in CCLA and other case studies take a look at our website at http://www.extended-content.com/about-us/ecs-resources/ or contact us at info@extended-content.com or on +44 (0)1483 688 030.

ATTENTION WEBCENTER INNOVATORS!!!  YOU COULD WIN a FREE Pass to Oracle Open World 2013 in San Francisco!

Oracle WebCenter is part of the Oracle Fusion Middleware product family. So ... if you are you using Oracle Fusion Middleware (Oracle WebCenter) to deliver unique business value? If so, you can win a FREE pass to Oracle OpenWorld 2013 in San Francisco, California by submitting your nomination for the 2013 Oracle Fusion Middleware Innovation. Go to here for more details. Deadline for submission is June 18th, 2013.

12.00 Normal 0 false false false false EN-US X-NONE X-NONE -"/> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-family:"Calibri","sans-serif"; mso-ascii- mso-ascii-theme-font:minor-latin; mso-hansi- mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-ansi-language:EN-GB;}

I have used APEX 4.2.2. I was unable to logon my APEX with INTERNAL workspace as admin. It showed "The account is locked".
What was I able to do? ... run "apxchpwd.sql" script. I didn't think so. After checking in "apxchpwd.sql" script.
So, I checked in "wwv_flow_fnd_user_api" package, I found wwv_flow_fnd_user_api.UNLOCK_ACCOUNT procedure.
PROCEDURE UNLOCK_ACCOUNT
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 P_USER_NAME                    VARCHAR2                INI thought I should test it. First of all, I must to make sure "security_group_id"(It should be number 10).
SQL> SELECT workspace_id FROM apex_workspaces WHERE workspace = 'INTERNAL';

WORKSPACE_ID
------------
          10Tested to unlock "admin" user on "INTERNAL" workspace.
SQL> alter session set current_schema = APEX_040200;

Session altered.

SQL> begin

    wwv_flow_security.g_security_group_id := 10;
    wwv_flow_fnd_user_api.UNLOCK_ACCOUNT('ADMIN');
    commit;end;
/

PL/SQL procedure successfully completed.
then I tested login again... It works for me. ^______________^


Written By: Surachart Opun http://surachartopun.com

Most people worry that taking money advances can have an effect on their credit scores and should conceive to avoid them even once they ar in would like however this is often not the case. Once your credit score is being calculated, any advances that you simply have applied for will not be thought-about. Lenders ne'er use your credit history to work out if you qualify for an advance or not.

Credit coverage agencies do not have any means of knowing whether or not you've got applied for an advance. A majority of individuals ar involved concerning this since the standard loans ar invariably recorded however this doesn't happen with the money advances. The applying method for an advance will not have an effect on your credit score as a result of it's not recorded.

This is one amongst the explanations that build a cash advance applicable after you have to be compelled to pay off your mastercard bills and you are doing not have any money. Whereas advances have higher Annual proportion Rates compared to the credit cards, credit cards do have an impact on your score simply by merely applying for one.

One of the ways in which an advance will have an impact on your history is after you pay the loan in time and this is often recorded in your history as a positive entry. Whereas obtaining an advance might not have an effect on your credit, if you let the debts to accumulate, this may have a negative impact on your credit. This is often as a result of it interferes along with your debt to financial gain magnitude relation. This could be avoided by ensuring that you simply do not use the advances as a method of finance yourself.

Normal 0 false false false EN-US X-NONE X-NONE Adminhttp://www.blogger.com/profile/13903562138108552449noreply@blogger.com0

Cost Based Oracle – Fundamentals (November 2005)

But the most interesting function for our purposes is sys_op_countchg(). Judging from its name, this function is probably counting changes, and the first input parameter is the block ID portion (object_id, relative file number, and block number) of the table’s rowid, so the function is clearly matching our notional description of how the clustering_factor is calculated. But what is that 1 we see as the second parameter?

When I first understood how the clustering_factor was defined, I soon realized that its biggest flaw was that Oracle wasn’t remembering recent history as it walked the index; it only remembered the previous table block so that it could check whether the latest row was in the same table block as last time or in a new table block. So when I saw this function, my first guess (or hope) was that the second parameter was a method of telling Oracle to remember a list of previous block visits as it walked the index.

And finally, Oracle Corp. had implemented an official interface to the second parameter of sys_op_countchg() – provided you install the right patch – through a new table (or schema, or database) preference type available to the dbms_stats.set_table_prefs() procedure.

I’ve been meaning to write this post for two or three months, ever since Sean Molloy sent me an email about short blog note from Martin Decker describing Bug 13262857  Enh: provide some control over DBMS_STATS index clustering factor computation. Unfortunately I’ve not yet had time to investigate the patch, but I don’t think I need to any more because Richard Foote has written it up in his latest blog post.

Read Richard’s post – it’s important.

Update 10th May

Richard’s post has, unsurprisingly, produced a buzz of excitement in his reader – and started up the discussion of how best to use this capability; so here’s another quote from the book (p.111 – available in the download of chapter 5):

So using Oracle’s own function for calculating the clustering_factor, but substituting the freelists value for the table, may be a valid method for correcting some errors in the clustering_factor for indexes on strongly sequenced data. (The same strategy applies if you use multiple freelist groups—but multiply freelists by freelist groups to set the second parameter.)

Can a similar strategy be used to find a modified clustering_factor in other circumstances? I think the answer is a cautious “yes” for tables that are in ASSM tablespaces. Remember that Oracle currently allocates and formats 16 new blocks at a time when using automatic segment space management (even when the extent sizes are very large, apparently). This means that new data will be roughly scattered across groups of 16 blocks, rather than being tightly packed.

Calling Oracle’s sys_op_countchg() function with a parameter of 16 could be enough to produce a reasonable clustering_factor where Oracle currently produces a meaningless one. The value 16 should, however, be used as an upper bound. If your real degree of concurrency is typically less than 16, then your actual degree of concurrency would probably be more appropriate.

Whatever you do when experimenting with this function—don’t simply apply it across the board to all indexes, or even all indexes on a particular table. There will probably be just a handful of critical indexes where it is a good way of telling Oracle a little more of the truth about your system—in other cases you will simply be confusing the issue.

Note particularly the comments about how the best value depends on the data in the indexed columns, the table configuration, and the degree of concurrency - you don’t necessarily want to use the same value for every index on a given table. That’s a shame, since Oracle has defined the interface as a TABLE preference, so if you set it then you get the same for every index. Despite this, if you’re prepared to put in a little control work, it does mean that you can use an official Oracle mechanism to play the game I was suggesting in the book – for each “special” index, set the preference, collect the stats, then clear the preference.

There are certain dictionary views available to monitor the Exadata cells from the database.One of the view is gv$cell_thread_history. This view is very interesting as it delves down to the session level with its serial number, SQL, specific cell, instance and also which Exadata object was waited and every entry is logged with the time. Looks very cool:

SQL> desc gv$cell_thread_history
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------------------------------
 INST_ID                                                        NUMBER
 CELL_NAME                                                      VARCHAR2(1024)
 SNAPSHOT_ID                                                    NUMBER
 SNAPSHOT_TIME                                                  DATE
 THREAD_ID                                                      NUMBER
 JOB_TYPE                                                       VARCHAR2(32)
 WAIT_STATE                                                     VARCHAR2(32)
 WAIT_OBJECT_NAME                                               VARCHAR2(32)
 SQL_ID                                                         VARCHAR2(13)
 DATABASE_ID                                                    NUMBER
 INSTANCE_ID                                                    NUMBER
 SESSION_ID                                                     NUMBER
 SESSION_SERIAL_NUM                                             NUMBER

Here is a sample code snippet:

SQL> select wait_object_name,count(*) cnt from gv$cell_thread_history group by wait_object_name order by cnt;

WAIT_OBJECT_NAME                        CNT
-------------------------------- ----------
UserThread Cond                           4
PredicateDisk-113                         4
bwresv Q_1/2k                             4
bufWaitObjQ_8k                            4
PredicateDiskRead IO Completion           4
bwresv Q_8k                               4
FSA: cache replacementQ_1MHugePa          4
CachePut Fence                            4
NetworkDirectory ReqHandle                4
PredicateCacheGetJob                      4
Flash Cache LRU                           4
FSA: Cache Get Job                        4
DiskDirectory HT                          4
GenTimeStats Operation                    4
in use Q_8k                               4
Completed Map Element List                4
gdisk ext                                 4
FSA: fcCtxt                               8
FSA: cache replacementQ_8k                8
FlashCache HT buckets                     8
PredicateDisk-110                         8
FC outstanding IOs                        8
IOContext                                 8
Cache Completed Jobs                      8
PredicateDisk-32                         12
PredicateDisk-56                         12
PredicateDisk-50                         12
PredicateDisk-22                        12

News and views are an integral part of our modern daily life. When it comes to the information-hungry roles such as database professionals, such need becomes more pressing. Log Buffer is one way to keep abreast of news and views from the world of Oracle, SQL Server, and MySQL.

Oracle:

There is a significant update SLOB 2, Kevin Closson informs.
Charles Hooper is grouping Data Sets by Week Number of the Month.
Chris Antognini has shared a script that is used to demo ITL deadlocks.
As Exadata Storage Indexes (SI) are purely memory only structures located on the Exadata storage servers, care needs to be taken in how much memory they can potentially consume.
Connon McDonald says that its not about the outage, but….

SQL Server:

Richard Douglas is giving information about SQL Server events in UK.
Thomas LaRock has been involved in a virtualization projects for almost ten years now.
Kendra Little has five things about Fillfactor.
Kevin Kline suggests to use TPC database benchmarks to save money.
Here’s a quick mystery. You have a SQL Server with several jobs that appear to be running properly and on schedule, but many of them show no history.

MySQL:

How does InnoDB behave without a Primary Key? Jeremy Cole asks.
The MariaDB project is pleased to announce the immediate availability of the MariaDB Java Client 1.1.2.
Normal 0 false false false EN-US X-NONE X-NONE Everybody loves free. It is the best marketing term one could use.
MySQL Cluster Manager 1.2.3 is now available to download from My Oracle Support.
When is a Subquery Executed?  Øystein Grøvlen writes.

This post appeared at Pythian Blog initially.

Back in mid-March, I wrote:

A week ago, I played a game of Scabble with Veva and scored 32 points by placing the word "SEEN" on the board. Now, every letter in "SEEN" is worth 1 point, making it very difficult to get to 32 points. But I attached "SEEN" to a word on the board (of course!) and I got my 32 points by using a total of 8 letters, two of which were worth 3 points and the other 6 were worth 1 point each.

[Note: I must note a correction. I actually wrote earlier that I had scored 36 points, but I now realize that was an exaggeration, an honest mistake. Honest! It was only 32 points. I would be mortally embarrassed, but please know that when my wife and I play Scrabble, we don't keep score.]

I thought I'd see if anyone could figure out how to do it. It clearly wasn't a very compelling challenge, since no one answered. OK, so now I will reveal the secret!


On my previous turn, I had put down a seven letter word as follows:

That was a whole lot of points, right there, of course. But you expect that with a seven letter word.

On my next turn, however, I put down "SEEN" and now I expect you can figure out how I did it....

Haven't shaved for two weeks. Decided to give my skin a break, and I also wondered: what do I really look like? Shaving my head is, I have come to accept, the "main vain" thing I do in my life (well, that and painting flamboyan flowers on my toenails).

How much gray and white is there? Answer: Lots.

How much is left on top? Answer: Not very much.

When I upgraded from Xubuntu 12.10 to 13.04 today, all my existing Python virtualenvs broke! Fortunately, they're just virtualenvs and easy to replace (that's kind of the point). But don't panic if you start seeing these.

$ ipython
Traceback (most recent call last):
  File "/home/catherine/ve/e2/bin/ipython", line 5, in 
    from pkg_resources import load_entry_point
  File "build/bdist.linux-i686/egg/pkg_resources.py", line 16, in 
  File "/home/catherine/ve/e2/lib/python2.7/re.py", line 105, in 
    import sre_compile
  File "/home/catherine/ve/e2/lib/python2.7/sre_compile.py", line 14, in 
    import sre_parse
  File "/home/catherine/ve/e2/lib/python2.7/sre_parse.py", line 17, in 
    from sre_constants import *
  File "/home/catherine/ve/e2/lib/python2.7/sre_constants.py", line 18, in 
    from _sre import MAXREPEAT
ImportError: cannot import name MAXREPEAT

Apparently Python 2.7.4 introduces _sre.MAXREPEAT. Here it is in my (new) system Python, 2.7.4:

Python 2.7.4 (default, Apr 19 2013, 18:28:01) 
[GCC 4.7.3] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import _sre
>>> _sre.MAXREPEAT
4294967295L 

... but the virtualenvs I created before the upgrade still use Python 2.7.3

Python 2.7.3 (default, Sep 26 2012, 21:51:14) 
[GCC 4.7.2] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import _sre
>>> _sre.MAXREPEAT
Traceback (most recent call last):
  File "", line 1, in 
AttributeError: 'module' object has no attribute 'MAXREPEAT'

If I were a deeper hacker I'd try to figure out why code running within my old virtualenvs is trying to access a 2.7.4-only attribute, or what's the most efficient way to recover my old virtualenvs. But I'll settle for recognizing the problem and spinning up new virtualenvs instead. That fixes the problem.

I know... I could have avoided this problem by using Python 3! I've got code that depends on fabric, though, which still isn't available for 3.

This is a good web site with Oracle internals information:

http://www.ixora.com.au/notes/

I’ve benefited from this one for years.

- Bobby

 

Mothers day is coming up fast. May 12th 2013 is just around the corner and If you have not already done so, make sure you go out and get mom a special gift as soon as possible. If you need a hand picking something great, take a look at this mothers day gift guide by the HuffingtonPost

Many this year like they have in previous years shopped online and bought mom that special gift from an online retailer, a simple, easy and fun process. But is it always? Unfortunately for many, the experience did not live up to expectation due to site performance and both customers and merchants end up losing.

Is this a big deal? We put together this infograph on mothers day shopping. Take a look.

 

A quick request...

If you are using RAW devices for your database (no ASM, no filesystem - just 'raw') - please drop me a line and let me know.  Include the size of  your database as well please.

thanks!

Effective business decision-making has come to depend on real-time access to business intelligence (BI) analytics, which offer firms deep insight into particular processes, customer behaviors or market trends. However, that capability has become a challenge in the face of ever-expanding big data, which many enterprises are looking to overcome. According to industry experts, in order to harness this information for meaningful application, firms need to take a more strategic approach with the support of robust BI solutions and database experts.

A series of reports recently released by Aberdeen studied how corporations are struggling with big data while the demand for fast access to analytics is rapidly accelerating. Nathaniel Rowe, an Aberdeen analyst, argued that firms need to delve more deeply into business metrics and customer desires. He recommended investing in real-time integration tools that can allow companies to rapidly incorporate raw data for analysis, thus fueling faster and higher quality decisions. Rowe revealed that organizations using these tools are able to deliver timely information 89 percent of the time, while this is only possible 73 percent of the time without such tools.

Rowe also suggested that evaluating supplementary integration technologies may be useful, especially since modern IT environments are constantly evolving and becoming more complex. Ideally, he asserted that enterprises should deploy a single skilled professional or team of such experts, such as DBA services, to meet big data needs. According to Rowe, organizations that do so are able to reduce integration costs while sustaining productivity.

Taking a unique approach
Wired contributor Doron Aspitz reported that the majority of legacy BI tools fail to efficiently and accurately interpret big data. Enterprises are bogged down by a multitude of reports, all of which break down data but don't offer actionable insight that can have any kind of impact or concrete results. To create ROI from BI solutions, Aspitz argued that firms need to deploy the most advanced tools and expert advise for analyzing information in a way that fits the business' specific domain. He explained that by doing this, companies can better understand what information specific to the industry is most valuable based on trends and patterns within the market. 

There is no one approach to harnessing big data that can work for all organizations. The most effective BI solutions and experts can not only interpret large stores of data, but also provide context around the information for more relevant events and a more holistic understanding.

RDX's business intelligence and big data experts assist customers in leveraging data contained in large data stores. For more information, please visit our Business Intelligence and Predictive Analytics pages or contact us.

I met with a couple of our fantastic customers in Sao Paulo a couple of weeks ago. I wanted to highlight them in the following blog article.

The first is Telefonica|Vivo. Telefonica SA is a Spain-based company active in the telecommunications and digital services sectors. The Company operates through three business segments: Telefonica Latin America, Tefonica Europa, and Others. It provides public and private telecommunication, media and entertainment services; under such brands as Telefonica, Movistar, O2 and Vivo, among others.

Telefonica is a loyal Oracle customer with many Oracle products in use.

A group of us from Oracle met with Daniel and Jorge from Telefonica and provided us with a tour of their data center. Pictured below is the group from Oracle and Telefonica (from left to right: Selma Snaider and Erivaldo Sousa (Oracle), Jorge and Daniel Soares de Barros (Telefonica), and Lauren Diehl (Oracle). (used with permission)

It was an amazing experience to be provided a tour of their data center. Below is a photo of their operations center along with the build-out of an additional 23,000 sq meter wing for increased capacity. (used with permission)

Many thanks to Daniel and Jorge for the tour. It was fantastic.

My second customer introduction was with Odebrecht. The company consists of diversified businesses catering to engineering and construction, investments in infrastructure and energy, industry, and supporting institutions sectors through its subsidiaries. The company holds expertise in the areas of energy, industrial engineering, infrastructure, oil and gas, real estate developments, environmental engineering, transportation and logistics, defense and technology, chemical and petrochemical, ethanol and sugar production, and investments and holdings, among others. Odebrecht operates along with its subsidiaries in several countries across the Americas, Europe, Middle East and Asia. Odebrecht is headquartered in Salvador, Brazil.

Odebrecht is another loyal Oracle customer with a very large Oracle product footprint.

Our Oracle team met with Alexsandre Bisetto during lunch and sat down in order to talk about current account team successes and related support opportunities.

Thank you Alexsandre for spending time with us.

I thoroughly enjoy getting to meet our customers no matter where I travel. Most of all, l like hearing about how our customers are using Oracle products to run their businesses. It makes me proud to work for a global company helping other global companies like those mentioned, succeed.

Finally, I met with an amazing Oracle team of Support Account Managers and staff (below) at our Sao Paulo office and facilitated a successful workshop. I look forward to my next visit.

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;}

A new major release (version 3.0) of my XPLAN_ASH tool is available for download.

You can download the latest version here.

In addition to many changes to the way the information is presented and many other smaller changes to functionality there is one major new feature: XPLAN_ASH now also supports S-ASH, the free ASH implementation.

If you run XPLAN_ASH in a S-ASH repository owner schema, it will automatically detect that and adjust accordingly.

XPLAN_ASH was tested against the latest stable version of S-ASH (2.3). There are some minor changes required to that S-ASH release in order to function properly with XPLAN_ASH. Most of them will be included in the next S-ASH release as they really are only minor and don't influence the general S-ASH functionality at all.

If you're interested in using XPLAN_ASH with an existing S-ASH installation get in touch with me so I can provide the necessary scripts that apply the necessary changes.

Rather than writing another lengthy blog post about the changes and new features introduced I thought I start a multi-part video tutorial where I explain the purpose of the tool and how to use it based on the new version - some parts of the tutorial will focus on specific functionality of the tool and are therefore probably also quite useful as some kind of general tutorial on that Oracle feature and SQL execution troubleshooting guide in general.

The tutorial will consist of six parts initially, the first two are already available - the next ones to follow over time.

Part 1: Introduction, Overview



Part 2: Usage, Parameters, Invocation



Part 3: Rowsource Statistics: TBD

Part 4: Active Session History: TBD

Part 5: Systematic Parallel Execution Skew Analysis & Troubleshooting: Coming Soon

Part 6: Experimental Stuff, Script Configuration And Internals: TBD

Feel free to post questions/requests for clarification that are not covered in the tutorials in the comments section - if there are topics of general interest I might publish a seventh part addressing those questions.

 In future I might use that video style more often since it's a nicer way of conveying certain kind of information.

We're hitting our midweek stride with our week of Oracle WebCenter Partners. Don't forget to check out TekStream Solutions and FishBowl Solutions from earlier this week. Today, we'll feature one of our global Oracle WebCenter Partners, Lingotek with some great information in their guest post today as well as an upcoming webinar to learn even more.
LINGOTEK Use Case for a Global Company Using Oracle WebCenter  By Calvin Scharffs VP of Marketing @ Lingotek
Challenge With a presence in over 100 companies around the world, the global company needed to equip workers in all locations with customized, localized marketing messages, while providing headquarters with the ability to synchronize messages. The solution should be simple, scalable and cost-effective.   

Solution The global company launched a worldwide web site localization project with Lingotek Inside Oracle WebCenter that enabled the translation and localization of content into 16 languages, with room to scale. 

Benefits Translation and localization now happen in a matter of seconds rather than days. Expected ROI of more than 400 percent as a result of implementing Lingotek’s in-workflow translation technologies.
Managing Global Workflow The global company provides global customers with IT systems that are virtualized, automated, cloud-ready and sustainable. In addition to working with other global companies, the company itself has a presence all over the world, conducting business in more than 100 countries and regions. 

With such a large footprint, the company needed a way to communicate its corporate and product messages in a unified way to different regions. In order to provide its highly regarded storage virtualization services around the world and in many languages, the company needed a simple, cost-effective way to translate its content. 
The translation technology should be able to manage large amounts of data and automate workflows across a centralized system of record. Field workers in each country should have the resources they need in order to market the company’s products and services according to local culture and consumption patterns. The company had to simultaneously provide its corporate team with a centralized way to synchronize global messages. 
In order to accomplish these needs, which were to take place on a massive scale, the company embarked on a worldwide web site localization project. One of the key strategies in this effort was the translation and localization of content. The company wanted to start by translating its content into 16 languages, with the option of more as the company expanded into new countries.
Elaborate International Workflow Needs Professional translation services were not only expensive, but interrupted the company’s rapidly evolving translation workflow. The company produced a continuous stream of content with which translation services had to keep pace. The company content included everything from web site content to social media, and the company’s website content alone changed 50-100 times a month. 

With each new language the company added, its content would double. The company couldn’t afford to wait for professional translators. By the time the translated content arrived, it was already outdated.
Pure machine translation wouldn't work either. The company needed highly accurate translations that could adapt to the specifics of local languages and their unique nuances. It was extremely important to ensure that all contingents were saying the same things in the same ways, despite varying languages. This included ensuring that idioms and metaphors were translated appropriately so that they did not lose their meaning in the switch to a new language.
In-Workflow Translation Generates Real-Time Results The company selected Lingotek’s award-winning translation management system to continuously and automatically translate its global content, in real time. The company, already an Oracle WebCenter customer, benefitted from the fact that Lingotek’s translation platform is embedded in Oracle WebCenter. The company was able to localize its content for each of its global markets without leaving Oracle’s content management system. 


Lingotek enables the company to take advantage of several possible workflows. They are automatic machine translation, community (customer or employee-based) translation and professional translation. Together, these workflows enable seamless multilingual publishing, automatically and in real time. 
Infinite Scaling, Immediate Localization Lingotek’s automation kicks off translation workflow whenever the company’ corporate web site changes. This ensures that the company’ global sites are always synchronized, even though many incremental changes to content take place daily. Lingotek’s automation makes all translation fully scalable. 
In a boon to the company field teams worldwide, Lingotek’s community features allow for local input, localizing content in real time. Thanks to the community component, the company can add new languages without hiring additional people to help translate content. Moreover, Lingotek's interface in the field is extremely easy to use and also enables field teams to edit content as needed to be congruent with local customs. Immediate Quadrupling of ROI

By harnessing Lingotek’s unique ability to engage a community and publish translations in real-time, the company saved significant time and money. The company has empowered its corporate and global branches to reach out to specific audiences and markets with relevant content. The end result is an enhanced bottom line. The company expects a potential ROI of over 400 percent from the implementation of Lingotek's technology.

Join Us for a Webinar to Learn More
5 Steps to Open Your Website to a Global Audience with Oracle WebCenter Sites Wednesday, May 15, 2013 at 1:00 pm EST

Presenting your web content in a single language will limit your success. To build a global brand, businesses need to create a web experience that is accessible in many languages. Calvin Scharffs, Lingotek’s VP of Marketing, will demonstrate how to build a multilingual content presentation using Lingotek’s Global Web Experience Management solution, cloud-based software that utilizes Discovery, Analytics and Automation. Lingotek experts will show you how to manage a multilingual content Oracle WebCenter Sites site, synchronize the site’s content and manage changes in a continuous publishing model.
In this webinar, Calvin will walk you through the five steps needed to produce and maintain a multilingual website, including how to:

• Easily manage your multilingual sites
• Synchronize content and manage changes
• Translate content on the fly
• Use your community to translate
• When needed, professionally translate the content on your site

REGISTER TODAY

<span id="XinhaEditingPostion"></span>

12.00

Back in April 2010, I started up the PL/SQL Challenge (www.plsqlchallenge.com) to provide quizzes on PL/SQL, SQL, logic and Oracle Application Express.

Hundreds of people take these quizzes each day. Since that time, over 670,000 answers have been submitted by thousands of Oracle technologists.

But you can't please everyone. I received this outraged message yesterday regarding the PL/SQL Challenge.:

This was the utmost bad joke on me. Would you be so kind to make clear your statement? My experience on the site was out of the limits of the common sense. No question but a popup nightmare required. Kindly please do something. This site is BAD, BAD, BAD. The worst I have ever seen in overall behavior!

I try not to take such criticism personally, though this did seem a bit harsh.

Well, I asked for clarification. I suggested that maybe the problem lies somewhere in his computer or network.

:-)

Let's see what he says, if he replies.

Believe me, this article is worth reading I’m currently not allowed to discuss Oracle 12c Database goodies but I am allowed to discuss things perhaps initially intended for 12c that are currently available and already back-ported to 11g. This includes a wonderful improvement in the manageability of how the Clustering Factor (CF) of an index can now […]