Oracle 11 g new features , PL-SQL Programming

Assignment Help:

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.


Related Discussions:- Oracle 11 g new features

Named notation, Named Notation The second procedure call uses the name...

Named Notation The second procedure call uses the named notation. An arrow (=>) serve as the relationship operator that associates the formal parameter to the left of the arro

How exceptions propagate in pl/sql programming?, How Exceptions Propagate ?...

How Exceptions Propagate ? Whenever an exception is raised, and if the PL/SQL cannot find a handler for it in the present subprogram or block, the exception propagates. That is

Union without corresponding - sql, UNION without CORRESPONDING - SQL T...

UNION without CORRESPONDING - SQL The use of UNION without CORRESPONDING. Example is merely by omitting CORRESPONDING, but only because the operands have identical SELECT clau

Declaring and initializing objects in pl/sql, Declaring and Initializing Ob...

Declaring and Initializing Objects: An object type is once defined and installed in the schema; you can use it to declare the objects in any PL/SQL, subprogram, block or packa

Is null operator-comparison operators, IS NULL Operator The IS NULL oper...

IS NULL Operator The IS NULL operator returns the Boolean value TRUE whenever its operand is null or FALSE if it is not null. The comparisons including the nulls always yield NU

Example of not exists operator - sql, Example of NOT EXISTS Operator - SQL ...

Example of NOT EXISTS Operator - SQL Example is a translation into SQL of the corresponding example, which is included there merely to show that for any scalar comparison the

Begin parameter description in pl sql, BEGIN Parameter Description in pl sq...

BEGIN Parameter Description in pl sql: BEGIN: This keyword signals the beginning of the executable section of a PL/SQL block, that contains executable statements. The execut

Custom ms access database designed, I would like to have a custom MS Access...

I would like to have a custom MS Access database designed and coded that would help me schedule my customer's orders and that would help me track my employees production output and

Rownum - sql pseudocolumns, ROWNUM The ROWNUM returns a number represe...

ROWNUM The ROWNUM returns a number representing the order in which a row was selected from the table. The first row selected has a ROWNUM of 1; the second row has a ROWNUM of

Parameter and keyword description - fetch statement, Parameter and Keyword ...

Parameter and Keyword Description: cursor_name: This identifies an explicit cursor formerly declared within the present scope. cursor_variable_name: These identif

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd