Architect

What’s New from Database Development?
Andrew Mendelsohn, SVP, Database Development

The Top Questions You Asked Us
• The top features of Oracle Database 11g? • The upgrade paths toOracle Database 11g? • What’s new from development? • How can I convert old Forms applications? • What is MAA? • What’s coming next from development?

Oracle Database 11g
What are some of thetop features?
• Faster Performance
– Across the board

• Cube Organized Materialized Views
– Faster analytics

• SecureFiles
– Manage all your data

• Active Data Guard
–Productive standby resources

• Partitioning
– Divide & conquer large tables

• Manageability
– Reducing time & complexity

• Compression
– Manage more data for less

• Real ApplicationTesting
– Reducing risk of change

Faster Performance
Database Resident Connection Pool
2000%

Java Just-In-Time Compiler
12 10

Query Result Caching
140 120 100 80

In-MemoryDatabase Cache
1000 800 600 400

1500% 8 1000% 6

60 4 500% 2 0% N br C onne c t i ons 0 Sp e e d 40 20 0 Quer i es

200 0 TimesTen

Up to 20 x connections RAC Performance Enhancements180% 160% 140% 120% 100% 80% 60% 40% 20% 0% Quer y I nt ensi ve 20 0 80

Up to 11 x Faster Oracle Secure Backup
140 120 100 150

Up to 25% Faster Oracle Streams Enhancements
200

Upto 10 x Faster Optimizer Stats Collection
1000 800 600

100 60 40 50

400 200 0
R epl i cat i on

0 B ackup

Stats Collection

Up to 70% Faster

Up to 25% Faster

Up to 2 xFaster

Up to 10 x Faster

Oracle Secure Files
Manage all your data
Read Performance Write Performance

Mb/Sec

Secure Files Linux Files

Mb/Sec

Secure Files Linux Files

0 .01

0 .1

1

10

10 0

0 .0 1

0 .1

1

10

10 0

File Size (Mb)

File Size (Mb)

Oracle Partitioning
Divide and Conquer Large Tables
ORDERS ORDERS ORDERS >5000