Today I attented Austrian Oracle User Group event on 15th Oct in Vienna with Christian Antognini and Tanel Poder.
It was interesting to hear both experts, for me Tanel’s “Advanced Oracle Troubleshooting” was more exciting cause he provided really cool way how to troubleshoot Oracle database when session hangs and we need to know way…
In short conversation with Tanel I saw in him really great person with impressive Oracle knowleadge.
So finally I migrated public blog 
Hope I will find time soon for posting…
Thanks to Damir aka “Funky” from Zagreb to ask me for this blog!
As I said him, I’m trying to get space for one XE instance on provider server…
In XE sholud be enough space for my new blog 
… something in style of AskTom ))
…consulting related….
Yesterday at OTN appear link for download of Oracle 11g for Linux (1.7 GB). Release Build is 11.1.0.6.0. Regarding sources close to Oracle, Windows version of 11g coming in next weeks.
In one thread in Forum there was following post:
“It is not only available on Linux platform, you can get it in Windows too if you have access to the Oracle Intranet.”
Begining of this August was very intensive and I found myself in position of having no time for free activities like this blog.
Anyway lot of work is the best way to prepare myself for meeting with the Notre Dame in next weeks.
It’s been a busy week. I didn’t have free time to work with WebCenter seriously, but soon is vacation ….
Speaking of which, we are leaving for France in second half of August. We’ll be there for about two weeks and we searching at the moment a home-swap. A family from Paris can stay in our home in Vienna. If we can wish a place then that will be Fontenay suis Bois, a suburb of Paris, and very close to some friends, which will be nice.
Well, if some of you are interested for home-swap (Vienna-Paris), please contact me by email.
Today with 25.8 °C (78.4 °F) weather is again “normal”. I back to usual activities …
With WebCenter Oracle trying to integrating composite applications and Web 2.0 into the Enterprise. That should be next generation of human interaction!
Increased focus on information workers demands a new approach to user interaction. Current solutions which going in that direction don’t work really:
- Portals do not go far enough
- Collaboration and Content Management are not comprehensive
- Rich-Client Development frameworks need enhancements
- Feeble attempts to empower business users
Challenges which are connected with Web 2.0:
Need task-oriented user interaction
• Simple task should be simple and consistent
• Composite tasks need to preserve context
Need information and services in context
• All contextual information integrated
• Including documents, BI, BAM, and processes
Need to work together effectively
• Person-to-person
• As a group
Need to work anywhere
• Multi-mode
• Multi-channel
Need to simplify the user experience
• Preserve familiarity of tools
• Give them a choice
Need to empower the business user
• Tailoring applications as business evolves
So, I just installed WebCenter delivered on DVD from Oracle and first reports on previous list of challenges coming soon.
Well, we have here in Vienna fourth day 39°C (102°F) temperature.
Only place where was/is possible to feel fine is if you are near to the river Danube. Not that I don’t like air-conditioned rooms, but I’m doing this blog freebie, so I will always avoid such activity when outside is such a weather that you have something like Santa Monica Beach in the Middle of Europe …
Some of you asked when will appear 11g?
Well, it’s almost happen! Oracle Database 11g Launch is on Wednesday, 11th July at 16.00 h SWET.
You can watch a live this happening here:
http://www.oracle.com/pls/ebn/live_viewer.main?p_direct=yes&p_shows_id=5717957
* SWET = Summer Western European Time (GMT + 2 hours)
One of most interesting person from Oracle Corporation at the Conference, I found Bryn Llewellyn and his session about PL/SQL performance.
Bryn compared in tests Oracle 9i R2 and 10g R1. Oracle Database 10g brings a brand-new optimizing PL/SQL compiler and a newly tuned PL/SQL execution environment. Result is dramatic performance improvements.
PL/SQL computational programs should run at least twice as fast as they did in Oracle9i Database Release 2.
This, in turn, is about 1.5 times as fast as Oracle8 Database!
The optimizing compiler changes the way programmers should think about traditional hand optimizations. The significantly improved PVM increases the speed of underlying operations
like the addressing of collection elements and eliminates some historical asymmetries…
Bryn expalind to us in detail his “Clean Room” Experiment. In short:
1. Startup the database on otherwise quiet machine
2. Run the test once to warm up
3. Run it again and time it (Dbms_Utility.Get_Time)
4. Shutdown the database
5. Record the results elsewhere for later analysis
6. Time each test many times
The most important advices for PL/SQL developers regarding results of test are:
1. Now you needn’t care for expression inside a loop if it remains constant over all iterations of the loop
2. Using CONSTANT in 10g helps performance, so be careful to use CONSTANT when you can
3. There’s no significant performance penalty if you break a complicated big expression into pieces for readability
4. There’s no performance penalty if you declare variables, types and procedures deep inside nested loops for readability
5. Use hand-optimization to avoid referring to a collection element within a loop when its address remains constant over all iterations is no more good advice.
6. Regarding Callbacks: Sometimes, when you write “library” code for re-use, you need it to be able to call a procedure with a fixed parameter signature that your customer will write. Since you don’t know its name when you compile your code, you have to use the usual approach for such situations: dynamic SQL. However, because this is slow and because there’s a risk of runtime error that you’d prefer to catch at compile time, you should try to find a radically different approach to give your customer the required extensibility hook. So we have to use dynamic SQL to implement a callback.
Dynamic polymorphism, a.k.a. virtual procedure call, is the natural way to implement a callback. It’s quick and it also allows compile time checking and the normal benefits of cascading invalidation. You absolutely do not have to usedynamic SQL.
This will cost you hugely in call overhead was true before 9iR1 – things have changed: polymorphism helps performance!
7. Dynamic SQL versus static SQL:
- Dbms_Sql is never the winner. Use NDS.
- NDS single-row was slower than static single-row in 9iR2 but they’re similar in 10gR1 because of cursor reuse.
- NDS and static SQL were similar for the nonbulk case in 9iR2 but static leaps ahead in 10gR1 because the PL/SQL optimizing compiler bulkifies it.
- NDS and static SQL are similar for the bulk case
Neither static SQL nor native dynamic SQL avoid soft parse when using a REF CURSOR.
New in 10gR1 was that native dynamic SQL avoids soft parse when not using a REF CURSOR.
For single row select and for bulk syntax, native dynamic SQL is therefore now about as fast as static SQL.
