ITPub博客

service dg rac

 ODA Oracle Database Appliance orachk Healthcheck (Doc ID 2126926.1)Multiplexing Redolog and Control File on ODA (Doc ID 2086289.1)ORAchk – Health Checks for the Oracle Stack (Doc ID 1268927.2)How to Perform a Health Check on the Database (Doc ID 122669.1)Health Monitor (Doc...

blkid – command-line utility to locate/print block device attributesOracle Linux Server release 6.4 [root@rac02:/root]# ll /etc/*release*-rw-r--r--. 1 root root 32 Feb 22 2013 /etc/oracle-release-rw-r--r--. 1 root root 55 Feb 22 2013 /etc/redhat-releaselrwxrwxrwx. 1 root root 14 Nov 29 ...

Stale statisticsStatistics gathered by DBMS_STATS can become out-of-date. Typically, statistics are stale when 10% or more of the rows in the table have changed since the last time statistics were gathered.The GATHER_DATABASE_STATS or GATHER_SCHEMA_STATS procedu...

DISPLAY - to format and display the contents of a plan table.DISPLAY_AWR - to format and display the contents of the execution plan of a stored SQL statement in the AWR.DISPLAY_CURSOR - to format and display the contents of the execution plan of an...

In this DocumentGoalSolutionReferencesAPPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]Information in this document applies to any platform.**...

In this DocumentGoalFixReferencesAPPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterInformation in this document applies to any platform.***Checked for relevance...

APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform.GOALThe primary goal of this how-to is establish a data guard configuration where the primary site is RAC and the standby site is RAC.  Please Not...

Database connections that require SYSDBA privilege and broker connections should be performed through dedicated server based connections NOT dispatchers and shared server processes.NAME                                ...

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