Oracle 11g new Features

1.Exadata is the hardware that combines the power of the database.

Flash: Unlike database Flash, this is a cache of resident SGA buffers based on the file extension (similar to swap), providing a level two cache for the database. The file is used when the database is swapped out for the SGA.

Storage index: Enables queries to run faster with minimum/maximum values. Summary information for the main maintenance data. The memory structure resides at the storage unit level. For a storage unit, the storage index can store up to 8 minimum/maximum values for the query table columns. The storage index indicates how the data is stored on the storage unit (just like the minimum/maximum value of the partition).

2. Advanced compression

Allow data to remain compressed while updating and inserting tables

CREATE TABLE Emp_1

(

EMPNONumber (4),

SALNumber (7,2)

) COMPRESS for OLTP;

Nocompress: The table or partition is not compressed, which is the default action.

COMPRESS for all OPERATIONS: suitable for OLTP systems. All operations, including regular DML statements, are enabled for compression.

COMPRESS for OLTP: suitable for OLTP systems. All operations, including regular DML statements, are enabled for compression.

3. Automated Diagnostics Database ADR

It provides a unified and consistent mechanism for storing, formatting and locating all database diagnostic information (easy-to-use file structure). If you want to automate the process of cleaning up your files, you must use a custom process to clean them up manually. Command-line interface (ADRCI) with ADR and ADR. You can set policies that control when these files are saved:

Adrci> Set Control (shortp_policy = 360)

Adrci> Set Control (Longp_policy = 4380)

When using ADR, the position becomes the parameter diagnostic_dest specified. If Oracle_base is set in the environment variable, then Diagnostic_dest will be set to $oracle_base

4. Automatic shared memory Management ASMM improvements

In order to use automatic memory management (ASMM) to manage the SGA and Pga,oracle company introduced two new database parameters: Memory_target and Memory_max_target.

The Linux Huge Pages and Memory_target parameters are incompatible

The value of the memory_target is less than the operating system shared memory file system/DEV/SHM, and the/DEV/SHM free space must be greater than the Memory_target setting when the database starts.

If the LOCK_SGA database initialization parameter is set to TRUE, you cannot use the parameter Memory_target to enable automatic memory management.

Improvements in 5.ASM

Improvements to ASM in 1.ORACLE11G include reduced database startup time and memory requirements, allowing for larger ASM files and the ability to implement hundreds of-terabyte or petabytes of databases on ASM.

2. Read from ASM preferred image

Suppose there are two sites called site1 and site2,asm disk groups DATA1 have two failgroup named SITE1 and SITE2, respectively

For site1:

Asm_preferred_read_failure_group=data1. SITE1

For Site2:

Asm_preferred_read_failure_group=data1. SITE2

3. Rolling upgrade/Patching

Rolling migration mode allows ASM instances to temporarily work in multiple versions of the ASM environment.

To start a rolling upgrade:

Alter system start rolling migration to <ver_number>;

If you experience problems with a rolling upgrade, stop the upgrade or downgrade:

Alter system stop rolling migration;

4. Faster Rebalancing

The Disk_repair_time property allows you to define a time window that can be serviced or synchronized during that time, and the mirrored disk can be re-launched in that time window. Disk_repair_time default is 3.6 hours, but alter DiskGroup modifies

Alter DiskGroup <Diskgroupname> set ATTRIBUTE ' disk_repair_time ' = ' 24H ';

All disk groups can be brought back online by command (you can replace all with disk<diskname> for individual disk groups) and start the resynchronization process:

Alter DiskGroup disk online all;

ORACLE11G allows disk groups to be mounted in restricted mode, thereby eliminating the need for locking and unlocking messages between multiple ASM instances during rebalancing operations.

Alter DiskGroup <diskgroup> dismount;

Alter DiskGroup <diskgroup> Mount restricted;

Perform maintenance activities (rebalance/Add/remove/online/offline disks, etc.)

Alter DiskGroup <diskgroup> dismount;

Alter DiskGroup <diskgroup> Mount;

5.ASM Disk Group Compatibility

The new properties Compatible.asm and Compatible.rdbms are set at the disk group level and may be useful when it is necessary to downgrade:

Create DiskGroup data1 Normal redundancy disk '/dev/raw/raw1 ', '/dev/raw/raw2 ' attribute ' compatible.asm ' = ' 11.1 ';

Alter DiskGroup Data1 set attribute ' Compatible.rdbms ' = ' 11.1 ';

Select Group_number gn,name,compatibility compat,database_compatibility dcompat from V$asm_diskgroup;

6.ASMCMD Command Extensions

CP: Copying files between the ASM Disk group and the operating system file system

ASMCD>CP +asm1/system.dbf/backups/orcl/system.dbf

Md_backup: Backing up disk group metadata

asmcmd> md_backup-b/backups/orcl/asmbackupfile.md-g ASM1

Md_restore> Recovering Disk Group metadata

Asmcmd>md_restore-b/backups/orcl/asmbackupfile.md-t full-g ASM1

LSDSK: List disk information

Asmcmd>lsdsk

REMAP: The remapping of bad blocks on the specified data blocks

Asmcmd>remap <diskgroup name> <disk name> <block range>

