0
What is Oracle 11g and what are some new features of Oracle 11g?
Wiki User
∙ 12y ago
Orable 11g is a database. There are new features for DBA's and Developers. A new feature would be simple_integer, a new data type said to be faster than pls_integer.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
How many hours required to learn oracle 11g for person who knows oracle 8i?
At least 2. The paperwork is tremendous! :-) All jokes aside, it depends on how quickly you learn and how well you know 8i. There are some significant new concepts, plus features and more than a few new functions. You could read a quick overview in a couple of hours. But serious study to be able to use the changes could easily take more than a week.
What is the syntax that can be use to get a text file from a directory using oracle 9i?
The UTL_FILE package provides that support in Oracle 9i. Oracle 11g supports a new feature known as Oracle External Tables (OET), which has many advantages over UTL_FILE, though OET can't replace all the functionality in UTL_FILE (yet).
What is the full form of oracle 9i?
what is difference between oracle 9i and oracle 10g what is difference between oracle 9i and oracle 10g What is the Full form of "i" in Oracle 9i What is the Full form of "g" in Oracle 10g ans =the oracle 9i the "i" is stands for internet and oracle 10g the " g" stands for grid and new version of oracle 11g was launch in 2007 it provided the special feature rather 8i ,9i other it have a RAC, and network security etc. and good for organization purpose .
What is invisible indexes in oracle 11g?
An invisible index is maintained for any DML operation but is not used by the optimizer unless you explicitly specify the index with a hint. Applications often have to be modified without being able to bring the complete application offline. Create invisible indexes temporarily for specialized non-standard operations, such as online application upgrades, without affecting the behavior of any existing application. Furthermore, invisible indexes can be used to test the removal of an index without dropping it right away, thus enabling a grace period for testing in production environments. - From Oracle 11g Database New Features manual
Difference between Oracle 11g and 11i?
1.Simplified and improved automatic memory management 2.New fault diagnosability infrastructure to prevent, detect, diagnose, and help resolve critical database errors 3.Invisible Indexes 4.Virtual columns 5.Enhanced security for password-based authentication by enabling use of mixed case in passwords. 6.Tablespace-level encryption 7.Ability to online redefine tables that have materialized view logs Thease are only few enhancements , you can find more detail in the doc suggested by SaRa.
What are some features of the new memorial?
what are some features of new memorial
Oracle 9i means?
i means internet in Oracle 9i which means ready to use. Oracle 9i includes extensive features like high security, new caching facility and many more. In particular the application clusters of oracle 9i has the capacity of rapidly adding the nodes and disks.
What are the emerging trends in database technology?
There are number of new technologies in database, the one prevailing in industry is No-SQL.No-SQL is a database that is used to handle the unstructured data which is not possible in SQL. Example of some No-SQL database are MongoDB , Cassandra, CouchDB etc.
What is the different version of oracle?
Early versions of the oracle did not bear the latest features added to the latest version of the oracle. There are series of new features implemented in the newer version of the oracle.new features are:New "pivot" SQL clause - The new "pivot" SQL clause will allow quick rollup, similar to an MS-Excel pivot table, where you can display multiple rows on one column with SQL. MS SQL Server 2005 also introduced a pivot clause. Laurent Schneider notes that the new SQL "pivot" syntax is great for converting rows-to-columns and columns-to-rows.The /*+result_cache*/ SQL hint - This suggests that the result data will be cached in the data buffers, and not the intermediate data blocks that were accessed to obtain the query results. You can cache SQL and PL/SQL results for super-fast subsequent retrieval. The "result cache" ties into the "scalable execution" concept. There are three areas of the result cache:The SQL query result cache - This is an area of SGA memory for storing query results.The PL/SQL function result cache - This result cache can store the results from a PL/SQL function call.The OCI client result cache - This cache retains results from OCI calls, both for SQL queries or PL/SQL functions.Scalable Execution - This 11g feature consists of a number of features, the first of which is query results caching; this feature automatically caches the results of an SQL query as opposed to the data blocks normally cached by the buffer cache, and works both client (OCI) and server side - this was described as "buffer cache taken to the next level". The DBA sets the size of the results cache and turns the feature on at a table level with the command "alter table DEPT cache results", the per-process cache is shared across multiple session and at the client level, is available with all 11g OCI-based clients. Mark RittmanXML SQL queries - Oracle11g will support query mechanisms for XML including XQuery and SQL XML, emerging standards for querying XML data stored inside tables.SQL Replay - Similar to the previous feature, but this only captures and applies the SQL workload, not total workload. Source: Dr. Tim HallImproved optimizer statistics collection speed - Oracle 11g has improved the dbms_stats performance, allowing for an order of magnitude faster CBO statistics creation. Oracle 11g has also separated-out the "gather" and "publish" operations, allowing CBO statistics to be retained for later use. Also, Oracle 11g introduces multi-column statistics to give the CBO the ability to more accurately select rows when the WHERE clause contains multi-column conditions or joins.SQL execution Plan Management - Oracle 11g SQL will allow you to fix execution plans (explain plan) for specific statements, regardless of statistics or database version changes. See Inside the 11g SQL Performance Advisor.Dynamic SQL. DBMS_SQL is here to stay. It's faster and is being enhanced. DBMS_SQL and NDS can now accept CLOBs (no more 32k limit on NDS). A ref cursor can become a DBMS_SQL cursor and vice versa. DBMS_SQL now supprts user defined types and bulk operations. Source: Lewis CunninghamSQL Performance Advisor - You can tell 11g to automatically apply SQL profiles for statements where the suggested profile give 3-times better performance that the existing statement. The performance comparisons are done by a new administrative task during a user-specified maintenance window.Improved SQL Access Advisor - The 11g SQL Access Advisor gives partitioning advice, including advice on the new interval partitioning. Interval partitioning is an automated version of range partitioning, where new equally-sized partitions are automatically created when needed. Both range and interval partitions can exist for a single table, and range partitioned tables can be converted to interval partitioned tables.Oracle 11g SQL tuning transformations
What are the features of India?
some features of India are, the Taj Mahal, the golden valley, the capitol; new dehli
What are some unique features in New Jersey?
Its name
What are some of new jerseys geographical features?
Butt cracks
