ITPub博客

For troubleshooting ORA-29740 errors, the 'reason' will be very important.In the above example, the first section indicates the reason for theinitiated reconfiguration. The reasons are as follows:[@more@]Reason:0 = No reconfigurationReason1 = The Node Monitor generated the reconfiguration.Reason2 = An instance death was detected.Reason3 = Communications FailureReason4 = Reconfiguration after suspend

Enqueue Waits[@more@]文章来源于:http://dbpedias.com/wiki/Oracle:Wait_Events_-_Enqueue_WaitsEnqueues are local locks that serialize access to various resources. This wait event indicates a wait for a lock that is held by another session (or sessions) in an incompatible mode to the requested mode. The table below lists the details of which lock modes are compatible with which. Enqueues are usually represented in the format "TYPE-ID1-ID2" where: "TYPE" is a 2 character text stri

introduce how to config raw devices[@more@]1、/etc/sysconfig/rawdevices：文件中加入类似如下行/dev/raw/raw1 /dev/sdb1/dev/raw/raw2 /dev/sdc12、重启rawdevices服务，生成相应设备文件/sbin/service rawdevices restart3、改权限chown oracle:dba /dev/raw/*chmod 660 /dev/raw/*4、永久使权限生效较普遍方式：修改/etc/udev/permissions.d/50-udev.permissions文件把raw/*:root:disk:0660改为：raw/*:oracle:dba:0660如下所示：# raw devices ram*:root:disk:0660 #raw/*:root:disk:0660raw/*:oracle:dba:0660RHEL5:编辑/etc/udev

just as title[@more@]shutdown:srvctl stop asm -n raclinux1 -o normal:immediate:transactional:abortexport ORACLE_SID=+ASM1export ORACLE_HOME=$ASM_HOME (in 11gR1)export ORACLE_HOME=$ORA_GRID_HOME (in 11gR2)sqlplus / as sysasmSQL> SHUTDOWN NORMAL:IMMEDIATE:TRANSACTIONAL:ABORTstartup:srvctl start asm -n raclinux1 -o nomount:mount:restrictexport ORACLE_SID=+ASM1export ORACLE_HOME=$ASM_HOME (in 11gR1)export ORACLE_HOME=$ORA_GRID_HOME (in 11gR2)sqlplus / as sysasmSQL> STARTUP NOMOUNT:MOUNT:RESTRI

scn最大值为281474976710656[@more@]16进制的ffffffffffff按每秒16k的速度至少可用于500年

取自：http://www.oracle-base.com/articles/10g/automatic-sql-tuning-10g.php[@more@]Automatic SQL Tuning in Oracle Database 10g1、授相应用户权限CONN sys/password AS SYSDBAGRANT ADVISOR TO scott;CONN scott/tiger2、建立taskSET SERVEROUTPUT ON-- Tuning task created for specific a statement from the AWR.DECLARE l_sql_tune_task_id VARCHAR2(100);BEGIN l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task ( begin_snap => 764, end_snap => 938,

Oracle 10g All versions.[@more@]SQL> ALTER SESSION SET sql_trace=TRUE;SQL> ALTER SESSION SET sql_trace=FALSE;SQL> EXEC DBMS_SESSION.set_sql_trace(sql_trace => TRUE);SQL> EXEC DBMS_SESSION.set_sql_trace(sql_trace => FALSE);SQL> ALTER SESSION SET EVENTS '10046 trace name context forever, level 8';SQL> ALTER SESSION SET EVENTS '10046 trace name context off';SQL> EXEC DBMS_SYSTEM.set_sql_trace_in_session(sid=>123, serial#=>1234, sql_trace=>TRUE);SQL> EXEC DBMS

转载索引，判端是不是根块[@more@]Once we get the object_id from dba_segments, here's how to dump an index:1、dump indexalter session set events 'immediate trace name treedump level :ObjectId';...----- begin tree dumpbranch: 0x3ec4d5f4 1053087220 (0: nrow: 5, level: 2)branch: 0x58515106 1481724166 (-1: nrow: 491, level: 1)leaf: 0x3ec4d5f5 1053087221 (-1: nrow: 46 rrow: 46)leaf: 0x3ec4d5f6 1053087222 (0: nrow: 45 rrow: 45)leaf: 0x3ec4d5f7 1053087223 (1: nrow: 44 rrow: 44)leaf: 0x3ec4d5f8 1053087224

command list[@more@]sqlplus -prelimoradebug setmypidoradebug unlimitoradebug -g all dump systemstate 10 oradebug setmypidoradebug setinst alloradebug -g def hanganalyze <level>level:1-2 Only hanganalyze output, no process dump at all3 Level 2 + Dump only processes thought to be in a hang (IN_HANG state)4 Level 3 + Dump leaf nodes (blockers) in wait chains (LEAF, LEAF_NW,IGN_DMP state)5 Level 4 + Dump all processes involved in wait chains (NLEAF state)10 Dump all processes (IGN state)oth

Using The DBMS_SHARED_POOL Package [ID 457309.1][@more@]1、以qiuyb用户执行一个sqlSQL> select * from t1 where id=1; ID NAME---------- ---------------------------------------- 1 haerbin2、以sys用户查找这条语句sql_address及hash_valueSQL> SELECT ADDRESS, 2 HASH_VALUE, 3 SQL_ID, 4 EXECUTIONS, 5 LOADS, 6 VERSION_COUNT, 7 INVALIDATIONS, 8 PARSE_CALLS 9 FROM V$SQLAREA 10 WHERE SQL_TEXT = 'select * from t1 where id=

把归档日志放入standby端相应的目录,mrp不应用相应日志[@more@]查询v$managed_standby视图,mrp0 status列状态为WAIT_FOR_GAP,如下：SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY; PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS --------- ------------ ---------- ---------- ---------- ---------- MRP0 WAIT_FOR_GAP 1 87163 0 0解决:SQL> ALTER DATABASE REGISTER LOGFILE 2 '/zhkf03arch/zhkfrz1_87163

类似如下报错：During adding servers ([xlt3]) to server pool (ISMT_Pool_VM), Cluster setup failed: (OVM-1011 OVM Manager communication with 192.168.217.46 for operation HA Setup for Oracle VM Agent 2.2.0 failed: )[@more@]解决方法：1、在Oracle VM机器及Oracle VM Manager机器的/etc/hosts文件中把相应的机器加上2、从管理界面中把报错的spool删掉3、在Oracle VM机器执行如下操作：/opt/ovs-agent-2.3/utils/repos.py --list/opt/ovs-agent-2.3/utils/repos.py --delete 7768e1e1-6707-4056-b149-234dfc17532b/opt/ovs-age

VNC windows远程linux简明步骤[@more@]1.在终端shell中运行命令“vncpasswd ”，添加客户端访问时使用的密码。2.在终端shell中运行命令 “vncserver”，此时会在$HOME/生成一个隐藏文件夹“.vnc”。3.进入cd 进入.vnc目录，编辑“ xstartup”文件。将“unset SESSION_MANAGERexec /etc/X11/xinit/xinitrc”这两行的注释符号“#”去掉。同样，注释掉“# twm &”在最后一行添加“gnome-session &”4.编辑/etc/sysconfig/vncservers,添加下面的行：VNCSERVERS="3:root"VNCSERVERARGS[3]="-geometry 1440x900 -depth 1