Hi reader,

Since 15 years i am working with the Oracle Database and as a Developer with GUI driven oracle tools. But what slowly gets boring it that no new GUI driven concept hase been developed for. Consequential an application for database development has an SQL window, a data grid and database object browser and some editing functionality. OK some tools for example compare user objects, or generating DDL of a database object.

in the whole all tools are very similar - there is nothing new indeed. Some exception for example was Spotlight on Oracle with a very clean interface design. But from the same company there is a tool with thousands of menu points addressing all the options the database server has.

How should be designed a Database Tool for the Future? Some aspects I’ve seen in some products. For example Refactoring well known in the Java Eclipse Community and in the Visual C# Community is something upon the base functionality.

• Why not simple drag a single procedure to a package and drop it and it’s included in the package header and body.
• Why not drag a column and drop it to another table - a submenue opens if the column should be moved and a migration script is automatically generated or only the attributes of the column are copied to the target table.
• Why not simple copy a table from on instance to the other via drag and drop?
• Why not creating a materialized view definition when i drag and drop a query text to an Mview Symbol?

Yes - i am waiting for a sensational product giving comfort developing database side objects never seen before.

Karl

Hi reader,

probably due to the changes in user/password management (the e-mail of a user is now the user name ) too many requests made the metalink service not available.

Greetings

Karl

Hi reader,

with the new oracle scheduler it’s possible to start jobs as external programs from database. See how this can be done using the db Console.

• The Self Exporting database

HTH

Karl

Hi Reader,

as i read the agenda of the workshops i recognised that the content is very deep. If you want to really understand some basics about CBO and other stuff Jonathan Lewis is the correct address.

Aggregated Agenda

• Cost Based Optimisation 03. Juli 06
  Describes the assumptions, arithmetic, and strategies of the optimizer, with clues on how to address common problems, and work around awkward data set.
• Indexing Strategies 04. Juli 06
  Covers the most common area where resources are wasted unnecessarily, with suggestions on how to maximise the return with minimum effort.
• Trouble-shooting and Tuning 05. Juli 06
  How to identify and address performance problems
• Explain Plan 06. Juli 06
  Provided you with the skills to interpret the execution plan that the optimizer uses, in order to decide whether it is a good plan, and apply your knowledge of the CBO to change it if necessary.

More information here

Greetings
Karl

Hi reader,

talking of performance in the Oracle Community we take the response time as important metric for quality of our tuning efforts. My provider tops in response time too …. Not in the response time of the page access (that’s ok!) but with the speed and quality about processing support requests. Whenever i had a problem i got immediate and qualified help for my problems/questions.

If you are located in Germany yous should take a look the providers site : http://netztaucher.com/ and their service platform http://www.fairhost24.de/  including wordpress hosting. Sure you will find much more cheaper providers - but with the same level of support?

Greetings

Karl

Hi reader,

Trivadis a Database oriented solution provider invited a number of oracle experts for two days in Zürich to explore the CBO (Cost Based Optimizer). A very interesting event as you would meet there 

• Jonathan Lewis, JL Computer Consultancy (UK)
• Mohamed Zait, Oracle Corporation (USA)
• Wolfgang Breitling, Centrex Consulting (CA)
• Christian Antognini, Trivadis AG (CH)

Really an outstanding event, more details on Trivadis 2-Days-Seminar on Oracle CBO

Greetings

Karl

Hi reader,

Gerhard is a colleague in the current project i work. An upload of documents via .NET was very slow (1M in 40 seconds). We found a workaround and reached 1M in 2 seconds. Here the article published in Gerhard’s Blog;

Slow Oracle BLOB upload with C# .NET and how to speed up.

Greetings
Karl