ITPub博客

From metalinkInternally, Oracle uses various types of structures, the access of which is controlled using a variety of mechanisms, including latches. In this article, Oracle expert Megh Thakkar discus...

HP-UX Itanium 10.2.0.2 & 10.2.0.3 Oracle DatabaseORA-00600: internal error code, arguments: [kghsskins1], [], [], [], [], [], [], []ISSUE CLARIFICATION====================ORA-00600 [kghsskins1] repo...

For Oracle DBA Daily/Weekly/Monthly ChecklistA. Verify all instances are upMake sure the database is available. Log into each instance and run daily reports or test scripts. Some sites may wish t...

Alter system kill session ........Problem Description------------------- You have killed a session at the os level. Now, the session is showing "killed" in v$session but v$access is showing objects lo...

global cache cr request当一个进程访问需要一个或者多个块时，它会首先检查自己的CACHE是否存在该块，如果发现没有，就会先通过global cache赋予这些块共享访问的权限，然后再访问。假如，通过global cache 发现这...

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

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

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

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

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