Central Institute of Information Technology
®
Plot No.2, Near Jerryl Lawns, RPTS Road, Opp. ICAD Build., Laxminagar, Nagpur - 440022
Email: ciit_nagpur@yahoo.com Mobile: 9011501192
|
Home
|
Our Courses
|
Projects
|
Tips/Faq
|
Interview Questions
|
Jobs
|
About Us
|
Contact Us
|
Oracle 11g New Features
Automatic Memory Tuning : Memory can be tuned automatically by setting one parameter."PGA Update"
SQL Performance Analyzer, Using SPA, you can tell 11g to automatically apply SQL profiles for statements.
Automated Storage Load balancing
Automatic Diagnostic Repository
New table Data Type "simple_integer"
Improved table/index compression
Faster DML triggers
Server-side connection pooling
Introduction of Virtual columns
REF partitioning
Hangman Utility – The Hang Manager (hangman) utility is a new 11g tool to detect database bottlenecks.
Improved PHP driver for Oracle
Improved native Java & PL/SQL compilers
PL/SQL "continue" keyword
Disabled state for PL/SQL
New "pivot" SQL clause
© Central Institute of Information Technology - 2009