Oracle

JULY/AUGUST 2011

First Line of Defense Oracle Database Firewall monitors database conversations /19 Upgrade to Oracle Business Intelligence Enterprise Edition 11g Take advantage of the latest OLAP analysis, mapping, KPI, and scorecard features /43 Add Advanced List Interaction Use model-driven LOVs in Oracle ADF to implement smart lists /47 Control the Flow of Execution Part 2 in a series ofarticles on understanding and using PL/SQL /50 On Better Loading and Fact-Checking Our technologist enjoys the rule of external tables and debunks index scan myths /57

STORAGE FROM A TO ZFS
Rise of the Machines

How organizations optimize storage with tiered Sun flash, disk, and tape solutions from Oracle and enable unified storage with the Sun ZFS Storage Appliance

One organization lays afoundation for shared services with Oracle Exalogic and Oracle Exadata

First Line of Defense

Oracle Database Firewall monitors database tra c and blocks unauthorized activity

SUN ZFS STORAGE 7420 APPLIANCE

Trusted Trusted Future Future Protection Protection

Fujitsu's SPARC ENTERPRISE Fujitsu's SPARC ENTERPRISE delivers Trust and Business Continuity delivers Trust and BusinessContinuity
Fujitsu and Oracle together are creating UNIXUNIX history through progressive delivery of Fujitsu and Oracle together are creating history through progressive delivery of server solutions with with SPARC ENTERPRISE. customer commitment is reflected in in server solutions SPARC ENTERPRISE. Our Our customer commitment is reflected overwhelming performance and excellent reliability that thatprotect, grow, and expand, overwhelming performance and excellent reliability will will protect, grow, and expand, the unique value of your your business assets. the unique value of business assets. Please visit visit : www.fujitsu.com/oracle/ Please : www.fujitsu.com/oracle/
2011 FujitsuFujitsu Limited. All reserved. Fujitsu, the FujitsuFujitsu logo and SPARC Enterprise are registered trademarksor trademarks of 2011 Limited. All rights rights reserved. Fujitsu, the logo and SPARC Enterprise are registered trademarks or trademarks of FujitsuFujitsu Limited UnitedUnited and other countries. UNIX isUNIX is a registered trademark of open in the UnitedUnited and and Limited in the in the States States and other countries. a registered trademark of open group group in the States States othercountries. Oracle Oracle and Java are registered trademarks of Oracle and/or its affiliates. All SPARC trademarks are used under other countries. and Java are registered trademarks of Oracle and/or its affiliates. All SPARC trademarks are used under licenselicense and are registered trademarks of SPARC International. the UnitedUnited and other countries. and are registered trademarks of SPARCInternational. Inc. in Inc. in the States States and other countries.

2

FeatureD cOntent Volume XXV - Issue 4

cOntents

Storage from a to ZfS
most business users don’t spend much time thinking about storage. they follow a few simple guidelines and expect their critical information to be saved, backed up, and duplicated. the vast storage infrastructure that automates these activities islargely behind the scenes. yet as the demand for information grows, so do storage infrastructures. strategic storage solutions—from tape libraries to flash and disk arrays to unified storage—can simplify the essential tasks of storing and managing enterprise data management. Find out how Novant Health and the Australian Bureau of meteorology manage terabytes of new data every day with business-readystorage systems from oracle. —By David Baum

flash

/30

disc

rise of the machines / 36
oracle exalogic elastic Cloud is the world’s first engineered system specifically designed for implementing a private cloud computing environment that can host everything from small-scale departmental applications to large-scale enterprise resource planning systems. since its debut at oracle...