ITPub博客

often p1 will show like 1415053316, p1Text="name|mode"select chr(bitand(1415053316,-16777216)/16777215)||chr(bitand(1415053316,16711680)/65535) "Lock"from dual;the 1415053316 is p1 when we check in v$...

From Eygle1.三思而后行2.制定准则3.做好备份，没有备份什么都是空

From www.hotsos.com One of the most confounding problems with Oracle is the resolution of buffer busy wait events. Buffer busy waits are common in an I/O-bound Oracle system, as evidenced by any syste...

永远消失的阿特兰蒂斯。。。。 有关阿特兰蒂斯大陆消失的传说是世界上最为神奇的传说之一。它最早记载于柏拉图的〈对话集中，后来就一直成为人们议论的话题。1968年在巴哈巴群岛的比米尼岛海岸附近的海底发现了一堵...

Summary for the Statspack Report一、statspack 输出结果中必须查看的十项内容1、负载间档(Load profile)2、实例效率点击率(Instance efficiency hit ratios)3、首要的5个等待事件(Top 5 wait events)4、等待事件(W...

show parameter pga  ---PGA_AGGREGATE_TARGETshow parameter sga   show parameter cacheshow parameter buffershow parameter poolshow parameter processselect sum(value) from v$sesstat s, v$s...

Oracle FAQ PageData StorageQ: I want to move a database file to another directory. What should I do?A: Perform the following procedure. First, shutdown the instance: shutdown Move the file to the new ...

ABSTRACTOracle Wait Events have been around since version 7.0.12 was released. Why did Oracle introduce this functionality? So that you can get an idea of exactly what events your process is waiting t...

From metalinkThis article was published by Oracle Meta LinkPurposeThis article provides the Database Administrator a better understanding of checkpoint processing and a description of four key initial...

experiment of Yong Huang[note] In case you're interested in this test, other /etc/system parameters are (from sysdef | grep -i shm):sys/shmsys2111934921 max shared memory segment size (SHMMAX) ...

1.set env var,create init.ora file2.create orapw$sid password file3.create spfile4.startup nomount5.create database6.catalog.sql7.catproc.sql8.catexp.sql9.other sql run10./etc/vfstab cat vfstab11.edit...

A young engineer in Foxconn for OEM iPhone kill himself for lost a prototype iPhone...[@more@]God bless him, hope no iPhone in the heaven..

You cannot drop it directly with the drop table command, it will prompt error like this:SQL> drop TABLE STREAMS_QUEUE_TABLE;drop TABLE STREAMS_QUEUE_TABLE       &nb...

利用Oracle工具sysresv来显示、清除共享内存和信号量[@more@]Oracle从8i开始提供sysresv工具来对Oracle使用的共享内存和信号量进行管理。当服务器上存在多个实例时，该命令能显示每个实例对应的共享内存和信号量，当一个实例由于某种原因崩溃了，但是由该实例创建的共享内存和信号量却没有被系统回收清理掉，可以用这个工具来清除应该回收的共享内存和信号量。usage : sysresv [-if] [-d <on/off>] [-l sid1 <sid2> ...] -i : Prompt before removing ipc resources for each sid -f : Remove ipc resour

IntroductionA trigger is a compiled procedure stored in the database. The language you use is PL/SQL. You code and compile a trigger in the same manner you code stored procedures. The following is the...

User ShutDown DB Instance and caused the rollback segment crashed, ...At 26,Dec. 2005, Got a call from a friend that , his db's rbs tablespace increased over 6GB cause some block corruption of a rbs, ...

The trigger body is written in PL/SQL. There are PL/SQL expressions that only have meaning within a trigger body. These topics are covered in the following paragraphs.A trigger body can refer to two s...

NumberCommand          1CREATE TABLE2INSERT3SELECT4CREATE CLUSTER5ALTER CLUSTER6UPDATE7DELETE8DROP CLUSTER9CR...

This document covers the steps needed to be apply an incremental RMAN backup to a standby database. This document is intended for oracle 10g databases only.  1     &nbsp...

许多事业上受过重大挫折的人，最普遍的失败原因有6点。你可能也发现自己受过同样的挫折。 败局之一──处世无方 因为这个原因而失败的人，多半会归咎"办公室权术"害了他们，但所谓权术，说不定只是正常的人际关系而...