ITPub博客

环境：aix 7.1 ,oracle 12.1.0.2 rac -3节点。硬件故障后，硬件工程师更换了内联网卡，不知为何资源VIP也有问题，只好先添加了VIPsrvctl add vip -node rac-wy1 -address rac-wy1-vip.nsn.com/255.255.255.0/en8修改了下nodeappssrvctl modify nodeapps -node 

oracle索引监控-----未使用的索引oracle索引是用来优化DML处理速度，但是索引是会占用表空间，有时会占用比被索引表占用还要多的表空间。所以，索引监控未使用索引就显得很重要。    打开某个索引监控：alter index owner.index_name monitoring usage;    关闭某个索引监控：alter

 我们都知道索引监控，但是索引监控只能知道监控的索引是否被使用，并不能得到索引使用率。其实我们可以利用执行计划来得到索引使用率，只是，如果语句使用了绑定变量，执行了语句多次，都的的确确使用了索引，但是因为执行计划是一致的，且一直放在库缓存中，因此统计的索引使用次数为1次。使用该方法是通过v$sql_plan中获取索引使用率。       &nbsp

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