[ Pobierz całość w formacie PDF ]
.2.The topics included in this appendix are:" Functionality Enhancements (page C 2)" Recovery Enhancements (page C 3)" Security Enhancements (page C 4)" Performance Enhancements (page C 6)" Administration Enhancements (page C 11)" Oracle7, Release 7.2 Datatype Changes (page C 13)" SQL Changes (page C 14)" New Features of the Oracle Precompilers, Release 1.7 (page C 16)" Pro*C/C++, Release 2.1 New Features (page C 18)" SQL*Module Default WITH INTERFACE Clause (page C 19)" Non blocking Oracle Call Interface (OCI) (page C 19)" Initialization Parameter Changes (page C 20)" Data Dictionary Changes (page C 20)" Standards Compliance (page C 22)" Release 7.2 Backward Compatibility (page C 22)" New, Changed, and Obsolete SQL Scripts (pages C 23)" Other Changes (pages C 24)Summary of Changes in Oracle7, Release 7.2 C 1 Functionality EnhancementsPL/SQL, Release 2.2 provides a new and convenient declarativeCursor Variablesmechanism to return multi row result sets from stored procedures.Using a cursor variable, a calling program can obtain a handle thatenables the retrieval of multiple rows from a stored procedure.Cursorvariables allow you to pass cursors as parameters in your application.Cursor variables are like C or Pascal pointers, which hold the memorylocation (address) of some object instead of the object itself, allowingyou to allocate memory for the object dynamically.The cursor variables feature results in reduced coding complexityby providing a structured way to encapsulate queries in astored procedure.For more information, see the PL/SQL User s Guide and Reference.Table creation and population for CREATE TABLE ASCREATE TABLE ASstatements can now be performed in parallel.This new functionality isSELECTan extension to the parallel query option of Oracle7, Release 7.1.Parallel execution of the CREATE TABLE AS SELECT operationpermits the insertion of the results of a query into a new table inparallel, in addition to executing the query itself in parallel.The Create Table As Select feature permits the following:" Summaries of large amounts of data can now be created, in theform of subsets, that can be repeatedly queried by multiple userson an ad hoc basis." Successive refinements of large data sets can now be createdby applying series of highly complex queries.Typicalapplications involve large datafiles that contain redundant orirrelevant information.For more information about CREATE TABLE AS SELECT, see Oracle7Server SQL Reference and SQL Changes on page C 14.A new keyword, UNRECOVERABLE, allows you to avoid redoUNRECOVERABLElogging during the creation of tables or indexes (regardless of whetherthey are created in parallel).Objects created with theUNRECOVERABLE keyword cannot be recovered in the event ofmedia failure, but the creation time will be significantly shorter.For more information about UNRECOVERABLE, see Oracle7 ServerSQL Reference and SQL Changes on page C 14.C 2 Oracle7 Server Migration CREATE INDEX and CREATE TABLE AS SELECT operations can nowCREATE INDEXbe performed faster.Release 7.2 offers you the option to disable loggingfor the CREATE INDEX and CREATE TABLE AS SELECT operations.The new Release 7.2 option is available for parallel and serial executionof the CREATE INDEX and CREATE TABLE AS SELECT operations.The syntax for the CREATE INDEX command isCREATE INDEX ON (column name)For more information about CREATE INDEX, see Oracle7 Server Tuningand Oracle7 Server SQL Reference and SQL Changes on page C 14.Recovery EnhancementsA new feature in Release 7.2 facilitates earlier detection of databaseChecksumscorruption.Timely detection of database corruption also aids indiagnosing the causes of corruption.A new initialization parameter, LOG_BLOCK_CHECKSUM, can be setto write a checksum in the header of every block of the redo log as it iswritten out of the log buffer.The checksums, if present, are validatedwhen the log is read for archiving or recovery.Similarly, data blocksmay also have checksums to detect corruption more easily.The initialization parameter DB_BLOCK_CHECKSUM enables thechecksum option.For more information, see the Oracle7 Server Administrator s Guide.A new mechanism avoids performing media recovery if a databaseMedia Recoverycrash occurs while one or more files is in online backup mode.For more information, see the Oracle7 Server Administrator s Guide.Summary of Changes in Oracle7, Release 7.2 C 3 Security EnhancementsThe Oracle7 external authentication mechanism now extends to includeNetwork Securitysupport for network authentication services.Distributed installationsEnhancementscan now validate database access and roles by taking advantage ofnetwork authentication services.Specific network security features are" Secure external authentication.The database trusts the externalauthorization service for authorization, even if the underlyingprotocol itself is not secure." Secure database links.Users who are authenticated by a networkservice that supports proxies can use the proxy when makingremote access with an anonymous database link (one without aspecified user name) to make secure connection." Network roles.The database recognizes roles granted bynetwork services similar to the current OS roles feature." Network SYSDBA/SYSOPER privilege.Remote internalconnections can be authorized by the network service, ratherthan using the Oracle7 password file utility in Release 7.1.For more information, see Oracle7 Server Concepts.The release 7.2, Trusted Stored Procedures enables applicationTrusted Storeddevelopers toProcedures" write procedures that would perform MAC privilegedoperations without having to grant the privileges explicitly to allexecutors of the procedure." write procedures that enable unprivileged users to performMAC privileged operations in a carefully controlled manner byusing software inside the server.For more information, see the Trusted Oracle7 Server Administrator sGuide, Release 7.1.C 4 Oracle7 Server Migration Application developers can now deliver PL/SQL code in aSecure PL/SQL Codeprecompiled format using the new PL/SQL Wrapper feature.The name(PL/SQL Wrapper)of the new executable is Wrap.Intellectual property is protected byhiding source code in a binary source form [ Pobierz całość w formacie PDF ]
zanotowane.pl doc.pisz.pl pdf.pisz.pl odbijak.htw.pl
.2.The topics included in this appendix are:" Functionality Enhancements (page C 2)" Recovery Enhancements (page C 3)" Security Enhancements (page C 4)" Performance Enhancements (page C 6)" Administration Enhancements (page C 11)" Oracle7, Release 7.2 Datatype Changes (page C 13)" SQL Changes (page C 14)" New Features of the Oracle Precompilers, Release 1.7 (page C 16)" Pro*C/C++, Release 2.1 New Features (page C 18)" SQL*Module Default WITH INTERFACE Clause (page C 19)" Non blocking Oracle Call Interface (OCI) (page C 19)" Initialization Parameter Changes (page C 20)" Data Dictionary Changes (page C 20)" Standards Compliance (page C 22)" Release 7.2 Backward Compatibility (page C 22)" New, Changed, and Obsolete SQL Scripts (pages C 23)" Other Changes (pages C 24)Summary of Changes in Oracle7, Release 7.2 C 1 Functionality EnhancementsPL/SQL, Release 2.2 provides a new and convenient declarativeCursor Variablesmechanism to return multi row result sets from stored procedures.Using a cursor variable, a calling program can obtain a handle thatenables the retrieval of multiple rows from a stored procedure.Cursorvariables allow you to pass cursors as parameters in your application.Cursor variables are like C or Pascal pointers, which hold the memorylocation (address) of some object instead of the object itself, allowingyou to allocate memory for the object dynamically.The cursor variables feature results in reduced coding complexityby providing a structured way to encapsulate queries in astored procedure.For more information, see the PL/SQL User s Guide and Reference.Table creation and population for CREATE TABLE ASCREATE TABLE ASstatements can now be performed in parallel.This new functionality isSELECTan extension to the parallel query option of Oracle7, Release 7.1.Parallel execution of the CREATE TABLE AS SELECT operationpermits the insertion of the results of a query into a new table inparallel, in addition to executing the query itself in parallel.The Create Table As Select feature permits the following:" Summaries of large amounts of data can now be created, in theform of subsets, that can be repeatedly queried by multiple userson an ad hoc basis." Successive refinements of large data sets can now be createdby applying series of highly complex queries.Typicalapplications involve large datafiles that contain redundant orirrelevant information.For more information about CREATE TABLE AS SELECT, see Oracle7Server SQL Reference and SQL Changes on page C 14.A new keyword, UNRECOVERABLE, allows you to avoid redoUNRECOVERABLElogging during the creation of tables or indexes (regardless of whetherthey are created in parallel).Objects created with theUNRECOVERABLE keyword cannot be recovered in the event ofmedia failure, but the creation time will be significantly shorter.For more information about UNRECOVERABLE, see Oracle7 ServerSQL Reference and SQL Changes on page C 14.C 2 Oracle7 Server Migration CREATE INDEX and CREATE TABLE AS SELECT operations can nowCREATE INDEXbe performed faster.Release 7.2 offers you the option to disable loggingfor the CREATE INDEX and CREATE TABLE AS SELECT operations.The new Release 7.2 option is available for parallel and serial executionof the CREATE INDEX and CREATE TABLE AS SELECT operations.The syntax for the CREATE INDEX command isCREATE INDEX ON (column name)For more information about CREATE INDEX, see Oracle7 Server Tuningand Oracle7 Server SQL Reference and SQL Changes on page C 14.Recovery EnhancementsA new feature in Release 7.2 facilitates earlier detection of databaseChecksumscorruption.Timely detection of database corruption also aids indiagnosing the causes of corruption.A new initialization parameter, LOG_BLOCK_CHECKSUM, can be setto write a checksum in the header of every block of the redo log as it iswritten out of the log buffer.The checksums, if present, are validatedwhen the log is read for archiving or recovery.Similarly, data blocksmay also have checksums to detect corruption more easily.The initialization parameter DB_BLOCK_CHECKSUM enables thechecksum option.For more information, see the Oracle7 Server Administrator s Guide.A new mechanism avoids performing media recovery if a databaseMedia Recoverycrash occurs while one or more files is in online backup mode.For more information, see the Oracle7 Server Administrator s Guide.Summary of Changes in Oracle7, Release 7.2 C 3 Security EnhancementsThe Oracle7 external authentication mechanism now extends to includeNetwork Securitysupport for network authentication services.Distributed installationsEnhancementscan now validate database access and roles by taking advantage ofnetwork authentication services.Specific network security features are" Secure external authentication.The database trusts the externalauthorization service for authorization, even if the underlyingprotocol itself is not secure." Secure database links.Users who are authenticated by a networkservice that supports proxies can use the proxy when makingremote access with an anonymous database link (one without aspecified user name) to make secure connection." Network roles.The database recognizes roles granted bynetwork services similar to the current OS roles feature." Network SYSDBA/SYSOPER privilege.Remote internalconnections can be authorized by the network service, ratherthan using the Oracle7 password file utility in Release 7.1.For more information, see Oracle7 Server Concepts.The release 7.2, Trusted Stored Procedures enables applicationTrusted Storeddevelopers toProcedures" write procedures that would perform MAC privilegedoperations without having to grant the privileges explicitly to allexecutors of the procedure." write procedures that enable unprivileged users to performMAC privileged operations in a carefully controlled manner byusing software inside the server.For more information, see the Trusted Oracle7 Server Administrator sGuide, Release 7.1.C 4 Oracle7 Server Migration Application developers can now deliver PL/SQL code in aSecure PL/SQL Codeprecompiled format using the new PL/SQL Wrapper feature.The name(PL/SQL Wrapper)of the new executable is Wrap.Intellectual property is protected byhiding source code in a binary source form [ Pobierz całość w formacie PDF ]