Development

OOW2008 day 4 – HP-Oracle Exadata Server Announcement = Extreme Performance

Pawel Barut - Wed, 2008-09-24 18:25
Written by Paweł Barut
Today is very busy day for me. It’s just after Larry Ellison keynote on which first Oracle Hardware was presented. I’m a little big skeptic if Oracle is realy going for hardware business. It is rather that Oracle had great idea how to solve problems with really big databases and growing demand for storage, and joined forces with HP to create new quality in data processing. So, how it looks: in one box we have 2 intel 4 core processors and 12 disks as storage – it is called The Exadata Programmable Storage Server. This machine is not storage, and is not pure DB Server as well. It can process queries (so it is DB), and it stores Data (so it is Storage). But it needs separate DB Server to work at full performance. How it works: DB Servers receives request for data. It then retries data from Exadata Storage Server, but data get initially filtered, so number of data transferred from Storage Server to DB Server is reduced. It allows much better overall performance.
At least this is my understanding. I will go also to DemoGround to get direct look at this machine, and more detailed specification.

Today I’ve also participated in few sessions.
Soup-to-Nuts RAD Development Using Oracle SQL Developer and Oracle Application Express It was quick show how to create simple application using APEX and SQL Developer. It focused on modeling capabilities of SQL Dev, and integration between APEX and SQL Dev. It was shown, how to view APEX objects in SQL Dev, and how to leverage this integration. There was also presentation of new functionality in APEX to migrate Oracle Forms to APEX.

Agile Database Testing Techniques (IOUG) This was very interesting session giving practical inside on how to organize unit tests in DB, how to validate that upgrade scripts run successfully, and how to prepare DB environment for Daily Builds. Presenter shared his real world experience and this was the biggest value of this session.

SQL Tuning Roundtable with the Experts This one was rather boring, as topics and answers were almost exactly the same as on session “Inside Oracle Database 11g Optimizer: Removing the Mystery” that I was participating yesterday.

Now I’m sitting in OCP Louge, and in few minutes I’m going for last session Managing Very, Very Large XML Documents with Oracle XML Database and then for The Appreciation Event.

Cheers,
Paweł

BTW. This is my post # 100.
--
Related Articles on Paweł Barut blog:
Categories: Development

My OpenWorld 2008: 23 Set

Oracle Apex Notebook - Wed, 2008-09-24 14:27
The first session of the day was schedule to 11:30 AM. I had some free time that I used to get around and see what was happening. I went to Moscone North and after blogging a bit on the couches, went to the Unconference section and then the bookstore. I couldn’t find John Scott’s Pro Oracle APEX book, but later at night he told me that the book was there, so maybe I’ll go to the bookstore
Categories: Development

OOW2008 day 3

Pawel Barut - Tue, 2008-09-23 23:08
Written by Paweł Barut
This day was quite good for me. I’ve finally overcome problems with jet-lag.

I’ve started day on session “Inside Oracle Database 11g Optimizer: Removing the Mystery”. It was very good session explaining how new features in optimizer works. It provided inside on Plan Profiles, improved bind variable picking, improved performance for statistics collection and new statistics for correlated columns.

My next session was not exactly what I was expecting. “Global-Scale Web 2.0 Data Platforms: Sharding with Oracle Database”. I was expecting technical inside, but it mostly was marketing speech on “why Oracle is better then MySQL”. Break between sessions I’ve used to ride on Cable Car:


I’ve ended day on session “Top 10 Things You Wanted to know about ASM”. As I were not using ASM yet, it was good overview of features, and best practices for using ASM. Now, I’m going to rest to be prepared for next day, and big keynote by Larry Ellison.

Cheers,
Paweł
--
Related Articles on Paweł Barut blog:
Categories: Development

Some positive drag-and-drop experience

Raimonds Simanovskis - Tue, 2008-09-23 16:00

In the previous post I wrote that I didn’t quite like drag-and-drop development style in JDeveloper that I experienced during Oracle OpenWorld hands-on session.

oracle_bi.png

Today I was in Oracle BI Answers & Dashboard hands-on session and during this session I was also drag-and-dropping to create reports, charts and business intelligence dashboards. But in this case I liked it as it seemed natural way how to create such reports.

The main difference why I liked it was that I got immediate feedback how the end report will look like – after each change I could immediately see and test real report with real data. And such immediate feedback is key prerequisite for interactive analytical reporting development.

