Mark Rittman

Bud Endress has written an excellent paper on Oracle 10g OLAP new features which is currently available for download [https://www.oracleworld2003.com/published/40260/40260_Endress.doc] from the Oracleworld website. Some of the new features for the 10g OLAP option look pretty exciting, and the benefits of integration

More details about the new Oracle 10G and Application Server 10G are becoming available the closer we get to Oracleworld [http://www.oracle.com/oracleworld/sanfrancisco/conference/], and it's becoming clear that the 'grid' element of the new products is mainly an enhancement to the existing

There's an interesting article [http://www.informationweek.com/story/showArticle.jhtml?articleID=14100138] over at informationweek.com about Java Server Faces [http://java.sun.com/j2ee/javaserverfaces/], a proposed new standard for building browser-based interfaces in Java. According to the article "The little-known Java Server Faces will

A note on metalink [http://metalink.oracle.com/metalink/plsql/showdoc?db=Not&id=246955.1] 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

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&

If you're looking for some background reading on Oracle development, particulary to do with business intelligence and datawarehousing on Oracle 9i, i've put together a recommended reading list [http://www.rittman.net/stories/2003/08/23/recommendedOracleDevelopmentBooks.html] which you might find useful.

If you're serious about tuning an Oracle server, you'll probably be familiar with STATSPACK [http://www.engin.umich.edu/caen/wls/software/oracle/server.901/a87503/statspac.htm] , a set of Oracle-provided SQL, PL/SQL and SQL*Plus scripts which help you collect, store and analyze

Ameed Taylor, Chair of the E-Business Suite Customization and Extension SIG within the Oracle Applications User Group, has started up a weblog [http://ebizsig.blogspot.com/] on Oracle development. Ameed's aim is to try to keep his SIG members, and others with an interest in Oracle development, up

Oracle Discoverer [http://otn.oracle.com/products/discoverer/content.html] is the primary query and reporting tool that I use on data warehousing projects, and the latest version, Oracle 9iAS Discoverer, comes bundled with the Oracle 9i Application Server. With release 2 of 9iAS, Discoverer uses the Single Sign-on server

SQL Plus has a useful command called COPY that until now I had no idea about. It's an alternative to the IMP and EXP commands that lets you copy data between two SQL*Net connected databases. Using the syntax COPY FROM database TO database action - destination_table

Update on the 9i OLAP Spreadsheet Addin that was mentioned in a previous post [http://www.rittman.net/2003/08/14.html#a96]. Aneel Shenker has announced on OTN [http://www.oracle.com/forums/thread.jsp?forum=16&thread=193012&tstart=0&trange=15] that a 9i

This has got to be one of the funniest oracle-related threads [http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=3F29A3ED.C556674E%40exxesolutions.com&rnum=1&prev=/groups%3Fq%3Dnewbie%2Bcannot%2Blogin%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%

I'm in the process of taking my Oracle 9i Database Oracle Certified Professional [http://www.oracle.com/education/certification/index.html?dba9i_ocp.html] exams, and this afternoon passed the third of the exams, Oracle 9i Database : Performance Tuning [http://www.oracle.com/education/certification/objectives/index.html?

Brian Duff breaks the news [http://radio.weblogs.com/0128037/2003/08/13.html] that Oracle Jdeveloper 9.0.5 is now going to be know as Oracle Jdeveloper 10G. It’s been his task [http://radio.weblogs.com/0128037/2003/08/13.html] to search-and-replace all instances of 9.

This weekend was the hottest on record in the UK [http://news.bbc.co.uk/1/hi/uk/3138865.stm], and like most people in Brighton, I spent part of the weekend down at the beach. Here's a few photos [http://www.rittman.net/stories/2003/08/10/

Brian Duff, another one of the Oracle JDeveloper team, has started up a weblog [http://radio.weblogs.com/0128037/] on JDeveloper [http://otn.oracle.com/products/jdev], SCM [http://otn.oracle.com/products/repository/content.html] and user interfaces. Brian works with Steve Muench [http://radio.weblogs.com/0118231/] and

I've had two papers accepted for the forthcoming UK Oracle User Group Conference & Exhibition [http://conference.ukoug.org/], at the ICC in Birmingham in December. The first paper is entitled "Oracle 9i OLAP Uncovered" and the presentation is at 10.45 on December 10th. The

There's a good article over at Oraclebase about putting together efficient SQL statements [http://www.oracle-base.com/Articles/Misc/EfficientSQLStatements.asp] . It's easy these days to forget about the basics like these; the way in which you list tables, use aliases, and use comparisons like EXISTS

eWeek [http://www.eweek.com/] has details of the next version of Enterprise Manager [http://www.eweek.com/article2/0,3959,1054957,00.asp], due to be delivered as part of Oracle Application Server 10G. Highlights include: * Single view of all enterprise databases * Dynamic HTML interface * Patch tracking for individual

Oracle are going to start supporting PHP [http://www.php.net], the number one web scripting language [http://www.php.net/usage.php], with Oracle Application Server, according to this new PHP Statement of Direction [http://otn.oracle.com/tech/opensource/php/php_ohs_sod.html] just released on OTN.

This poster on OTN [http://www.oracle.com/forums/thread.jsp?forum=57&thread=192013&tstart=0&trange=15] asks whether future versions of OWB will support Oracle Streams [http://technet.oracle.com/products/dataint/htdocs/streams_fo.html]. Previously known as Change Data Capture, Streams captures

An interesting issue has cropped up with us, with a client who wishes to use OWB9.0.4 and now 9.2 on a Compaq Tru-64 platform. Previous versions of OWB were installed firstly on a client PC (usually a Windows PC), with the user then running wizards to create

Mark Van De Wiel at Oracle has pointed out a new viewlet demo [http://otn.oracle.com/products/warehouse/htdocs/OLAP_viewlet_swf.html] of the OLAP functionality in OWB9.2. It uses an early version of the upcoming 9.2.0.4 database patch (a.k.a. the 9.

Ronan Miles, UK Oracle User Group [http://www.ukoug.co.uk/] Chairman, on Oracle 10G: "I think grid computing will do for the computer what disk farms have done for disks" "Once, we were in awe of one disk and now it's a resource in

One of the new features that's expected to be included in Oracle 10G is HTML DB, a new rapid application development environment for Oracle web-based applications. Previously known as Project Marvel, details of what is now called HTML DB are available at the Project beta website [http://marvel.