ITPub博客

dg drmrl dgb

dg _DGB _DGMGRL

dg dgmgrl

SELECT distinct STARTUP_TIME FROM DBA_HIST_SNAPSHOT;-----------displays information about the snapshots in the Workload Repository.

V$SYS_TIME_MODEL and V$SESS_TIME_MODEL

select INST_ID,count(*) from gv$session group by INST_ID;select INST_ID,count(*) cnt from gv$session where status='INACTIVE'  group by INST_ID order by cnt desc;select INST_ID,count(*) cnt from gv$process group by INST_ID;==============select USERNAME,PROGRAM,PNAME,count(*) ...

select username,count(*) from v$session group by username;--check statusselect INST_ID,switchover_status,open_mode,database_role from gv$database;--check gapselect status,gap_status from v$archive_dest_status where rownum<5;set linesize 1000---check logselect status,gap_status,APPLIED_THR...

select snap_id,to_char(begin_interval_time, 'YYYY-MM-DD'), to_char(end_interval_time, 'YYYY-MM-DD') from dba_hist_snapshotorder by snap_id;wrh$_active_session_historyalter table WRH$_ACTIVE_SESSION_HISTORY shrink space; select snap_id,to_char(begin_interval_time, 'YYYY-M...

----------------------------------------------------------  File created - Monday-September-26-2016   ------------------------------------------------------------------------------------------------------------------  DDL for Table A------------------------------------------...

==========建立记录表：create table hpe_m_ts (tsname char(20),tssize number,tsused number,time timestamp)partition by range(time)interval (numtoyminterval(1,'month'))(partition p0 values less than (to_date('2010-01-01','yyyy-mm-dd')));==========cat >>/home/oracle/snow/tscheck.s...

DBA_AUTOTASKCheck the current statusof the autotask job。Dba_Autotask_Client：（task 名称，运行窗口，资源组，状态）selectclient_name,client_tag,status,window_group,consumer_group from Dba_Autotask_Clientselectjob_class_name,resource_consumer_group,service from dba_scheduler_...

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...

JOB创建job 不指定任何参数，则默认属于DEFAULT_CONSUMER_GROUP资源站.--------当job有了默认的资源组--------------一个win窗口打开，则按照窗口的默认规则，使用系统的资源。创建job：属于一个资源组的（ConsumerGroups如果不指定默认‘DEFAULT_JOB_CLASS’）===》DEFAULT_CONSUMER_GROUP==========...

原系统使用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...

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...

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