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.
Posted in 10G, 2.6, bugs, database, dba, Linux, oracle, sysadmin | Comments Off | permalink
Google translate of 2 posts in Russian section of LJ about route costs look up problem commonly faced by telephony operators
Posted in database, index, map_reduce, oracle, parallel, postgresql, programming, sql | Comments Off | permalink
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)
Posted in benchmark, comparison, database, dba, Linux, oracle, performance, postgresql, search | Comments Off | permalink
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…
Posted in benchmark, database, dba, for:charlesnw, for:collidr, mysql, oracle, performance, postgresql, tpc-c | Comments Off | permalink
some faq on oracle’s parallel query processing
Posted in database, oracle, parallel, processing, programmimg, query | Comments Off | permalink
You are currently browsing the archives for the oracle category.
Konstantin Antselovich (c) 2004-2011
powered by WordPress
Entries (RSS)
and Comments (RSS).