PeopleSoft Learning

Oracle Database 11g Top New Features:

Database Replay

Explore Database Replay, the new tool that captures SQL statements and lets you replay them at will.

Transaction Management

Get an introduction to Flashback Data Archive and explore Enterprise Manager's Log Miner interface.

SQL Plan Management

Use bind variables that pick the right plan every time and ensure a new execution plan is perfect before it's used.

SQL Access Advisor

Get advice about optimal table design based on actual use of the table, not just data.

RMAN

Explore Data Recovery Advisor, do parallel backup of the same file, and create and manage virtual catalogs.

Automatic Storage Management

Learn about new SYSASM role, variable extent sizes, and other ASM improvements

Schema Management

Add columns with a default value easily and explore invisible indexes, virtual columns, and read only tables.

SQL Performance Analyzer

Accurately assess the impact of rewriting of SQL statements and get suggested improvements.

Manageability

Explore automatic memory management, multicolumn statistics, online patching, and more features.

PL/SQL: Efficient Coding

Triggers that fire several times at different events and ability to force triggers of the same type to follow a sequence are some new gems.

Thanks

D.Sasi Kumar