What is new features in Oracle 11g?

What is new features in Oracle 11g?

Enhanced Finer Grained Dependency Management. DDL With the WAIT Option (DDL_LOCK_TIMEOUT) Invisible Indexes. Cross-Session PL/SQL Function Result Cache.

What is subprogram inlining in Oracle?

With subprogram inlining, Oracle will replace a call to a subroutine (such as a function) with the subroutine code itself during compilation. One of the benefits of this is that we can continue to write well-structured, modular code without any performance penalties.

Which directive is used to specify that individual subprogram calls are or are not to be Inlined?

INLINE pragma
The INLINE pragma specifies that a subprogram invocation is, or is not, to be inlined.

What is Plsql_optimize_level?

PLSQL_OPTIMIZE_LEVEL specifies the optimization level that will be used to compile PL/SQL library units. Applies a wide range of optimizations to PL/SQL programs including the elimination of unnecessary computations and exceptions, but generally does not move source code out of its original source order.

What is difference between 11g and 12c in Oracle?

Oracle 12c is just upgraded version of the Oracle 11g with some new features like cloud support and pluggable database, kind of like master slave architecture. With the Oracle 12 c, you can plug your database to cloud anytime. It has multiple new features like JSON support, multitenant architecture and etc.

What is the difference between Oracle 10g and 11g?

Difference between Oracle 10g and Oracle 11g Compared with Oracle 10g, the later version of Oracle 11g offers more simplified, automated, and advanced memory management tools and features. The latter is equipped with better abilities to diagnose faults via inbuilt infrastructure.

How do you handle exceptions in bulk collect?

Key components of bulk DML with exception handling:

1. A collection variable to hold the data.
2. The FORALL construct which iterates through values in the collection variable.
3. The SAVE EXCEPTIONS clause which tracks the exceptions being raised during bulk DML.

Which of the following is a non persistent collection?

Associative array (index-by table): This is the simplest form of non- persistent unbounded collections. As a non-persistent collection, it cannot be stored in the database, but they are available within a PL/SQL block only.

What is the difference between Pragma Exception_init and Raise_application_error?

much cleaner (i hate when others — should be outlawed). Raise_application_error is used to RAISE an error – exception_init is used to deal with errors (i guess you could say they are opposites in a way).

Can we use DDL statements in autonomous triggers?

Unlike regular triggers, autonomous triggers can contain transaction control statements such as COMMIT and ROLLBACK , and can issue DDL statements (such as CREATE and DROP ) through the EXECUTE IMMEDIATE statement.

What is Oracle 11g used for?

Version 11g of the Oracle Database, which included built-in testing for changes, the capability of viewing tables back in time, superior compression of all types of data and enhanced disaster recovery functions. The “g” stood for “grid computing,” which supports clusters of servers that are treated as a single unit.

Is Oracle 12c faster than 11g?

Data was transferred from 11g to 12c using datapump. You would think that, given the resources of the 2 machines and improvements to Oracle itself, the Oracle12c database would be roughly the same speed, but instead we’ve found that the Oracle 12c database was around 10-20% slower than 11g.