-
编辑 删除
relink database
有时候不想装software，有个偷懒的方法。在另外一台server上将software tar出来，解开后按以下步骤：1.oracle用户: relink all2.root 用户:运行root.sh[@more@]
-
编辑 删除
DDL引起package失效后所碰到的错误-ora-04068
一个不算错误的错误。把应用重启就可以了。原因是长连接session在运行一个重编译的包后出错。[@more@]ORA-04068 Errors from User-Written and Oracle Packages [ID 106206.1]修改时间 07-AUG-2008 类型 BULLETIN 状态 PUBLISHED "Checked for relevance on 22-MAY-2008" Problem Description ------------------- You receive the following error from user-written and Oracle packages: ORA-04068 existing state of packages%s%s%s has been discarded Causes of ORA-4068 Errors ------------------
-
编辑 删除
你想知道RMAN的恢复速度吗？
select sid, serial#, context,round(sofar/totalwork*100,2) "% Complete",substr(to_char(sysdate,'yymmdd hh24:mi:ss'),1,15) "Time Now",elapsed_secondsfrom v$session_longopswhere compnam = 'dbms_backup_restore'; --> for 8.0For Oracle8i and Oracle9i:SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"FROM V$SESSION_LONGOPSWHERE OPNAME LIKE 'RMAN%'AND OPNAME NOT LIKE '%aggregate%'AND TOTALWORK != 0AND SOFAR <> TOTALWORKRMAN use
-
编辑 删除
用pl/sql实现批量处理
set serveroutput on size 1000000 format wrappeddeclarecursor c is select 'alter user ' || lower(username) || ' identified by '||lower(username) md_pwd 3 from dba_users where lower(username) in ('maps','readonly','ods_batch','mpsload','mapsuser') order by username; begin for r in c loop dbms_output.put_line(r.md_pwd); execute immediate r.md_pwd; end loop; end; /[@more@]
-
编辑 删除
RAC 安装后listener/tnsnames的load balance配置(TAF)
NOTES 453293.1[@more@]R
-
编辑 删除
你想知道用RMAN备份时输出到磁带的写速度吗？
SELECT MAX(effective_bytes_per_second) EPSFROM v$backup_sync_ioWHERE device_type <> 'DISK'AND open_time BETWEEN TO_DATE('2010-01-06 03:00:00','yyyy-mm-dd hh24:mi:ss') AND TO_DATE('2010-01-06 17:00:00','yyyy-mm-dd hh24:mi:ss')[@more@]
-
编辑 删除
windows平台下oracle快速诊断的一些方法：
在服务器还可以登录的情况下，可以用以下快速方法获得占CPU的session的信息。1.在9i/10g手工启动statspack快照,收集信息。9i:exec perfstat.statspack.snap();10g:exec dbms_workload_repository.create_snapshot;2.利用一些进程监控工具如procexp.exe获得占cpu高的线程号.3.SELECT a.sql_hash_value FROM v$session a,v$process bWHERE a.paddr=b.addr AND b.spid=6012 (spid为上一点所获得的线程号）4.select sql_text from v$sqltext where hash_value='xxxx' order by piece;其中hash_value为第3点中所获得的sql_hash_value.至此拿到占
-
编辑 删除
不用NID改DB_NAME
用改controlfile的方式也可以改名字[@more@]How to Determine and Rename/Change DB_NAME or ORACLE_SID/Instance Name [ID 15390.1] 修改时间 12-MAR-2009 类型 BULLETIN 状态 PUBLISHED In this Document Purpose Scope and Application How to Determine and Rename/Change DB_NAME or ORACLE_SID/Instance Name Find the current DB_NAME and ORACLE_SID: Modify a database to run under a new ORACLE_SID: Change the "db_name" for a Database ReferencesApplies to: Oracle Server Enterpri
