- 博客(24)
- 收藏
- 关注
RSS订阅转载 Check FRA usage
SQL> set linesize 150column name format a35SELECT NAME,SPACE_LIMIT/1024/1024/1024 AS SPACE_...
2018-08-23 09:35:28
121
转载 CHG: Restart Dataguard Standby databases
CHG: Restart Dataguard Standby databasesStop Dataguard Standby Database:PreStep: Ba...
2018-08-21 11:06:46
159
转载 check memory_target and memory_max_target
SQL> set linesize 130set pagesize 1000column name format a30column value format a30select n...
2018-08-21 08:54:02
137
转载 Generate Script to kill multiple Oracle sessions
$ cd /data/oracle/SHRARS/backup/export/ITSK0004746383 $ sqlplus -s / as sysdba < killsession.sqlset ...
2018-06-23 23:01:20
113
转载 Kill Multiple Seesions in Oracle
SQL> set pagesize 1000select 'ALTER SYSTEM KILL SESSION '''|| sid ||','|| SERIAL# ||''' immediate;'from ...
2018-06-21 14:41:49
112
转载 Generate Script to Rebuild all SYS non-partitioned Indexes
SQL> set linesize 150set pagesize 10000select 'alter index '||owner||'.'||index_name||' rebuild online;'...
2018-06-18 15:38:29
501
转载 Generate Script to Analyze on all SYS non-partitioned tables
SQL> set linesize 150set pagesize 10000select 'analyze table '||owner||'.'||table_name||' validate struc...
2018-06-18 15:36:50
309
转载 Analyze on all SYS tables (Except AWR Tables)
****************************************************************************************Generate Script to ...
2018-06-13 16:36:39
271
转载 opatch lsinventory -detail -oh $ORACLE_HOME
cd $ORACLE_HOME/OPatch ./opatch lsinventory -detail -oh $ORACLE_HOME > /tmp/hostname_${ORACLE_SID}_lsinve...
2018-06-12 14:41:55
225
转载 Rebuild all non-partioned Indexes
Check all partioned and non-partioned tables & Indexes SQL> set linesize 180set pagesize ...
2018-06-12 13:09:00
138
转载 Check all partioned tables & Indexes
SQL> set linesize 150set pagesize 10000column table_name format a30column tablespace_name forma...
2018-06-12 13:07:59
158
转载 Rebuild the Partitioned index to fix corrupted indexes
SQL> set linesize 150column OWNER format a20column SEGMENT_NAME format a20column PARTITION_NAME format...
2018-05-29 16:10:50
138
转载 ORA-24247：网络访问被访问控制列表 (ACL) 拒绝
ORA-24247：网络访问被访问控制列表 (ACL) 拒绝 开发编写了一个oracle 发送邮件的存储过程，之前是在10G 的版本运行使用，现在11.2.0.4 的版本使用，调试无法使用 发现报错...
2018-05-16 14:29:19
627
转载 check RMAN BACKUP status
SQL> select name, db_unique_name, open_mode from v$database; NAME DB_UNIQUE_NAME...
2018-04-27 14:56:46
163
转载 V$RMAN_BACKUP_JOB_DETAILS
V$RMAN_BACKUP_JOB_DETAILS展示了rman备份的相关细节。比如，rman备份持续时间、rman备份的执行次数、每一次rman备份工作的状态（failed or completed and so on），...
2018-04-27 14:55:11
1703
转载 opatch命令报错Inventory is corrupted
测试环境中执行opatch报错，简单描述一下解决过程。 错误信息如下： [orat3@hpserver2 OPatch]$ ./opatch lsin...
2018-04-23 15:42:40
495
转载 check parameters
SQL> set linesize 200set pagesize 1000column name format a40column value format a60select inst_id, n...
2018-04-23 14:38:37
582
转载 Restore archivelogs to a different location
RMAN>run>{>set archivelog destination to '/stage';>restore archivelog from logseq 100278 until l...
2018-01-07 16:12:19
137
转载 check undo info
alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';col status format a15col description format a40 ...
2018-01-01 19:46:32
121
转载 Oracle 10g/11g RAC, DataGuard实战之Oracle 11gR1 RAC
请加入QQ群参加Oracle10g/11gRACDataGuard,Goldengate交流和免费提供99%正确率的OracleRAC,DataGuard,Goldengate,Streams部分实战文...
2012-02-14 17:28:01
130
转载 Oracle 10g/11g RAC, DataGuard实战之Oracle 11gR1 RAC DataGuard
Oracle10g/11gRAC,DataGuard实战环境 请加入QQ群参加Oracle10...
2012-02-14 15:33:49
176
转载 Oracle 10g/11g RAC, DataGuard实战之Oracle 10gR2 RAC
请加入QQ群参加Oracle10g/11gRACDataGuard,Goldengate交流和免费提供99%正确率的OracleRAC,DataGuard,Goldengate,Streams...
2012-02-14 10:04:14
102
转载 Oracle 10g/11g RAC, DataGuard实战之Oracle 10gR2 DataGuard
请加入QQ群参加Oracle10g/11gRACDataGuard,Goldengate交流和免费提供99%正确率的OracleRAC,DataGuard,Goldengat...
2012-02-13 17:24:39
89
转载 Oracle 10g/11g RAC, DataGuard实战之Oracle 10gR2 RAC DataGuard
请加入QQ群参加Oracle10g/11gRACDataGuard,Goldengate交流和免费提供99%正确率的OracleRAC,DataGuard,...
2012-02-13 17:03:11
106
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人