http://orcasoracle.bloghi.com/ Carl's thougts about the Oracle Database Server Thu, 28 Aug 2008 16:52:37 +0000 http://bloghi.com/ http://orcasoracle.bloghi.com/img_ch.hi?id=4058 http://orcasoracle.bloghi.com/ http://orcasoracle.bloghi.com/2006/04/29/now-you-find-my-new-wordpress-blog-at.html http://orcasoracle.bloghi.com/2006/04/29/now-you-find-my-new-wordpress-blog-at.html#comments Sat, 29 Apr 2006 12:37:31 +0000 http://orcasoracle.bloghi.com/2006/04/29/now-you-find-my-new-wordpress-blog-at.html www.orcasoracle.org Greetings Karl http://orcasoracle.bloghi.com/2006/04/29/now-you-find-my-new-wordpress-blog-at.html#comments http://orcasoracle.bloghi.com/2006/03/17/migrating-my-blog-to-wordpress.html http://orcasoracle.bloghi.com/2006/03/17/migrating-my-blog-to-wordpress.html#comments Fri, 17 Mar 2006 16:56:37 +0000 http://orcasoracle.bloghi.com/2006/03/17/migrating-my-blog-to-wordpress.html 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... http://orcasoracle.bloghi.com/2006/03/17/migrating-my-blog-to-wordpress.html#comments http://orcasoracle.bloghi.com/2006/03/17/we-don-t-need-no-stinkin-database.html http://orcasoracle.bloghi.com/2006/03/17/we-don-t-need-no-stinkin-database.html#comments Fri, 17 Mar 2006 04:58:42 +0000 http://orcasoracle.bloghi.com/2006/03/17/we-don-t-need-no-stinkin-database.html 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... http://orcasoracle.bloghi.com/2006/03/17/we-don-t-need-no-stinkin-database.html#comments http://orcasoracle.bloghi.com/2006/02/07/index-and-nulls-much-do-about-nothing.html http://orcasoracle.bloghi.com/2006/02/07/index-and-nulls-much-do-about-nothing.html#comments Tue, 07 Feb 2006 14:23:30 +0000 http://orcasoracle.bloghi.com/2006/02/07/index-and-nulls-much-do-about-nothing.html 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; Very often processing rows with a state information is done via workflow. For example an Activity... http://orcasoracle.bloghi.com/2006/02/07/index-and-nulls-much-do-about-nothing.html#comments http://orcasoracle.bloghi.com/2006/01/14/cbo-cardinality-oh-cardinaltiy.html http://orcasoracle.bloghi.com/2006/01/14/cbo-cardinality-oh-cardinaltiy.html#comments Sat, 14 Jan 2006 14:28:49 +0000 http://orcasoracle.bloghi.com/2006/01/14/cbo-cardinality-oh-cardinaltiy.html 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... http://orcasoracle.bloghi.com/2006/01/14/cbo-cardinality-oh-cardinaltiy.html#comments http://orcasoracle.bloghi.com/2006/01/06/pl-sql-flexible-deployment-of-database-objects.html http://orcasoracle.bloghi.com/2006/01/06/pl-sql-flexible-deployment-of-database-objects.html#comments Fri, 06 Jan 2006 08:29:47 +0000 http://orcasoracle.bloghi.com/2006/01/06/pl-sql-flexible-deployment-of-database-objects.html 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... http://orcasoracle.bloghi.com/2006/01/06/pl-sql-flexible-deployment-of-database-objects.html#comments http://orcasoracle.bloghi.com/2005/12/21/execution-plan-dependent-query-results-sorting.html http://orcasoracle.bloghi.com/2005/12/21/execution-plan-dependent-query-results-sorting.html#comments Wed, 21 Dec 2005 15:33:40 +0000 http://orcasoracle.bloghi.com/2005/12/21/execution-plan-dependent-query-results-sorting.html 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... http://orcasoracle.bloghi.com/2005/12/21/execution-plan-dependent-query-results-sorting.html#comments http://orcasoracle.bloghi.com/2005/12/09/guids-or-query-rewrite-why-my-materialized-view-is-not-used.html http://orcasoracle.bloghi.com/2005/12/09/guids-or-query-rewrite-why-my-materialized-view-is-not-used.html#comments Fri, 09 Dec 2005 13:54:10 +0000 http://orcasoracle.bloghi.com/2005/12/09/guids-or-query-rewrite-why-my-materialized-view-is-not-used.html 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... http://orcasoracle.bloghi.com/2005/12/09/guids-or-query-rewrite-why-my-materialized-view-is-not-used.html#comments http://orcasoracle.bloghi.com/2005/11/17/opp2005-first-pl-sql-conference-a-big-success.html http://orcasoracle.bloghi.com/2005/11/17/opp2005-first-pl-sql-conference-a-big-success.html#comments Thu, 17 Nov 2005 23:35:26 +0000 http://orcasoracle.bloghi.com/2005/11/17/opp2005-first-pl-sql-conference-a-big-success.html 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 http://orcasoracle.bloghi.com/2005/11/17/opp2005-first-pl-sql-conference-a-big-success.html#comments http://orcasoracle.bloghi.com/2005/11/16/cost-based-oracle-has-reached-germany.html http://orcasoracle.bloghi.com/2005/11/16/cost-based-oracle-has-reached-germany.html#comments Wed, 16 Nov 2005 12:02:34 +0000 http://orcasoracle.bloghi.com/2005/11/16/cost-based-oracle-has-reached-germany.html 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... http://orcasoracle.bloghi.com/2005/11/16/cost-based-oracle-has-reached-germany.html#comments http://orcasoracle.bloghi.com/2005/11/09/patching-oracle-9-2-0-4-to-9-2-0-7-on-suse-9-2-professional-raises-undefined-reference-to-dl-iterate-phdr-glibc-2-2-4.html http://orcasoracle.bloghi.com/2005/11/09/patching-oracle-9-2-0-4-to-9-2-0-7-on-suse-9-2-professional-raises-undefined-reference-to-dl-iterate-phdr-glibc-2-2-4.html#comments Wed, 09 Nov 2005 11:57:48 +0000 http://orcasoracle.bloghi.com/2005/11/09/patching-oracle-9-2-0-4-to-9-2-0-7-on-suse-9-2-professional-raises-undefined-reference-to-dl-iterate-phdr-glibc-2-2-4.html 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... http://orcasoracle.bloghi.com/2005/11/09/patching-oracle-9-2-0-4-to-9-2-0-7-on-suse-9-2-professional-raises-undefined-reference-to-dl-iterate-phdr-glibc-2-2-4.html#comments http://orcasoracle.bloghi.com/2005/11/01/oracles-patchset-6-9-2-0-7-database-server-arrived-time-now-for-a-summary-of-all-9-2-patchsets.html http://orcasoracle.bloghi.com/2005/11/01/oracles-patchset-6-9-2-0-7-database-server-arrived-time-now-for-a-summary-of-all-9-2-patchsets.html#comments Tue, 01 Nov 2005 09:12:29 +0000 http://orcasoracle.bloghi.com/2005/11/01/oracles-patchset-6-9-2-0-7-database-server-arrived-time-now-for-a-summary-of-all-9-2-patchsets.html 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... http://orcasoracle.bloghi.com/2005/11/01/oracles-patchset-6-9-2-0-7-database-server-arrived-time-now-for-a-summary-of-all-9-2-patchsets.html#comments http://orcasoracle.bloghi.com/2005/10/29/oracle-10g-pioneering-innovations-with-perfomancemonitoring.html http://orcasoracle.bloghi.com/2005/10/29/oracle-10g-pioneering-innovations-with-perfomancemonitoring.html#comments Sat, 29 Oct 2005 03:44:45 +0000 http://orcasoracle.bloghi.com/2005/10/29/oracle-10g-pioneering-innovations-with-perfomancemonitoring.html hi, I heard an amount about the new Features of the Oracle 10G server. A little bit set in my opinion is the Revolution of it's new Metering model concerning the performance monitoring. Up to Oracle 9 there were decisively two (most... http://orcasoracle.bloghi.com/2005/10/29/oracle-10g-pioneering-innovations-with-perfomancemonitoring.html#comments http://orcasoracle.bloghi.com/2005/10/29/ora-20000-oru-10028-line-length-overflow-limit-of-255-chars-per-line.html http://orcasoracle.bloghi.com/2005/10/29/ora-20000-oru-10028-line-length-overflow-limit-of-255-chars-per-line.html#comments Sat, 29 Oct 2005 03:09:17 +0000 http://orcasoracle.bloghi.com/2005/10/29/ora-20000-oru-10028-line-length-overflow-limit-of-255-chars-per-line.html Do you like the full featured supplied PL/SQL Package DBMS_OUTPUT? It seems to be the package which ranks in top position with it's limitations ;-) limited maximal output buffer limited length of line (255) limited support of... http://orcasoracle.bloghi.com/2005/10/29/ora-20000-oru-10028-line-length-overflow-limit-of-255-chars-per-line.html#comments http://orcasoracle.bloghi.com/2005/10/28/welcome-to-this-new-blog.html http://orcasoracle.bloghi.com/2005/10/28/welcome-to-this-new-blog.html#comments Fri, 28 Oct 2005 09:48:13 +0000 http://orcasoracle.bloghi.com/2005/10/28/welcome-to-this-new-blog.html Hi ervery body. Used to have a blog at http://www.orcasoracle.blogspot.com/ but the RTF-Editor i missed is implemented at bloghi in a better way; and last but not least support for tables :  ColA  ColB  ColC  1... http://orcasoracle.bloghi.com/2005/10/28/welcome-to-this-new-blog.html#comments