UsethefollowingsyntaxtoaddconfigurationinformationaboutanexistingASMinstance:srvctladdasm-nnode_name-iasm_instance_name-ooracle_homeUsethefollowingsyntaxtoremoveanASMinstance:srvctlremoveasm-nnode_name[-iasm_instance_name]Usethefollowingsyntaxtoenabl...(more)

TEST=(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=ON)(FAILOVER=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=myrac)(FAILOVER...(more)

Appliesto:OracleServer-EnterpriseEdition-Version:11.1.0.6to11.2.0.1-Release:11.1to11.2Informationinthisdocumentappliestoanyplatform.GoalHowtodisableautomaticstatisticscollectionin11gSolutionThecommandtodisableautomaticoptimizerstatisticscollectionis:...(more)

窗口begindbms_scheduler.create_schedule(schedule_name=>'s5',repeat_interval=>'freq=daily;byhour=9;byminute=30;bysecond=0');end;/begindbms_scheduler.create_schedule(schedule_name=>'s6',repeat_interval=>'freq=daily;byhour=18;byminute=30;bys...(more)

试验并发会话数限制会话一：connz/zinsertintotvalues(1);会话二：connz/zinsertintotvalues(1);会话三：connz/zinsertintotvalues(1);语句被阻塞试验最大执行时间connz/zcreatetableoasselect*fromall_objects;insertintooselect*fromo;insertintooselect*fromo;insertintoos...(more)

colcommentsformata80selectconsumer_group,commentsfromdba_rsrc_consumer_groups;selectusername,initial_rsrc_consumer_groupfromdba_users;CONSUMER_GROUPCOMMENTSOTHER_GROUPSconsumergroupforusersnotincludedinanygroupintheactivetop-planDEFAULT_CONSUMER_GROU...(more)

监视与管理内存SGAshowparametersga_max_sizeNAMETYPEVALUEsga_max_sizebiginteger248MSGA上限设置在实例初始化时，如果参数文件中SGA_MAX_SIZE的值小于Oracle为SGA各组件分配的内存之和（依据参数文件中的显式设定值或系统的默认值），Oracle将忽略SGA_MAX_SIZE参数showparamet...(more)

监视表空间、段和索引监视表空间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)