In JDeveloper case I needed to compile and build everything and restart local application server after each change to see real results from any change – and it took at least 10 seconds for just sample “hello world” application. I assume that this lag will be even longer in larger real projects. Probably it is not so long time but when you compare it to 1 second feedback time then anything larger seems long.

I also visited Oracle demo grounds where I discussed my concerns regarding JDeveloper drag-and-drop development style. At the end we reached common understanding that JDeveloper and ADF framework is really good for former Oracle Forms developers who do not want to learn HTML, CSS and Javascript and auto-generated applications could be quite OK for internal enterprise applications. But if you want to build advanced web applications you still need to learn and be expert in these web technologies (HTML, CSS and Javascript).

Categories: Development

My OpenWorld 2008: 22 Set

Oracle Apex Notebook - Tue, 2008-09-23 12:01
Today I have changed my agenda and attended two sessions that weren’t initially in my schedule. The first was the one presented by Dimitri Gielis about working charts in APEX and the second one was about mashups and integration with APEX by Simon Boorsma. Before that I went to Moscone North to watch a bit of the keynote. You can’t believe the number of people that were there! The following
Categories: Development

OOW2008 day 2 – Oracle Beehive

Pawel Barut - Tue, 2008-09-23 10:23
Written by Paweł Barut
This day started with Keynote presented by Oracle President Charles Phillips. He spoke about Oracle acquisitions, and more complete portfolio of products that Oracle have now. What caught my attention most was announcement of new product, new collaboration platform Oracle Beehive. It joins features of email, calendar, document sharing, web conference and few more in one suite. What is most important those tools are open, so user can use ex. MS Outlook to access mails or calendar entries. Security is one of the key features. When you share document with others, they can see document in theirs workspace. They can even make local copy of this document. When document is deleted by original author, then all copies of the document become unusable for anyone. This is because all shared documents are encrypted and signed. While opening document there is validation of access rights for document. For me it seems as this is based on technology acquired from Stallent. It seems that this product will try to get market from MS Sharepoint and IBM Lotus.

Today I took some time to see Exhibition Hall, and walk around the city. While walking I’ve found one interesting bus – I was Bus that was advertising Microsoft SQLServer:

It looks pretty old :). Microsoft does not want to be absent in San Francisco during Oracle’s big conference.

I’ve also participated in few session on SOA (Service Oriented Architecture) and AIA (Applications Integration Architecture). Basically I wanted to have better understanding of Oracle offering in SOA area.

Cheers,
Paweł

--
Related Articles on Paweł Barut blog:
Categories: Development

Arriving San Francisco – OOW2008 day 1.

Pawel Barut - Sun, 2008-09-21 19:41
Written by Paweł Barut
My trip to San Francisco went well. No delays, no problems with flight reservation – see what happened to Tim. I had small problems with hotel reservation, but finally everything is fine – I’m in different hotel then I’ve reserved. I’m suffering little from jet-lag. I slept an hour or two in plane, and then I could not sleep during night. So I feel little tired. The weather in SF is great, especially when comparing to very cold and rainy weather in Krakow last week.

My first experience of San Fracinsco is not very good. Seems to be not very friendly, and is definitely not of my style. I might change my mind when see more places in SF. But Oracle Conference is organized very well, so my attitude is improving :).

For today, I’ve planned mostly session regarding Security and Identity management. First of those session “Oracle Security Risk” was very good. Especially speaker Tanya Baccam from SANS.org was impressive. Presentation was about common problems with security in web based and forms application that use Oracle DB as backend. One type of attack was new to me: CSRF – Cross Site Request Forgery.

Next one was Security Roundtable – lot of questions from audience on variety of topics. Most hot one: applying CPU patches, Auditing, DB Valut, Encrypting data and transmissions.

Then was Oracle Identity Management lead by Matt Topper. Good overview of identity products from Oracle stack.

My last one session “Storage: A New Paradigm for Database” was also very good session. Ari Kaplan show now storage solutions can improve Backup/Restore times for database and decrease demand for storage space. He also presented new RAID-DP concept, and claims that it can provide better performance, with lower storage demand, and provide higher availability. This is something that I need to investigate in more details.

For the evening I’m going to take part in Bloggers Meetup.

Cheers,
Paweł
--
Related Articles on Paweł Barut blog:
Categories: Development

Coding or drag-and-dropping?

Raimonds Simanovskis - Sun, 2008-09-21 16:00

Today was my first day at Oracle OpenWorld and here are my first impressions from the sessions I attended.

