欢迎访问 玉面飞龙 的个人空间

我的论坛主题

  • 10.2.0.3 Locking Statistics for a Table or Schema

    2008-10-13 20:43:28   /   Oracle数据库管理

    10.2.0.3 Locking Statistics for a Table or SchemaFrom OTN:Statistics for a table or schema can be locked. Once statistics are locked,no modifications can be made to those statistics until the statistics have been unlocked. These locking procedures are useful in a static environment in which you want to guarantee that the statistics never change.The LOCK_* procedures either freeze the current set of the statistics or to keep the statistics empty (uncollected).When statistics on a
  • 使用IFILE集中管理

    2008-09-23 17:49:01   /   Oracle数据库管理

    初始化参数中有个叫ifile的参数,可以在当前的数据库初始化文件中嵌入其它参数文件。NAME DESCRIPTION————————————–ifile include file in init.orainit${SID}.ora就类似#private parameterdb_name=ORADBcontrolfile=(file1,file2)#public shared ifileifile=/oracle/data/home/admin/pfile/initPublicIFILE10g.ora这个参数在管理多个具有相同环境的数据库的初始化文件很有用。当我们在某个数据库上修改一个初始化参数的时候,如果这个参数也同样适用于其他数据库。我们只需要修
541/6123456>
Open Toolbar