SYSASM privilege: Specify a new role for ASM, such as SYSDBA.

Sql>grant sysasm to <username>;

Sql>connect <username> as Sysasm;

6. Automatic SQL optimization

Enable and disable automatic SQL optimization

exec dbms_auto_task_admin.enable (client_name = ' SQL tuning advsor ', operation = Null,window_name = NULL);

exec dbms_auto_task_admin.disable (client_name = ' SQL tuning advsor ', operation = Null,window_name = NULL);

Configuring Automatic SQL Optimization

exec dbms_sqltune.set_tuning_task_parameter (task_name = ' sys_auto_sql_tuning_task ', parameter = ' Accept_sql_ PROFILES ', value = ' TRUE ');

Interrupt_tuning_task: Interrupts the task in progress, obtains intermediate results, and exits normally

Resume_tuning_task: Resuming a previously interrupted task

Cancel_tuning_task: Cancel the task in progress, clear all the results of the task

Reset_tuning_task: Resets the task in progress, clears all results of the task and returns to its initial state

Drop_tuning_task: Deletes a task and clears all results related to the task.

7. Data Defender (DG) enhancements

1. Snapshot backup

2. Activity DG

3. Hybrid platform Support

One of the extensions that oracle11g adds is that the physical standby database can be located in a different operating system than the primary database.

4. Advanced compression support logical standby database 11GR2

5. Transparent data encryption supports logical standby database

6. Enhanced Data Pump compression

7. Data pump encryption dump file set

8. Traditional mode of data pump

Scripts and parameter files that are created to be compatible with the original export and import tools

8. Enhanced statistical information

1. Enhanced IO Statistics

2. Reduce the collection of statistical information on partitioned objects

3. Pending statistics

This feature keeps the newly collected statistics in a suspended state until you decide to publish them. By default, statistics are automatically released when the collection operation is complete. The pending statistics are controlled by the Dbms_stats package and the optimizer_use_pending_statistic database initialization parameter.

To view pending statistics settings:

Sql> Select Dbms_stats.get_prefs (' PUBLISH ') PUBLISH from DUAL;

Set auto-publish global pending statistics (default)

Sql>exec dbms_stats.set_clobal_prefs (' PUBLISH ', ' TRUE ');

Set not to automatically publish global pending statistics:

Sql>exec dbms_stats.set_global_prefs (' PUBLISH ', ' FALSE ');

4. Multi-column statistical information

5. Expression statistics

9. Flash Back Data archive Fbda

10. Health Monitor

This is done through the DBMS_HM package.

DB Structural Integrity check

Data Block Integrity check

Redo Log Integrity Check

Undo Segment Integrity Check

Transaction integrity Check

Data dictionary Integrity check

11. Event Packaging Service IPs

$adrci

Adrci>help IPs

Adrci>show incident

Show No. 9817, event is about ORA-600[XYZ]

Adrci>ips Create Package Incident 9817

Adrci>ips Add incident 9817 Package 4

Adrci>ips Add File

Adrci>ips Generate package 4 in/tmp

12. Non-visual index

Create INDEX My_index on my_table (ename) invisible;

Creating non-visual indexes

Alter session Set optimizer_use_invisible_indexes = true;

Modify to visible in a separate session

13. New zoning Features

1. Interval partitioning

Oracle would have an error if no value range of a particular partition could match the value to be inserted. The new feature extends the functionality of partitioning, and you can use intervals to define partitions of equal size, including future partitions. When partitioning is used, Oracle automatically creates new partitions when needed. The new partition is created when the first record of the partition is inserted.

2.REF Partitioning

If you create a partitioned index on a parent table in parallel, you cannot create a child table that contains a ref partition, and you will get an error.

To circumvent this problem, you can create a sub-table for the ref partition, and then create a partitioned index on the parent table.

3. System Partitioning

You must specify a partition for your data, and you do not need to indicate a specific partition when you update or delete it. The system partition does not have a concept of partition boundaries, so when a statement is executed, unless the partition is explicitly specified, Oracle has to scan all partitions to see which partition the operation's data is in.

4. Virtual Column Partitioning

The virtual column looks like a normal column, allowing an expression to use one or more physical columns on the partition key. For example, if you have a column of monthly_salary in your table, you can add a virtual column that multiplies the column by 12 (representing the yearly salary). The virtual column does not actually store the data (although a physical index is created on the virtual column, but it is actually a function-based index), and the virtual column partition supports all partition policies and can be partitioned using scopes, lists, and hashes.

5. Divisional Advisors

14. read-only table

15.RAC one Node and RAC patching

The RAC one node indicates that the Oracle RAC database is running only on an active Oracle instance and, like an Oracle RAC database, can be managed using server control tools.

16. Real Application Test RAT

Database Replay

17.SQL Performance Analyzer SPA

18. Result set Caching

SYSDBA The result set cache is not available when logging into the database

New features of 19.RMAN

Active database replication

20. Security Files

Oracle security files, also known as fast files, are Oracle's improvements to large object LOB type storage.

This article is from the "linux_oracle" blog, make sure to keep this source http://pankuo.blog.51cto.com/8651697/1631325

Oracle 11g new Features