The first one was Building Web 2.0 Social Applications in Ruby on Rails with BEA AquaLogic Interaction by Chris Bucchere where he explained how they built social application for BEA conference participants. And it was interesting to see also some code examples from this application that he presented.

drag_and_drop.gif

And then after that I participated in three Oracle Develop hands-on sessions about Oracle SOA suite and WebCenter. I signed up for these sessions because I thought that they will be more technical and code-intensive compared to other sessions.

As a result I spent three hours in Oracle JDeveloper but all I was doing was dragging-and-dropping and filling some pop-up dialog boxes. I did not write single line of Java code during these workshops. And as a result I had just vague idea why all the dragged components worked together.

Having experience of coding in Ruby and trying to create small and beautiful code this drag-and-drop development did not feel quite natural for me. And I am afraid that this drag-and-drop development approach will create bunch of developers who will not be able to create real code anymore.

The other consequences of this drag-and-drop style coding is that it is hard to version control the resulting generated code and it is also much harder to unit test such generated code. Probably this is the reason why I could not find any OpenWorld session about unit testing and test-driven development.

Am I missing some hidden beauty of drag-and-drop development? Or am I spoiled with beauty of Ruby?

Categories: Development

San Francisco

Oracle Apex Notebook - Sun, 2008-09-21 11:41
I’m in San Francisco for the Oracle OpenWorld 2008 where I’ll be participating in one of the official sessions under the title “Building Commercial Software-as-a-Service Applications with Oracle Application Express”. I’ve arrived yesterday around 6:30 PM after a tiring 18 hours long trip. I’ve started at Oporto Airport where I took a plain to Lisbon, then Philadelphia and finally San Francisco.
Categories: Development

One year blogging

Oracle Apex Notebook - Sun, 2008-09-21 11:00
Yes, that is right. This blog is one year old. I thank all of you out there for coming around, reading what I want to say about APEX. Thanks a ton. I hope you will stick with me for the next year too. Top 10 of most visited posts: Check all checkboxes Javascript Calendar Integration Colorful web forms Javascript Tooltip Integration Substitution string and SQL Developer Populate date field
Categories: Development

Preparing for Oracle OpenWorld 2008

Pawel Barut - Sat, 2008-09-13 04:41
Written by Paweł Barut
It's just few days left to Oracle OpenWorld 2008. First of all my trip starts on Saturday 20th at 13:00 in Kraków, Poland. Then I switch planes in Munich, Germany, and land in San Francisco at 19:20. Just 6 hours ahead, but when I add 9 hours difference in time zones, that it adds up to over 15 hours travel. The worst thing will be adaptation to totally different timezone. I will stay in Americas Best Value Inn at Hallam Street - I hope this is in reasonable walking distance from Moscone Center. I've created an map on Google Maps - the street view feature is great - now I know how the hotel neighborhood looks like. I've also checked transportation services by BART.
And the most important thing - My OOW2008 Schedule:

I do not expect big changes in this schedule, but still, some smaller changes are possible. I could skip one or more sessions to see Exhibition Hall or go for Unconference.
I'm also looking forward for meeting other Oracle Bloggers during Blogger Meetup organized by Eddie Awad.
Update: I forgot to mention about After Dark at Oracle OpenWorld where are evening parties listed.

See you in San Francisco,
Paweł

--
Related Articles on Paweł Barut blog:
Categories: Development

Back to real life

Oracle Apex Notebook - Mon, 2008-09-08 11:12
After 15 well deserved :) days of vacations in the sunny Algarve (south Portugal) I'm back to work. It is hard when I think that just two days ago I was at those wonderful beaches, eating fresh sea fish... However, not everything went fine :( I just had one of the major sports disillusion, provoked by a bad referee decision. I've just noticed that while I was away some things happened in the
Categories: Development

This blog in a cloud

Oracle Apex Notebook - Mon, 2008-09-08 11:11
After reading this post by Jake Kuramoto, I was curious to see how Apex Notebook blog looks like in a word cloud. Here is the result: Wordle is a service for generating word clouds from text sources like blog feeds. The words that appear more frequently in the source text are bigger in the final image.
Categories: Development

Get server URL in Apex

Oracle Apex Notebook - Mon, 2008-09-08 11:11
Some time ago, I had this requirement to send to the application end users, links to specific pages passing some parameters. The problem was obtaining the full URL including the server's name and port where APEX was running. The OWA_UTIL package contains utility subprograms for getting the value of environment variables. Specifically the OWA_UTIL.GET_CGI_ENV function returns the value of CGI
Categories: Development

