Oracle 11 g new features , PL-SQL Programming

Oracle 11 G new features associated with this release:-

Enhanced ILM - Information Lifecycle Management (ILM) has been around for the almost 10 years, but Oracle has made an influencing power to codify the approach in 11G.

File Group Repository - Oracle introduced an exciting new feature in 10gr2 dubbed the File group Repository (FGR).  The FGR allows the database to define a logically-related group of files and build a version control infrastructure.  Oracle file group repository were created to support Oracle Streams, and they mimic the functionality of in mainframe of IBM  generation data group (GDG), in that you can specify relative institutes of the file sets (e.g. generation 0, generation).

Interval partitioning for tables -

This is the process breaking that automatically developes time-based partitions as new data is added. This is a unique one! You can now partition by date, one partition per month for example, with automatic partition creation.

New table Data Type simple integer - A new 11g data type labeled simple integer is initiated. The simple integer data type is always NOT NULL, absorbs instead of overflows and is faster than ever.

Faster DML triggers - DML triggers are up to 25% faster. This especially effects row level triggers doing updates against other tables (think Audit trigger).

Invisible indexes - New 11ginvisible indexes are modern new features.  It comes that the invisible indexes will survive, that they can just be pointed as invisible so that they cannot be acknowledged by the SQL optimizer. With the responsibility of maintaining the index intact, I don't see why this is very effective. 

Optimized RAC cache fusion protocols - Moves on from the general memory fusion protocols in 10G to deal with specially scenarios where the databases could be further optimized.

Data Guard - Standby snapshot - This new feature of oracle 11G that surfaces database developers to encompass a snapshot for their regression testing.  They can accumulate standby snapshots and forward those into their QA databases, making sure that their regression test uses real production data.

Posted Date: 3/14/2013 2:23:41 AM | Location : United States







Related Discussions:- Oracle 11 g new features , Assignment Help, Ask Question on Oracle 11 g new features , Get Answer, Expert's Help, Oracle 11 g new features Discussions

Write discussion on Oracle 11 g new features
Your posts are moderated
Related Questions
Records Records are the items of the type RECORD. The Records have exclusively named fields that can store the data values of various types. And hence, a record treat associate

Using COUNT The COUNT returns the number of elements that a collection presently contains. For instance, when a varray projects contains 15 elements, then the following IF con

The requirements as follows: Create a folder called "SECURITY" on the server and upload all your project files to that folder. Please note, the "SECURITY" folder is NOT to be IN

TTITLE and BTITLE are commands in Pl-SQL to control report headings and footers. This Ttitle & Btitle are mainly used on creating SQL*PLUS report. Ttitle is used for toptitle headi

Parameter Aliasing   To optimize the subprogram call, the PL/SQL compiler can decide between the two techniques of the parameter passing. With the by-value techniques, the v

Row Operators The Row operators return or reference the particular rows. ALL retains the duplicate rows in the result of a query or in an aggregate expression. The DISTINCT el

SQL outer join SELECT * FROM IS_CALLED NATURAL LEFT JOIN IS_ENROLLED_ON Note that adding LEFT to an invocation of CROSS JOIN has no effect unless the right-hand operand

SQL Functions The PL/SQL uses all the SQL functions involving the following aggregate functions that summarize the whole columns of the Oracle data: GROUPING, AVG, COUNT, STDDE

Cursor FOR Loops In most cases that need an explicit cursor, you can simplify the coding by using a cursor FOR loop rather of the OPEN, FETCH, and CLOSE statements. A cursor FO

Example of WHEN or THEN Constraints A concrete example showing how SQL supports WHEN/THEN constraints CREATE TABLE SAL_HISTORY (EmpNo CHAR (6), Salary INTEGER NOT NULL,