Author: Laurent Schneider

solaris version now available Entreprise Manager download (Solaris 32bits)

I just discovered that new interface today. Hopefully, my old bookmarks still work. I did not find the “Tar” button. Well, it is now named “Service Request”. I tried the ORA-600 lookup tool, Doc id 153788.1 but it does not work today, both Firefox and Explorer failed. MS Explorer reports a Java Script error. document.forms.0.tool_type.value […]

I have been posting on metalink technical forum about a query that I run against all my test databases but did not work in production. as it simpliest form select sys_connect_by_path(dummy,’:’) from dual connect by 1=2; well, there is nothing wrong with this query. I tried it on 8i, 9iR2, 10gR1 10gR2 and it worked […]

I prefer and recommend using Oracle on a supported version, like Suse Entreprise 9, because the installation is fair. The Installer does complain on SLES9 what is missing. Ok, I just received a brand new notebook, I decided to go to Suse 10, and, Ô Miracle, the installation was pretty easy! I surely installed C++ […]

I wrote a few generators, and listed some existant in http://laurentschneider.blogspot.com/2005/08/pivot-table.html I decided to test them note that this is not a “good” test, it is simply an overview. I am doing a count(*), another operation may be better in one or worst in another one. all_objects is so slow (6 seconds for 50K rows) […]

Day 3 concludes the Tom workshop in Switzerland. We started with read consistency and write consistency, with an interesting example were a single row update could make a big job run thrice slower, because of the write consistency. Once again, Tom insist on saying that you must understand Oracle to write applications. Tom demonstrates a […]

Today I asked : “Is it the responsability of the developper to create the table structure?” The answer was something like that : “You have four kind of persons. – You have the Oracle6 DBA, who says always NO – You have the Developer, who does not care about database – You have the DBA/Developer, […]

Day one was quite interesting! We learnt a lot of staff about tuning approach, I have got confirmation that most of the “WE KNOW THAT, IT HAS ALWAYS BEEN SO” were maybe one day true, but are no longer, for example “separate index and tables”, or, delightfull, “you must periodically reorganise your tables”. I also […]

I just tried today to limit power of rman : REVOKE ALTER SESSION, CREATE DATABASE LINK FROM RECOVERY_CATALOG_OWNER; It seems I can still do a backup… probably those privilege are not needed by rman, maybe just inherited from Connect in an older released !?

There a few major changes in the database administration and the database security between 9i and 10g. In 9i, I used to grep in the listener.ora to find out the password. LISTENER_LSC61 = (DESCRIPTION=(ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=dbsrv85a.ex.zkb.ch)(PORT=10061)(QUEUESIZE=200)) )) PASSWORDS_LISTENER_LSC61 = 1234567890ABCDEF this 64bit encrypted string can be used in 9i to stop the listener $ lsnrctl LSNRCTL […]

It is monday, I am going to give a list of settings I like in sqlplus set lin 32767 trimsp on tab off extends the linesize and avoid line breaks. I use it before SPOoling. But it is annoying before DESCribing. Trimspool is necessary to avoid spaces at the end of the line. Set tab […]

I just wrote those two functions add_years and years_between they work similary to add_months and months_between, with the exception of leap years. there is exactly 1 year between 28-feb-2003 and 28-feb-2004 there is 1.00273224 year (1+1/366) between 28-feb-2003 and 29-feb-2004 there is 0.99726776 year (1-1/366) between 29-feb-2004 and 28-feb-2005 there is exactly 1 year between […]

click here sorry, once again, I used the back button of my browser, when I was not supposed too…

Next wednesday, Dec 7th, starts the Tom Kyte workshop in Zurich. In the evening we will have a dinner in Zurich. Drop me a comment if you intend to come !

the first time I saw ansi literals was in June 2004 in a post on otn forum by alex goodmann. I just cannot stop using them, it is so handy! Whenever I specify a date (or a timestamp or even a time), with Ansi Date, I do not rely on the NLS parameters, nor I […]

I will attend Tom Kyte 3-days session in Zurich in 2 weeks. I am immensely impatient to follow his workshop ! I hope palindnilap will be there too 😉 I invited him to come to my home to go to Tom Workshop, and to have a game of xiangqi on the brand new wooden board […]

I just answered a question about the data dictionary on forums.oracle.com. It is all about the dictionary views. How many tables should I know in the dictionary ? SQL> select count(*) from dict; 1857 Well, that’s too much. But I can remove the GV$ view, which contain the instance for RAC, and the DBA_ ALL_ […]

Tom Kyte is coming to Zurich next month! http://www.digicomp.ch/tomkyte

I wrote a mini script to protect my customer from being attacked by an “oracle voyage worm” variant : revoke CREATE DATABASE LINK from CONNECT; revoke ALL on SYS.UTL_FILE from PUBLIC; revoke ALL on SYS.UTL_HTTP from PUBLIC; revoke ALL on SYS.UTL_SMTP from PUBLIC; revoke ALL on SYS.UTL_TCP from PUBLIC; grant EXECUTE on SYS.UTL_FILE to XDB; […]

I just found in my RSS feed that a new agent has been released. 10.1.0.4 for AIX5L. Well, if you go to the OEM download page, you will see only 10.1.0.2 version for AIX, HPUX, Solaris Sparc. But by clicking on the link, for example Grid Control (10.1.0.2) for AIX5L Based Systems, you will find […]

In order to get a clean database configuration, I add the following two hidden parameters in my 10.2.0.1 parameter file. Do not hurl that loud, I hear you from here! Well, as I said already about the _pga_max_size, I never recommend using hidden parameters when you can do the same without. However, I am going […]

with netca, it is easy to configure your sqlnet.ora to use LDAP instead of tnsnames.ora. The ldap.ora and sqlnet.ora are updated… than it works, sqlplus user@db is correctly looking in the ldap oracle content

what can I do with LDAP? what is the difference between LDAP and Oracle Internet Directory? Well, there is quite a lot of interresting documents, pictures and faq on otn : OTN Directory homepage Directory Admin guide Identity Management ReferenceLDAP is a directory server, the info are stored in an Oracle 10.1.0.4.2 database. When you […]

My ldap server is up and running on my notebook with SLES9. Next, next, next, install. That is it. Oracle Application Server creates a 10.1.0.4.2 database and start the Oracle Internet Directory – understand LDAP server – automatically. It can then be configured with the web interface.

Well, when 10g certification came out, it said : “will be available in late 2004”. In March 2005, I contacted Oracle University in Germany. They said : keep watching oracle.com/education. Later, it said : “will be available in mid 2005”. In Open World, I met the certification principal, who meant it will start in December […]

In case you like this game and live in Zurich, I will be playing the swiss championship tomorrow.

what is a hierarchy? I enjoy reading the wikipedia definition : http://en.wikipedia.org/wiki/Hierarchy In the doc the hierarchy is as a parent-child connection, CONNECT BY PRIOR defines the relationship. However, it is possible to have under certain circumstances to connect to a child, regardsless of the parent. This is no longer a practical relation. Sterile variant […]

I just want to clarify something today : I do not like the connect by level

Oracle Enterprise Manager Downloads: oem download this is a great announcement!

one fresh download today oracle database 10g download I heard that grid control 10g release 2 may be available only in 2006. Quite annoying, since the repository cannot be on a 10gR2 db… just waiting