监视表空间、段和索引监视表空间selecttablespace_name,sum(bytes)fromdba_free_spacegroupbytablespace_name;TABLESPACE_NAMESUM(BYTES)UNDOTBS18978432SYSAUX13893632AAA983040R2031616USERS89587712DATA51773440WWW20840448SYSTEM8716288A4546560B10354688各表空间的...(more)

使用RDBMS_REPAIR程序包丢弃损坏数据块conn/assysdbaBEGINDBMS_REPAIR.ADMIN_TABLES(TABLE_NAME=>'REPAIR_TABLE',TABLE_TYPE=>dbms_repair.repair_table,ACTION=>dbms_repair.create_action,TABLESPACE=>'USERS');END;/DECLAREnum_corruptINT;BEGINnum_corr...(more)

诊断eOracle数据库问题showparametermax_dump_file_sizeNAMETYPEVALUEmax_dump_file_sizestringUNLIMITED第23页转储文件大小限制selectinternal_metric_namefromv$alert_types;INTERNAL_METRIC_NAMEQuotaData_ObjectRollback_SegmentRollback_SegmentpctUsedbytesFreeTa...(more)

配置侦听器的安全性为侦听器设置口令lsnrctlchange_passwordsave_configsetpasswordpassLSNRCTL>change_passwordOldpassword:Newpassword:Reenternewpassword:正在连接到(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.19)(PORT=1521)))LISTENER的口令已更改...(more)

全球化设置select*fromnls_database_parameters;PARAMETERVALUE----NLS_LANGUAGESIMPLIFIEDCHINESENLS_TERRITORYCHINANLS_CURRENCY?NLS_ISO_CURRENCYCHINANLS_NUMERIC_CHARACTERS.,NLS_CHARACTERSETZHS16GBKNLS_CALENDARGREGORIANNLS_DATE_FORMATDD-MON-RRNLS_DATE_LANG...(more)

管理eOracle数据库中的全球化语言selectparameter,valuefromv$nls_valid_valueswhereparameter='LANGUAGE';PARAMETERVALUELANGUAGEAMERICANLANGUAGEGERMANLANGUAGEFRENCHLANGUAGECANADIANFRENCHLANGUAGESPANISHLANGUAGEITALIANLANGUAGEDUTCHLANGUAGESWEDISHLANGUAGENORW...(more)

!/bin/shcount=0while[$count-lt$2]docount='expr$count+1'sqlplus-swillson/willsonm@$1@test.sqlsleep1donesetlinesize160colhost_namefora15altersessionsetnls_date_format='yyyy-mm-ddhh24:mi:ss';selectinstance_number,instance_name,host_name,status,startup_t...(more)

srvctl命令addAddadatabaseorinstanceconfigListtheconfigurationforthedatabaseorinstancegetenvListtheenvironmentvariablesintheSRVMconfigurationmodifyModifytheinstanceconfigurationremoveRemovethedatabaseorinstancesetenvSettheenvironmentvariableintheSRVMc...(more)

srvctl命令addAddadatabaseorinstanceconfigListtheconfigurationforthedatabaseorinstancegetenvListtheenvironmentvariablesintheSRVMconfigurationmodifyModifytheinstanceconfigurationremoveRemovethedatabaseorinstancesetenvSettheenvironmentvariableintheSRVMc...(more)

FollowthesestepstoconfigureRMANbackupsinDataGuardenvironment.Whenyouwanttomanagedthearchivelogdeletionpolicyfromonecentralpoint.CONFIGUREARCHIVELOGDELETIONPOLICYPossibleoptions:APPLIEDONSTANDBY-enablesflashrecoveryareatodeletearchivelogsthatareapplie...(more)