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

Procedural constraint enforcement (triggers) , Procedural Constraint Enforc...

Procedural Constraint Enforcement (Triggers) SQL has an alternative method of addressing database integrity, involving event-driven procedural code. The special procedures th

An active database in pl-sql, Consider the following set of database tables...

Consider the following set of database tables (same tables from Assignment 6-1). Please take note of foreign keys (most of them carry the same names as the corresponding primary ke

Triggers, At times, customers make mistakes in submitting their orders and ...

At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a trigger that automatically updates the stock level of all pr

Referencing records, Referencing Records Unlike the elements in a coll...

Referencing Records Unlike the elements in a collection, that are accessed using subscripts, the fields in a record are accessed by name. To reference an individual field, you

Explicit cursors, Explicit Cursors The set of rows returned by the que...

Explicit Cursors The set of rows returned by the query can include zero, one, or multiple rows, depending on how many rows meet your search criteria. Whenever a query returns

Iterative control: loop statement, Iterative Control: LOOP  Statements T...

Iterative Control: LOOP  Statements The LOOP statement executes a series of statements multiple times. There are 3 forms of LOOP statements: LOOP, WHILE-LOOP, & FOR-LOOP. LOOP

Committing and rolling back - autonomous transaction, Committing and Rollin...

Committing and Rolling Back The COMMIT and ROLLBACK end the active autonomous transaction but do not exit the autonomous routine. As the figure shows, if one transaction ends,

Example of tables within a table - sql, Example of Tables within a Table - ...

Example of Tables within a Table - SQL Example: Obtaining C_ER from COURSE and EXAM_MARK SELECT CourseId, CAST (TABLE (SELECT DISTINCT StudentId, Mark FROM EXAM_MARK AS EM

Methods in pl/sql, Methods: In normal, a method is a subprogram declar...

Methods: In normal, a method is a subprogram declared in an object type specification using the keyword MEMBER or STATIC. The method cannot have similar name as the object typ

Mechanistis theory-haeckel - origin of life, MECHANISTI S THEORY-HAECKEL (...

MECHANISTI S THEORY-HAECKEL (1866) - Haeckel stating that after each catalysm, some new organism suddenly forms as a chance event in one stride from inanimate matter and sub

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