ITPub博客

A log switch is when Oracle stops writing to the current log file, closes it, opens the next log file, and begins writing to the new log file. When do log switches happen? Log switches m

RMAN 组件:1. RMAN 执行程序, 也就是RMAN 命令.2. Server session : 服务器上的进程, 是真正用来干活的.3. Target database: 你想要进行备份的数据库4. RMAN Repository: RMAN的源数据, 这部分内容可以存储在control file, 也可以单独存储在数据库中,  用来保存备份与恢复信息的一个数据库，不建议创建在

oracle数据库 生成awr报告、ash报告详细步骤一、生成awr详细步骤1. 手动生成AWR快照号:sqlplus下执行（可选）exec dbms_workload_repository.create_snapshot2.sqlplus下执行：@?/rdbms/admin/awrrpt.sql或者 @$ORACLE_HOME/rdbms/admin/awrrpt.sql3、输入要生成报告的文件

PL/SQL 过程已成功完成。-- 以上存储过程设置每半小时采样一次，并且保留5天 。SQL> select * from dba_hist_wr_control;       DBID SNAP_INTERVAL   &n

linux tar.gz zip 解压缩 压缩命令http://apps.hi.baidu.com/share/detail/37384818download ADT linkhttp://dl.google.com/android/ADT-0.9.6.zipdownload SDK linkhttp://dl.google.com/Android/android-sdk_r11-linux_x8

SQL> set linesize 150column name format a35SELECT NAME,SPACE_LIMIT/1024/1024/1024 AS SPACE_LIMIT_GB,SPACE_USED/1024/1024 AS SPACE_USED_MB,SPACE_RECLAIMABLE/1024/1024 AS SPACE_RECLAIMABLE_MB,NUMBER_

CHG: Restart Dataguard Standby databasesStop Dataguard Standby Database:PreStep: Backout the CI on the OEMYou could backup the whole CN_DATABASE during the CHG.Step 1: Stop Primary redo transport on D

SQL> set linesize 130set pagesize 1000column name format a30column value format a30select name, ismodified, value/1024/1024 as size_mbfrom v$parameterwhere name IN ('sga_target', &nbsp

$ cd /data/oracle/SHRARS/backup/export/ITSK0004746383$ sqlplus -s / as sysdba

http://db.geeksinsight.com/http://db.geeksinsight.com/dataguard/Silent Installation using RunInstaller to install 12c Software, this will be useful when you do not have the X basesystem running on the machines (of course in real world they do not), either you need VNC or hummi...

Killing Oracle session :- TO kill a oracle session you have to be very sure which session you want o kill otherwise you may kill any other session which is useful to you.To Find your session and machine from which you are connectedSQL> select sid,serial#,status,machine,osuser,to_c...

SQL> set pagesize 1000select 'ALTER SYSTEM KILL SESSION '''|| sid ||','|| SERIAL# ||''' immediate;'from v$sessionwhere username = 'CREDIT';'ALTERSYSTEMKILLSESSION'''||SID||','||SERIAL#||'''IMMEDIATE;'--------------------------------------------------------------------------------ALTER SY...

SQL> set linesize 150set pagesize 10000select 'alter index '||owner||'.'||index_name||' rebuild online;'from dba_indexeswhere TABLE_OWNER='SYS'    and table_name NOT like 'WR%'    AND partitioned='NO'group by owner, index_nameorder by owner, index_name;'AL...

SQL> set linesize 150set pagesize 10000select 'analyze table '||owner||'.'||table_name||' validate structure cascade online;'from dba_indexeswhere TABLE_OWNER='SYS'and table_name NOT LIKE 'WR%'AND partitioned='NO'group by owner, table_nameorder by owner, table_name;'ANALYZETABLE'||OWN...

****************************************************************************************Generate Script to Analyze on all SYS non-partitioned tables****************************************************************************************cd /data/oracle/SHPMLS/admin/changes$ sqlplus / as sys...

cd $ORACLE_HOME/OPatch  ./opatch lsinventory -detail -oh $ORACLE_HOME > /tmp/hostname_${ORACLE_SID}_lsinvek.db.com:/tmp/yongSHPMLS@oracle@shaahspmldbp1 [PRD ACTIVE]:/data/oracle/SHPMLS/backup/logs$ cd $ORACLE_HOME/OPatchSHPMLS@oracle@shaahspmldbp1 [PRD ACTIVE]:/data/oracle/product/11....

Applies to:  Oracle Database - Enterprise Edition - Version 8.0.3.0 to 11.2.0.3 [Release 8.0.3 to 11.2]Information in this document applies to any platform. ***Checked for relevance on 12-Feb-2016***SymptomsYou are trying to issue an analyze command on a partition table on...

Check all partioned and non-partioned tables & IndexesSQL> set linesize 180set pagesize 10000column owner format a10column index_type format a25column table_name format a35column index_name format a35column partitioned format a10column tablespace_name format a15column partitioned f...

SQL> set linesize 150set pagesize 10000column table_name format a30column tablespace_name format a20column partitioned format a20SELECT table_name, tablespace_name, partitionedFROM dba_tablesWHERE table_name LIKE 'WR%'AND partitioned='YES'ORDER BY table_name;TABLE_NAME &nbsp...

In this DocumentSymptoms Cause Solution ReferencesApplies to: Enterprise Manager for Oracle Database - Version 10.1.0.2 to 12.1.0.2.0 [Release 10.1 to 12.1]Oracle Database - Enterprise Edition - Version 9.0.1.4 to 12.1.0.2 [Release 9.0.1 to 12.1]Oracle Database - Personal Edition -...