Fast-start fault recovery This feature provides fast and predictable recovery from system failures. Virtual Private Database This feature provides functionality to create security policies that implement row-level security. Fine-grained auditing This features allows the monitoring of database access based on the content of the data accessed.
Enterprise User Security This features allows the definition of enterprise users and roles. N-tier authentication authorization This feature preserves client identity throughout all tiers. Database Resource Manager Database Resource Manager gives Oracle Database more control over resource management decisions, circumventing problems arising from inefficient operating system management.
Data compression This feature provides the ability to compress tables and partitions. Bitmapped index and bitmapped join index This feature provides an index type commonly used in data warehouses for columns with low cardinality, such as 'Y' or 'N', to dramatically improve performance gains in a data warehouse application.
Export transportable tablespace Import transportable tablespace, including cross-platform transport, is included with Standard Edition and Standard Edition One, but export transportable tablespace is not included. Asynchronous change data capture This feature provides a framework for capturing change data, publishing it, and enabling applications to subscribe to the change data in a controlled fashion.
Change capture occurs asynchronously based on the information in the Oracle redo logs. Parallel Operations Parallel query Oracle Database transparently distributes query execution across multiple processes, resulting in excellent performance. DML operations are transparently divided across multiple processes. Parallel index build Indexes can be created using parallel processes, significantly improving performance of the operation. Parallel statistics gathering -- Parallel Data Pump export and import The new Data Pump Export and Import utilities can each be run in parallel, resulting in better performance in loading and unloading data and metadata.
Parallel text index creation -- Parallel backup and recovery -- Information Integration Oracle Streams Message queuing and apply features of Oracle Streams are available in Standard Edition and Standard Edition One, but change capture is available only in Enterprise Edition.
Advanced Replication multimaster Basic replication which is available with Standard Edition and Standard Edition One provides support for read-only and updatable materialized views for replication and multitier materialized views. Standard Edition and Standard Edition One databases can also act as a master site for materialized views, but cannot participate in multimaster replication. Oracle Messaging Gateway Oracle Messaging Gateway consists of an administration package for gateway configuration and management and a gateway agent that processes propagation.
Networking Connection Manager This feature provides multiplexing, multiprotocol connectivity, and network access control. High-speed Infiniband network support Oracle protocol support now includes support for the industry-standard Sockets Direct Protocol SDP for Infiniband high-speed networks.
By using SDP, applications place most of the messaging burden upon the network interface card, freeing the CPU for other tasks. Metric Definitions Foot 1 Named User Plus This metric is defined as an individual authorized by you to use the programs which are installed on a single server or multiple servers, regardless of whether the individual is actively using the programs at any given time.
High Availability. Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable a production Oracle Database to survive disasters and data corruption.
This feature provides fast and predictable recovery from system failures. The following online operations are not included with Standard Edition or Standard Edition One: Online index maintenance Online table organization Online table redefinition. The following backup and recovery features are not included with Standard Edition or Standard Edition One: Block-level media recovery Parallel backup and recovery Change-aware incremental backups Duplexed backup sets backup sets can be written to multiple devices in parallel Point-in-time tablespace recovery a tablespace can be recovered up to a specified point in time after a failure or inadvertent transaction execution Trial recovery redo is applied in memory only but is not written to disk and is easily rolled back.
This option is described in "Oracle Advanced Security". This option is described in "Oracle Label Security". This feature provides functionality to create security policies that implement row-level security.
Lost Write Protection. Automatic Block Repair. Requires Oracle Active Data Guard option. Parallel backup and recovery. Tablespace point-in-time recovery. Trial recovery. Fast-start fault recovery. Flashback Table.
Flashback Database. Flashback Transaction. Flashback Transaction Query. Optimization for Flashback Data Archive history tables. Oracle Real Application Clusters. Extra cost with EE, included with SE. Automatic Workload Management. Requires Oracle Real Application Clusters. Quality of Service Management. Client Side Query Cache.
Query Results Cache. Database Smart Flash Cache. Oracle Advanced Security. Oracle Label Security. Fine-grained auditing. Virtual Private Database. Development Platform. Oracle Developer Tools for Visual Studio. Microsoft Distributed Transaction Coordinator support. Active Directory integration. Oracle Change Management Pack. Oracle Configuration Management Pack. Oracle Data Masking and Subsetting Pack.
Oracle Diagnostics Pack. Oracle Provisioning and Patch Automation Pack. Oracle Tuning Pack. Extra cost option, also requires the Diagnostics Pack. Oracle Real Application Testing. Database Resource Manager. Instance Caging. SQL Plan Management. SQL Tuning Sets. Oracle Partitioning.
Oracle OLAP. Oracle Advanced Compression. Hybrid Columnar Compression. Exadata Flash Cache Compression. Requires the Advanced Compression option. Basic Table Compression. Deferred Segment Creation. Parallel statistics gathering. In-memory Parallel Execution. Parallel Statement Queuing.
Parallel capture and apply via XStream. Transportable tablespaces, including cross-platform. Summary management—Materialized View Query Rewrite. Asynchronous Change Data Capture. Basic Replication. Advanced Replication. Oracle Streams. Database Gateways. Messaging Gateway. Table of Contents. Preparing the database for ASM usage. Also, note that the last step is the only one that requires the database to go down.
Steps: Switch default destination for database files to ASM. Standard Edition does not support block change tracking, so don't worry about these steps. Hopefully you have 2 fewer log members in each group than the max. If not, you will have to drop some before you can proceed. Now, you will have a bunch of invalid log members. You can make them valid by switching logfiles:. If you are doing this stuff while users are online, you may have issues with dropping the old tempfiles.
I recommend the below process rather than the one in the whitepaper:. This means a session is using it. You can wait for them to finish, or kill the sessions. When the sessions are gone, reissue the drop.
0コメント