News (13)

Oracle touts 11g, hopes for rapid upgrade cycle

Oracle has been talking up its latest database offering -- but the signs are that Oracle customers will wait a few years before moving to 11g. Read more »

Winemaker turns to ERP, predictive modelling

McGuigan Simeon Wines is deploying enterprise resource planning software as part of a wider initiative to deploy systems to support just-in-time wine storage and distribution. Read more »

Patched Oracle database 'still vulnerable'

The latest update for Oracle 10g Release 2 does not plug a hole that allows published attack code to run, according to a security researcher. Read more »

Sydney Water taps BI specialist

Sydney Water has called for help with its burgeoning business intelligence (BI) program, with data associated with the utility's water quality and hydraulics monitoring operations identified as an early project priority. Read more »

Oracle grabs Sleepycat

The open source embedded database specialist has become Oracle's latest acquisition. Read more »

Oracle aims to tone security muscle with Fusion

Billions of dollars worth of acquisitions have bought Oracle a perhaps unexpected bonus: security lessons. Read more »

IBM sets DB2 database free

IBM on Monday introduced a free version of its DB2 database, a move designed to win software developers over to its products. Read more »

Oracle to offer free database

Oracle intends to release a free version of its database, a reaction to the growing competitive pressure from low-end open-source databases. Read more »

Oracle 10g release two arrives

This month should see the release of the a more secure version of Oracle's grid database. Read more »

IBM seeks to ease database burden

IBM next week will release a major revision of its DB2 database, providing fresh ammunition in the ongoing battle for supremacy in the database marketplace. Read more »

More Oracle 10g News Results

Features (15)

Move SQL Tuning Sets between Oracle instances

SQL Tuning Sets (STS) capture the workload of an Oracle instance. Starting in Oracle 10g Release 2, these tuning sets can be transported from one instance to another to facilitate testing. Read more »

Gather query tuning data via Oracle's dynamic performance views

The dynamic performance views supplied with the Oracle database include several that make the process of gathering tuning information easier. This tip describes four of them: V$SQL, V$SQLAREA, V$SQLTEXT, and a new one, V$SQLSTATS. Read more »

Copy legacy Oracle tables with SQL*Plus

Tables with a LONG datatype cannot be copied via the CREATE TABLE AS SELECT syntax. They can, however, be copied with the SQL*Plus COPY command. This Oracle tip shows you how. Read more »

Encrypt backups using Oracle 10gR2's RMAN

No IT pros want their company to make headline news because of a data breach. You can make your data less vulnerable to theft by using a new feature in Oracle 10g Release 2 that lets you make encrypted backups via Recovery Manager. Read more »

Explore Oracle 10g's updated sample schemas

Each new release of Oracle database brings with it new features to explore. It can be a challenge to create adequate sample tables to play with a given feature. Read more »

Set named restore points for easier flashback in Oracle 10gR2

The MERGE statement, introduced in Oracle 9i Release 2, is often called an "upsert" because it can both update and insert rows in the same pass. Rows that don't already exist in the data warehouse are inserted, and rows that do exist are updated. Read more »

Capture an Oracle 10g audit trail in XML format

The Oracle database has long had the ability to audit selected types of operations against the database, storing the audit trail in a system table. This table, SYS.AUD$, resides in the data dictionary. On some operating systems, you can also write audit records to the operating system's own event logging subsystem. Read more »

Sending e-mail from an Oracle database with utl_smtp

If you're running Oracle 10g or later, you can use the nice modern utl_mail package to send e-mails from your PL/SQL applications. If you're running an earlier version of Oracle, you can send e-mails via the older and more complicated utl_smtp package. Read more »

Navigating Oracle's public online documentation

Here's a quick guide to navigating Oracle's public online documentation library, which contains hundreds of books. Bob Watkins also offers a rundown of his favorite offerings in the collection. Read more »

Multi-dimensional modeling in Oracle SQL

Starting in Oracle 10g, you can treat the output of your query as if it were a spreadsheet and perform calculations upon individual cells of the output. You can even generate new rows of output that weren't in the original table. We'll show you how. Read more »

More Oracle 10g Features Results

Log in


Sign up | Forgot your password?

Blogs

RSS feed

  • Staff Crying, mooning and leaving

    In this week's roundup we see that continuous whining can get results, Linux users get 64-bit Flash and Moonlight previews, the latest in the Yahoo/Microsoft relationship and Senator Conroy ducks and weave in Senate Question Time. Read more »

    -- posted by Staff

  • Brendon Chase Sun eye Web developers with Netbeans 6.5

    Despite the recent employment axe hitting Sun the company has pushed out a new release of its Netbeans open source IDE with an eye to appeal more to Web developers. Read more »

    -- posted by Brendon Chase

  • Renai LeMay BarCamp buzz: Let the hacking continue

    Attending last weekend's BarCamp in Sydney, it was hard to escape the conclusion that a certain "dot-com bust" flavour had seeped into the kool aid previously being drunk by Australia's web 2.0 and early stage start-up sector. Read more »

    -- posted by Renai LeMay

What's on?