About

Martin Klier

usn-it.de

Oracle expdp utility i18n – strange

Export> kill_job Möchten Sie diesen Job wirklich stoppen ([yes]/no): yes Möchten Sie diesen Job wirklich stoppen ([yes]/no): yes Möchten Sie diesen Job wirklich stoppen ([yes]/no): yes Möchten Sie diesen Job wirklich stoppen ([yes]/no): yes Möchten Sie diesen Job wirklich stoppen ([yes]/no): yes Möchten Sie diesen Job wirklich stoppen ([yes]/no): YES Möchten Sie diesen Job wirklich […]

read more

Counterize II does not count any more

Hi, Counterize II is a beautiful tool for gathering WordPress statistics. But after updating to WP 2.5 it did simply not count any more. No action taken – including an upgrade to the most recent counterizeii version – did help, and after upgrading WP to 2.5.1 today the situation did not change. Now I asked […]

read more

World’s fastest SATA drive: WD VelociRaptor WD3000GLFS

Hi, imagine a 2,5″ SATAII disk in a 3,5″ heat sink. It’s 300 GB in size, 120MB/s buffer-to-disk rate, 16 MB Cache, 10.000 RPM, consuming 6 Watts under load. Look here. I think this baby should take up to 150 IO/s, in combination with RAID 0+1 and a decent RAID controller or/and (Oracle’s) ASM this […]

read more

Effectice load balancing for a (web?) service in RAC 10gR2

Hi, had to review service creation with DBMS_SERVICE package for a good-feeling load balancing in Oracle RAC 10gR2 several times – now I have to write it down for myself. 🙂 I needed it for a web service using shared server today, but the generic syntax is useful for all other purposes as well. Basic […]

read more

Computer addicted? Parent’s training with Jörg Kabierske

Today (huh, it’s still “today”) I attended a so-called parent’s training (in German “Elterntraining”) at a local grammar school (Kepler Gymnasium Weiden). It’s topic was the handling of youths in contact with computers, internet and addiction risks. The lecturer was Jörg Kabierske, Regensburg (klicksalat.de). I was there just out of curiosity, to see what kind […]

read more

ORA-00600 [kgeade_is_0]

Have a look at this nice one (alert log), seen in 10gR2 (10.2.0.4 64bit on Linux): ORA-00600: Interner Fehlercode, Argumente: [kgeade_is_0], [], [], [], [], [], [], [] And from the trace file: Current SQL statement for this session: select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag from GV$FILESPACE_USAGE where inst_id != :inst and […]

read more

New theme

Hi, decided to look for a new theme. After testing GenkiTheme, Mimetastic and Munch, I ended up with TechnoPlain 1.1 Hope it looks okay for you. Regards Usn […]

read more

Disabling (or enabling) general job execution in Oracle 10g

Hi, disabling and enabling job execution in Oracle DB has two ways: If you are using dbms_jobs, it’s handy to set job_queue_processes to zero to disable the execution of jobs, and set it to a value >0 (maybe 100) to enable. If you are using dbms_scheduler, this parameter does not work for you. You will […]

read more

Find out your character set in Oracle DB

Hi, since ‘show parameter’ does not tell you your database charset, use this statement to see how your characters are stored: select * from nls_database_parameters where parameter=’NLS_CHARACTERSET’; Regards Usn […]

read more