Oracle enhanced adapter presentation at RejectConf in Berlin

Raimonds Simanovskis - Fri, 2008-09-05 16:00
rejectconf08.jpg

I just returned from RailsConf Europe in Berlin and attended a lot of good Ruby and Rails related sessions.

I also tried to submit there my session proposal about using Rails with Oracle but as there were too many good proposals and as my topic was with too narrow topic then it was not accepted. Therefore I used opportunity to give 5 minutes presentation about Oracle enhanced adapter in RejectConf where anybody could present anything.

Here are my slides that I used in this presentation. And at least one participant was interested in this topics as he uses Rails and Oracle and did not know about my adapter.

My next public appearance is planned at Oracle OpenWorld unconference where I have recerved time slot on Thursday, September 25th at 10am. Please come there if you are attending Oracle OpenWorld and are interested in how to use Ruby on Rails with your legacy Oracle databases.

Categories: Development

New Browsers and Oracle EPM

Oracle EPM Smart Space - Thu, 2008-09-04 12:08

Whenever there are new browser technologies I am interested to see how our existing EPM products will do in them.  Right now there are 2 large browser betas first IE8 and second Google Chrome.  Both are nice browsers with rich application support but they are both betas so there are plenty of bugs.  I tried IE8 first because IE is the most popular browser and it usually does a nice job with our EPM products.

imageI was able to open Oracle EPM workspace in IE8 and logged in just fine.  The explorer screen showed up and I was able to select and open a report.  Opening the report caused a Java script error that messed up my navigation from that point on.  The script errors caused frustration but it was useable.

image

clip_image002[5]I tried the same thing with Chrome and got nowhere fast.  I got a gray screen when trying to load the logon page and it just kept trying to load...  I tried 9.3.1 to see if the older stuff was any better and it let me login and get to the explorer screen but I could not navigate.

clip_image002[7]

So the only conclusion I can come to is that for EPM products stick to supported browsers and use the betas to play with other web sites. 

Categories: Development

Out Now!! Application Express 3.1.2

Anthony Rayner - Fri, 2008-08-29 02:21
APEX 3.1.2 is now available for download and fixes the following bugs. You can get hold of it by either:
  • Downloading the full version from OTN.

  • Download the patchset 7313609 from METALINK.
If your unsure about which download you need, please read Joel's blog. As Joel says, if your upgrading from any APEX version pre-3.1, then you'll need to use the full OTN release (which includes the version that comes pre-installed with 11gR1).

For details on future plans, please take a look at our Statement of Direction, which was updated just under 3 weeks ago with details of the 'Forms Converter' of APEX 3.2 and 'Websheets', 'Updateable Interactive Reports', 'Extensible Item Framework' and much more of APEX 4.0.

Happy patching!
Anthony.

Categories: Development

DB Link to Oracle 11g

Pawel Barut - Wed, 2008-08-13 13:59
Written by Paweł Barut
As you know in Oracle 11g passwords are case sensitive by default. This applies to connecting via SQL*Plus or other client tools. And it also applies to database links between databases. So when you link from Oracle 10g to Oracle 11g create database link like this:
CREATE DATABASE LINK my_link
CONNECT TO remote_user IDENTIFIED BY "CaSe_SeNsItIvE_PaSsWoRd"
USING 'TNS_ID_11G';

Do not forget to enclose password by double-quote marks!
When you do not set password this way, you will be getting:
ORA-01017: invalid username/password; logon denied.
Hope this small tip will be useful for someone.

Paweł

More on Creating Database Links.

--
Related Articles on Paweł Barut blog:
Categories: Development

My agenda at OpenWorld 2008

Oracle Apex Notebook - Mon, 2008-08-11 07:48
Essentially, at OpenWorld I'll be looking for everything related with APEX. Unfortunately it's impossible to attend all APEX related sessions, because (fortunately) there is a huge number of interesting sessions and some of them share the same time schedule. David Peake has built an application that puts together all APEX sessions (good work btw) which helps picking the sessions. Beyond the
Categories: Development

Me at Oracle OpenWorld 2008

Oracle Apex Notebook - Mon, 2008-08-11 03:56
It is my first time at Oracle's big event, the OpenWorld. David Peake was kind enough to invite me to participate in one of the official sessions. So, if you want to meet me, you can find me at San Francisco next September :) Here is the session description, don't forget to register: Session Id: S300458 Title Building Commercial Software-as-a-Service Applications with Oracle Application
Categories: Development

Pages

Subscribe to Oracle FAQ aggregator - Development