Blog / August 27, 2019

What are the features of Oracle 11g?

Miscellaneous New Features in Oracle Database 11g Release 1

Online Table Redefinition Enhancements.
Enhanced Finer Grained Dependency Management.
DDL With the WAIT Option (DDL_LOCK_TIMEOUT)
Invisible Indexes.
Cross-Session PL/SQL Function Result Cache.
Query Result Cache.
Adaptive Cursor Sharing.

What is the use of V SQL in Oracle?

V$SQL lists statistics on shared SQL areas without the GROUP BY clause and contains one row for each child of the original SQL text entered. Statistics displayed in V$SQL are normally updated at the end of query execution.

What is SQL area in Oracle?

Shared SQL and PL/SQL areas are shared memory areas. Any Oracle process can use a shared SQL area. Shared SQL areas reduce memory usage on the database server, thereby increasing system throughput.

What is V session in Oracle 11g?

V$SESSION displays session information for each current session. Used to uniquely identify a session’s objects. Guarantees that session-level commands are applied to the correct session objects if the session ends and another session begins with the same session ID.

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?

What is the difference between 10g and 11g? Compared with 10g, 11g provides more simplified, improved and automated memory management and better ability to diagnose faults through inbuilt infrastructure to prevent, detect, diagnose, and help resolve critical database errors, as well as, low database performance issues.

What is V SQL?

V$SQL lists statistics on shared SQL area without the GROUP BY clause and contains one row for each child of the original SQL text entered. Statistics displayed in V$SQL are normally updated at the end of query execution. However, for long running queries, they are updated every 5 seconds.

What is Oracle v session?

What is the difference between V SQL and V Sqlarea?

v$sql will have 2 rows. v$sqlarea is a aggregate of v$sql. It selects out DISTINCT sql. “select * from T” will appear there.

What is the difference between GV session and V session?

V$ views contain statistics for one instance, whereas GV$ views contain information from all the active instances. Each GV$ view contains an INST_ID column of type NUMBER, which can be used to identify the instance associated with the row data.

What is Sid in V session?

RAW(4 | 8) Session address. SID. NUMBER. Session identifier.

What is difference between 10g and 11g?

What’s new in Oracle 11g?

Now in 11g, Oracle closes the loop and offers intelligent automation tools to create a self-healing database. The most important 11g new automation features include a SQL tuning advisor that automatically tunes SQL statements.

Can Oracle 11g call PL/SQL from SQL?

Oracle 11g allows positional, named and mixed notation to be used when calling PL/SQL from SQL, as shown below. — Build a test function with multiple parameters.

What is the use of the variable V$sqlarea?

V$SQLAREA lists statistics on shared SQL area and contains one row per SQL string. It provides statistics on SQL statements that are in memory, parsed, and ready for execution.

What is SQL tuning in Oracle Database?

Because the manual SQL tuning process poses many challenges to the application developer, the SQL tuning process has been automated by the automatic SQL tuning features of Oracle Database. These features are designed to work equally well for OLTP and Data Warehouse type applications: Chapter 17, “Automatic SQL Tuning”.