-
编辑 删除
New 11g Default Jobs
New 11g Default Jobs (文档 ID 755838.1)FAQ: Automatic Statistics Collection (文档 ID 1233203.1)Sql TuningAdvisory:Oracle Database11g, by default, the Automatic Tuning Optimizer runs regularly during theOracle scheduler Maintenance window, as the new automated maintenance taskcall...
-
编辑 删除
resource_manager 对job的资源管理
JOB创建job 不指定任何参数，则默认属于DEFAULT_CONSUMER_GROUP资源站.--------当job有了默认的资源组--------------一个win窗口打开，则按照窗口的默认规则，使用系统的资源。创建job：属于一个资源组的（ConsumerGroups如果不指定默认‘DEFAULT_JOB_CLASS’）===》DEFAULT_CONSUMER_GROUP==========...
-
编辑 删除
修改grid scan ip地址
原系统使用hosts文件解析，改为使用dns解析。[BEGIN] 12/13/2016 10:24:39 AM[root@app02~]# /u01/app/11.2.0/grid/bin/srvctl config scanSCAN name: scan, name: 1/10.138.16.0/255.255.255.0/bond0SCAN VIP name: scan1, IP: /scan/192.0.2.16[root@app02~]# /u01/app/11.2.0/grid/bin/srvctl co...
-
编辑 删除
表的itl 属性
INITRANS integerSpecify the initial number of concurrent transaction entries allocated within each data block allocated to the database object. This value can range from 1 to 255 and defaults to 1, with the following exceptions:The default INITRANS value for a cluster is 2 or the default INITR...
-
编辑 删除
更改子分区模版
alter table TMS_BILL_TASKset subpartition template(=============新的分区信息 );更改子分区信息：alter table "HAIERTMS"."TMS_BILL_TASK" modify subpartition SYS_SUBP4833 add values(10411);查询子分区信息：select table_name,partition_name,high_value,tablespace_name,SUBPARTITION_COUNT from db...
-
编辑 删除
asm 存储在线迁移
1，备份数据库。 2.2 扫描磁盘echo 1 > /sys/class/fc_host/host3/issue_lipecho 1 > /sys/class/fc_host/host4/issue_lip3，更改磁盘属性chown oracle:oinstall /dev/mapper/3PART*4，备份ocr./ocrconfig -manualbackup ./ocrconfig -showbackup5，新建asm磁盘组create diskgroup SYSDG external red...
-
编辑 删除
vim-Filter commands
vim ! Filter commands
