Oracle_数据字典和初始化参数.pptVIP

Agenda Server parameter file Summary New initialization parameters New static data dictionary views New dynamic data dictionary views New columns in existing data dictionary views 10g Details Server Manageability Database Self-Management Database Manual Monitoring / Management / Tuning Database Automatic Statistics Object Management Backup and Recovery High Availability Security Tips ALTER SYSTEM Viewing undocumented parameters The SPFILE “Server Parameter” file Stored on server Binary, rather than text Can maintain dynamic changes to parameter values The SPFILE Example 1: CREATE SPFILE FROM PFILE=‘/u01/oracle/dbs/initPROD.ora’ Example 2: CREATE SPFILE ‘/u01/oracle/dbs/spfilePROD.ora’ FROM PFILE=‘/u01/oracle/dbs/initPROD.ora’ Must have SYSDBA or SYSOPER privileges SQLPLUS SHOW PARAMETERS SPFILE /u01/oracle/dbs/spfilePROD.ora The SPFILE 9iR2 RMAN: BACKUP is used to back-up the SPFILE - RMAN backs up the SPFILE in the backup set If the SPFILE is lost / damaged, use RESTORE SPFILE: - Start the instance without the SPFILE - Run RESTORE SPFILE in RMAN The SPFILE *SPPARAMETER – contents of the SPFILE *RMAN_CONFIGURATION - maintain the persistent configuration parameters for RMAN, the standard Oracle backup and recovery utility Initialization Parameter History Oracle 10g 27 new parameters 10 marked “ISDEPRECATED” 110 in V$OBSOLETE_PARAMETER Oracle 9iR1 46 new parameters 16 obsolete 3 renamed Oracle 8.1 28 new parameters 62 obsolete Oracle 8.0 75 new parameters 26 obsolete 10g Initialization Parameters New V$PARAMETER columns ISDEPRECATED (10 parameters are TRUE) buffer_pool_keep buffer_pool_recycle drs_start fast_start_io_target global_context_pool_size log_archive_start max_enabled_roles parallel_automatic_tuning parallel_server parallel_server_instances plsql_compiler_flags ISINSTANCE_MODIFIABLE (144 TRUE, 112 FALSE): for clustered databases such as RAC, this shows if the parameter can be modified on global (TRUE) or local (FALSE) Examples of FALSE: spfile, se