Answer / kebiraj

# Flashback Enhancements -Flashback Version Query, Flashback
Transaction Query, LOB Handling with Flashback, Setting up
for Flashback, Flashback Table, Flashback Drop Table and
Recycle Bin management.

# Backup and Recovery Enhancements - Flash Recovery Area,
Flashback Database (setup, flashback logs and use), Restore
Points, Simplified Recovery through RESETLOGS, Compressed
Backups, Change Tracking, Incrementally Updated Image
Copies, SWITCH DATABASE, New V$ Views, Encrypted Backups,
DROP DATABASE, CATALOG, Oracle Secure Backup and more.

# Automatic Storage Management - An introduction to Oracle's
new integrated file system and volume manager. Examples
illustrate the basic use of ASM, including creating disk
groups, fail groups, and using ASMCMD.

# Job Scheduler - Use the new DBMS_SCHEDULER package to
schedule jobs, including OS scripts. Examples illustrate
creating and scheduling jobs in both a Linux and a Windows
environment.

# SQL Enhancements - Regular expressions, DML error logging,
case-insensitive sort and search, MERGE enhancements, MODEL
queries, XQUERY and much more.

# PL/SQL Enhancements -The new optimizing compiler, compiler
warning messages, debugging improvements, native compilation
enhancements, UTL_MAIL and more.

# Performance and Tuning Features - Automatic SGA
Management, Automatic Workload Repository (AWR), Advisors
(ADDM, SQL Tuning Advisor, etc), Active Session History
data, new performance statistics (e.g. metrics and database
time), Thresholds and Server-Generated Alerts, CBO
Enhancements and much more.

# Security and Auditing Enhancements - Changes to the
CONNECT Role, FGAC Review, FGAC / VPD Enhancements, FGA
Review, Fine Grained Auditing Enhancements, Encryption
Enhancements, DBMS_CRYPTO Package (R1) and Transparent Data
Encryption (R2).

# Tablespace, Table and Segment Management - SYSAUX
tablespace, BIGFILE and SMALLFILE tablespaces,
database-level default tablespace, database-level default
temp tablespace, temp tablespace groups, multi-platform
transportable tablespace, renaming tablespaces, predicting
object growth, online table redefinition enhancements and
online segment shrink.

# Utilities (Data Pump) - An example-based introduction to
Data Pump, the next generation export / import utility. Also
covered: External Table and Logminer enhancements.

# SQL*Plus Enhancements - New predefined variables, SPOOL
command enhancements, AUTOTRACE enhancements and more.

# Miscellaneous Enhancements - Guaranteed UNDO retention,
ROLLBACK monitoring, Easy Connect (EZCONNECT) connections,
database high watermark recording, database feature usage
tracking and new and deprecated initialization parameters.

What are analytical functions in sql?

0 Answers  

---

what are different types of collation sensitivity? : Sql dba

0 Answers  

---

tell us something about heap tables. : Sql dba

0 Answers  

---

How to add Foreign key in a table after the creation of the table?

5 Answers   Satyam,

---

What is the difference between microsoft sql and mysql?

0 Answers  

---

---

What is mutating error?

0 Answers  

---

What is prepared statement in sql?

0 Answers  

---

what are the types of subquery? : Sql dba

0 Answers  

---

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

0 Answers  

---

What is sql and how does it work?

0 Answers  

---

In pl/sql, what is bulk binding, and when/how would it help performance?

0 Answers  

---

What is a database? Explain

0 Answers  

---