Tags | Domains | Searches | Statistics | Options | Advanced Search
|
Tags | Domains | Searches | Statistics | Options | Advanced Search |
Pythian Group Blog - Jul 23, 2008
There seems to be a bug in DBD::Oracle’s execute_array when working with 11g. If you tell DBD::Oracle to autocommit, it seems that in 11g this commit will not take place when an error occurs during the processing of …
Also tagged: oracle, dbd oracle, dbi, dbd oracle bug, oracle bug
Pythian Group Blog - May 13, 2008
As some of you probably already noticed, there was a thread on AskTom discussing the scalability tests I did back in 2007. You are welcome to read the entire thread, but in a nutshell, Tom Kyte claimed that my tests …
Also tagged: oracle
Pythian Group Blog - May 7, 2008
After our last post about installing Oracle 11g on Ubuntu 7.10 (November, 6th), and considering Ubuntu 8.04 LTS was released on April 21st , I spent some time reviewing and putting together this new HOWTO for the …
Also tagged: oracle, linux, install, ubuntu, hardy heron, ubuntu 8 04
Pythian Group Blog - Apr 9, 2008
After setting up dg4odbc to connect to a SQL Server database (read ‘Tips on Using dg4odbc on 64-bit Linux’), I spent last week trying to get refreshes of materialized views to work in 11g, using the same DDL as in 8i …
Also tagged: oracle, odbc, group blog posts, ansi, dg4odbc, materialized views
Pythian Group Blog - Feb 7, 2008
I’ve recently moved to Ubuntu Linux, and this post describes my attempt to play around with Oracle ASM on Ubuntu. For this demonstration, I used Oracle 11.1.0.6 on Gutsy Gibbon. I hope it will be useful to somebody out …
Also tagged: oracle, linux, ubuntu, asm, group blog posts, ubuntu 7 10
Pythian Group Blog - Jan 25, 2008
I have been using this SQL*Plus command for a while now: SQL> show spparameter service_names SID NAME TYPE VALUE -------- ------------- ----------- --------- * service_names string [...]
Also tagged: oracle, new features, sqlplus, group blog posts
Pythian Group Blog - Jan 7, 2008
While perusing the Oracle 11g Data Pump documents recently, I noticed a new parameter that was introduced in Oracle 10g, but I had missed it there. The parameter is TABLE_EXISTS_ACTION, and it applies only to the Data …
Also tagged: oracle, import, group blog posts
Pythian Group Blog - Nov 28, 2007
This will be the final post in my series on Result Caches. In my previous article, I had already got almost everything. Almost — four CPUs (cores) were still not enough to saturate the single latch. As you’ve probably …
Also tagged: oracle, dual core, scaling, group blog posts, buffer cache, result cache
Pythian Group Blog - Nov 23, 2007
This was the presentation I gave at Open World 2007. It went pretty well, judging by how full the room was. I estimate more than 300 people attended. Although the title may sound a bit like a sales pitch, the content …
Also tagged: oracle, conference, presentation, group blog posts, non tech articles, oow, ukoug
Pythian Group Blog - Nov 12, 2007
The 11g platforms are now coming out fast and furious: Windows 64-bit Solaris SPARC 64-bit AIX PPC64 HP-UX Itanium In addition to the previously-released: Linux x86 32-bit Linux x86 64-bit Windows 32-bit So download …
Also tagged: oracle, windows, solaris, aix, hp ux, group blog posts