Oracle

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 »

Tags: oracle, sql, views

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 »

Render SQL*Plus output in HTML

SQL*Plus has traditionally been thought of as a plain text SQL query tool. But since Oracle 8i, it has also had the capability to render its output using HTML. 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 »

Control null data in Oracle using the ORDER BY clause

NULL data, which is sometimes called "absent" data, can be difficult to work with in relational databases. Learn how to control null data in Oracle using the ORDER BY clause. Read more »

Understanding roles in Oracle-stored procedures

Permissions in Oracle granted indirectly via roles are not available when compiling stored procedures, functions, and packages. Direct grants are required when creating these objects in the database. 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 »

Switching Oracle Portal to a new database is easier than Oracle Tech Support says

If you do not have to support an Oracle Portal, consider yourself lucky. We recently ran into a problem that forced us to quickly move to a new metadata database. Read more »

Log in


Sign up | Forgot your password?

Blogs

RSS feed

  • Staff Microsoft prescribes more REST

    Details have begun to emerge about the next versions of Visual Studio and Windows Server this week -- and the message from Redmond is to REST up Read more »

    -- posted by Staff

  • Chris Duckett .NET looks to REST

    With news that REST will play a big part in the next version of the .NET Framework, it is timely to take a look at ADO.NET. Read more »

    -- posted by Chris Duckett

  • Renai LeMay Spellr.us needs a new dictionary

    One of the only Australian start-ups to present at the recent round of conferences in the US was Sydney-based spellr.us, which has launched a Web-based tool to check and monitor websites for spelling mistakes. Read more »

    -- posted by Renai LeMay

What's on?