Archive for the 'oracle' Category

OTN Discussion Forums : SQL*Plus 10.2.0.1.0 does not work on … | times(NULL) = loop

Friday, May 6th, 2011

It appears to be an interesting bug in some versions of Oracle 10g, on Linux 2.6.x oracle process goes in loop doing times() system call if machine uptime < 199 days. Nice!!! / Oracle refs are bug 4612267 and 5867987 ) . The solution is to reboot.

Google Translate "Again about SQL " — route costs lookup for telephony operator

Tuesday, November 23rd, 2010

Google translate of 2 posts in Russian section of LJ about route costs look up problem commonly faced by telephony operators

PostgreSQL versus Oracle!

Thursday, July 29th, 2010

Full Text Search benchmark, Oracle vs Postgres, on 2x Quad core Xeon, 8G RAM, 2 SSDs x RAID 1. Pg is being slightly faster when query contains several words, once word count increases, oracle leaps ahead (suggesting a more mature FTS implementation)

Benchmarking Databases I. Volatile Storage. – Pon un sol en tu vida

Friday, February 20th, 2009

PostgreSQL, MySQL and Oracle are compared using reasonable hardware setup and TPC-C like test with BenchmarkSQL tool (JDBC ) . This post will probably disappear soon as the author clearly violates oracle license that does not permit publishing benchma…

Oracle FAQ: Oracle Parallel Query

Thursday, November 15th, 2007

some faq on oracle’s parallel query processing