Sunday, August 31st, 2003 by Mark Rittman
More details about the new Oracle 10G and Application Server 10G are becoming available the closer we get to Oracleworld, and it’s becoming clear that the ‘grid’ element of the new products is mainly an enhancement to the existing Real Application Clusters feature of 9i, with improvments to the way SQL statement are distributed amongst [...]
Saturday, August 30th, 2003 by Mark Rittman
There’s an interesting article over at informationweek.com about Java Server Faces, a proposed new standard for building browser-based interfaces in Java. According to the article
“The little-known Java Server Faces will provide a standard way to build user interfaces for Java Web applications and open the way for highly customized and specialized components to be plugged [...]
Friday, August 29th, 2003 by Mark Rittman
A note on metalink advises that Analytic Workspaces built using Oracle 9i 9.2.0.3 will corrupt if the new 9.2.0.4 patchset is applied. According to the note;
“Please be advised that if you apply the 9.2.0.4.0 patch set to an OLAP 9.2.0.3 instance, previously functioning analytic workspaces may not be accessible after migration. It is our recommendation that OLAP [...]
Sunday, August 24th, 2003 by Mark Rittman
Standard Oracle relational theory tells you that, when putting data into a table, it doesn’t matter in which order you insert the data, as Oracle doesn’t guarantee the order in which it’s returned, unless you specifically use an ORDER BY clause. Therefore, you can’t rely on data coming back out from a table in the [...]
Saturday, August 23rd, 2003 by Mark Rittman
If you’re serious about tuning an Oracle server, you’ll probably be familiar with STATSPACK, a set of Oracle-provided SQL, PL/SQL and SQL*Plus scripts which help you collect, store and analyze performance data over a period of time. Statspack primarily queries the performance v$ views and collects information on memory usage, I/O usage patterns, high resource [...]
