Carl's Oracle

www.orcasoracle.org

Read the rest of this entry ... (1 words left)

Hi,

Last week i decided to move this blog to a wordpress www.wordpress.com based blog.

Wordpress supports static pages, categories and has a lot of wunderfull themes and functionality.

I reorganize the page. My target is to concentrate the content on Basics of Tuning, CBO, ...;

The new site is under construction and will be available as soon i have the right structure

and when i am finished with manually migration of content

Greetings

Karl

PS.:Bloghi was a good platform -  a lot of reliable functionality and a very good editor.

 

Hi,

this is not the first story about avoiding the use of RDBMS with all it's consequences :

http://www.thedailywtf.com/forums/64256/ShowPost.aspx

My question really is why Databases have a real bad reputation in the development community?

• is it the old technology?
• is it the experience meeting some strange database guys?
• is it the database less education in school/university?

Greetings

Karl

 

 

I was inspired by Tom Kytes Blog Entries about NULLs in indexes. Only if all Columns of an index are set to NULL they are not part of the index;

Read the rest of this entry ... (546 words left)

Hi, Applications do not live as data islands. The more an application integrates data of other applications of a company the better is. Even we live in the Year 2006 the most common way to import data from other systems is the flat file. Via SQL*LOADER the data is loaded into an Import table which is a table presentation of the flat file. Then the Processing of data starts to apply the imported data to the applications tables.

Read the rest of this entry ... (875 words left)

Hi, unfortunately in the current project the customer has on development site databases on Windows Server but on production site databases on AIX based UNIX servers. Usually this is no problem when the Oracle versions are the same. Some Oracle Database objects are still OS dependent like the directory objects. Oracle Directory objects are an encapsulation of the real directories in the file system of the OS. Grants on Oracle directory objects controls the user access.

Read the rest of this entry ... (459 words left)

Hi,
do you think execution plans are only the compiled access plan on which data will retrieved hopefully with low costs and good response time? Execution plans can also have influence on the result set of your SQL! Happended day ago in my current project. A milestone was put on a separate database. After first tests we detected some lists were not sorted. We support paged lists. On database side a window of rows sorted by a column will be retrieved - enriched with country coded texts.
We were surprised because we did not expect from the sorted window to get unsorted output. Here the SQL:

SELECT
 Company.Legalname,
 Company.*,
 V1.VALUE AS Industry,
 V2.VALUE AS Industrysubtype,
 V3.VALUE AS Companystatetext,
 V4.VALUE AS Bgsdescription,
 V5.VALUE AS Legalform,
 V6.VALUE AS Region,
 V7.VALUE AS Countrytext
  FROM Isis.Industrytext V1,
       Isis.Industrysubtypetext V2,
       Isis.Companystatetext V3,
       Isis.Bgscodetext V4,
       Isis.Legalformtext V5,
       Isis.Regiontext V6,
       Isis.Countrytext V7,
       (SELECT /*+ FIRST_ROWS */
         Iq.*,
         Rownum AS z_r_n
          FROM (SELECT Company.*
                  FROM (SELECT *
                          FROM Isis.Company
                         WHERE Company.Isis_Prefered = 1) Company
                 WHERE Company.Companystate <> 5
                   AND Upper(TRIM(Company.City)) LIKE Upper(TRIM('BERLIN'))
                 ORDER BY Company.Legalname ASC) Iq
         WHERE Rownum <= 15) Company
 WHERE z_r_n >= 1
   AND (V1.Key(+) = Company.Industrykey AND V1.Locale(+) = 'en-GB' AND
       V2.Key(+) = Company.Industrysubtypekey AND V2.Locale(+) = 'en-GB' AND
       V3.Key(+) = Company.Companystate AND V3.Locale(+) = 'en-GB' AND
       V4.Key(+) = Company.Bgscode AND V4.Locale(+) = 'en-GB' AND
       V5.Key(+) = Company.Legalformkey AND V5.Locale(+) = 'en-GB' AND
       V6.Key(+) = Company.Regionkey AND V6.Locale(+) = 'en-GB' AND
       V7.Key(+) = Company.Countryisocode AND V7.Locale(+) = 'en-GB')

•    And its resulting Execution plan :

Read the rest of this entry ... (970 words left)

At the current project developers use to identify the C# objects with the almost unique GUID. No sequences are used at all. As we know objects cannot live a longer period without persistence - the objects are not only referenced by GUID in memory but also in the database. With GUID an object can be referenced unique even between different databases. What's  exact is a GUID?

Read the rest of this entry ... (1843 words left)

Hi,

PL/SQL becomes mature (specially in Oracle 10.2!)!
Read more about conference papers at this link : http://oracleplsqlprogramming.com/opp2005_agenda.php
Regards
Carl

Hi,
today when I came home there was a package from amazon – it contained the book Cost Based Oracle Fundamentals which I ordered in advance. I just could not wait to open the book. In 15 Minutes I would have to leave with my wife to go shopping at IKEA. So I had only a few minutes for the first review.

Read the rest of this entry ... (187 words left)

Hi,
It was time to upgrade my Linux based Oracle database from 9.2.0.4 to 9.2.0.7. A thing which is easy going – I thought! Linux was SusE 9.2 Professional with 2.6.x kernel and gcc 3.3.4. After the oracle installer finished copying the files to Oracle Home the linking of the executable started. Soon an error raised which I could not solve:

Read the rest of this entry ... (661 words left)

Hello,

As i heard about the availability of the Patchset 6 (9.2.0.7) of the Oracle 9.2 Database Server i was very surprised. I thought Patchset 5/9.2.0.6 would be the last Patchset and ... that all errors would have been finally patched ;-).

For Analysis i scanned the bugs HTML document, pasted and prepared the bugs info with an editor and transformed it with awk. Now it had the right format for excel and then what else did you expect - I stored all the data in an 9.2 database (Patchset 3/9.2.0.4 ;-));

With the data in the database you could answer a lot of questions. I reduced that to two questions:

• How many errors have been patched with each Patchset?

• Which are the top 20 Components (of 139) have the largest amount of errors

The Total Number of fixed Bugs for the Oracle 9.2 Database Server

SQL> SELECT COUNT(*) FROM Buglist;
COUNT(*)
----------
10256

SQL>