Oct 18 2005
So, what did bring this first day? First of all, that the automatic self tuning new 10g features are great but they have a buildin drawback. Until now, Steve pointed out, the standard (not so OK) way was to create a working application on a database, and then afterwards look for how to tune the …
Sep 29 2005
Say it’s that day again. You try to connect to a (new) database and once again you are facing SQL*Net problems. C:/oracle/product/10.1.0/client/BIN>sqlplus /nolog SQL*Plus: Release 10.1.0.4.0 – Production ON Thu Sep 29 10:37:15 2005 Copyright (c) 1982, 2005, Oracle. ALL rights reserved. SQL> conn scott/tiger@lab.amis.nl ERROR: ORA-12154: TNS:could NOT resolve …
Aug 23 2005
Sometimes you want to search for Oracle database messages, their meaning or you are in search of specific database event settings. For instance, a long time ago i was searching for an event that would trace when an datafile would expand / autoextend. I encountered latching problems on a Siebel system based on an new …
May 20 2005
Working for years with Oracle’s relational environment, XML DB is a completely different kind of beast. You’re confronted with all the languages and techniques the XML environment has to offer – XML, XML Schema, XSLT, Xpath, DTD, DOM, SAX, etc,etc,etc – plus the ones you know from Oracle’s (object) relational (database) world, SQL, PL/SQL, java, …
May 12 2005
Yesterday i was reading nice discussions on Asktom about the dual table. Afterwards somehow a “undocumented” Oracle feature popped into my mind again. Last time I used is at least in those days I worked with Oracle 7.0 /7.1. So I tried It out on Oracle database version 10.1.0.4 and it still works… Maybe it …
Mar 03 2005
It’s possible to have also two different version listeners (the 9 and 10 version) running, by settting different ORACLE_HOME’s and PATH’s, and starting the different listeners. I like to have 1 listener – as long as this can be maintained regarding incompatibility and bugs etc – therefore my latest listener version is leading (version 10g). …
Recent Comments