-
编辑 删除
翻译 Oracle 8i interal Service （2.2.2 wait types）
2.2.2 Wait TypesV$SYSTEM_EVENT shows the total number of waits and timeouts, and the total waiting time recorded for each type of event, accumulated for all processes over the life of the instance. It...
-
编辑 删除
BBED修改数据文件的SCN
BBED修改数据文件的SCN1.编译BBED make: *** No rule to make target `ins_rdbms.mk'. Stop.[oracle@linux2 oracle]$ cd $ORACLE_HOME/rdbms/lib[oracle@linux2 lib]$ make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib...
-
编辑 删除
修改数据文件的SCN来恢复数据库
非归档下offline drop 一个数据文件的恢复1。先offline drop一个表空间的数据文件，在alter system switch logfile,使redo中的信息覆盖。2。查看文件的SCN：v$datafile或通过UltraEdit打开正常的数据文件，查看check...
-
编辑 删除
丢失所有控制文件和日志文件,恢复数据库。
非归档，在丢失所有控制文件和日志文件，并且数据库是shutdown abort的情况下打开数据库。1。SQL> shutdown abortORACLE instance shut down.2。删除所有控制文件和日志文件。3。重建控制文件SQL> editWrote file af...
-
编辑 删除
翻译 Oracle 8i interal Service (3.2 Parent and Child Latches)
3.2 Parent and Child LatchesMost internal Oracle data structures that are protected by latches are protectedby only one latch. However, in some cases more than one latch may be used. Forexample, there...
-
编辑 删除
存在Histogram数据,使用绑定变量的情况.
SQL> select * from v$version;BANNER----------------------------------------------------------------Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionPL/SQL Release 9.2.0.1.0 - ProductionCORE 9...
-
编辑 删除
翻译 Oracle 8i interal Service (3.1 Latches and Locks)
Chapter 3. LatchesThere are numerous data structures in Oracle's System Global Area (SGA) that need to beaccessed concurrently by many different database processes. It is essential that only oneproces...
-
编辑 删除
对通过index range scans访问的表的优化
表authors有1706123行,39677个blocks,259个empty blocks,在au_fname有索引INDEX_AUTHORS.对表进行分析.Analyze Table AUTHORSCompute StatisticsFor All Indexes;SQL> select CLUSTERING_FACTOR from dba_indexes wh...
-
编辑 删除
一次ORA-27037: unable to obtain file status故障的解决
数据库前端用两台solaris服务器（DB1,DB2）做HA，数据文件存放在存储上和NAS上。试过之前没做过切换。目前运行在DB1上。bash-2.03$ df -kFilesystem kbytes used avail capacity Mounted on/dev/dsk/c1t0d0s0 2...
-
编辑 删除
翻译 Oracle 8i interal Service (2.2.3 Session Waits)
V$SESSION_EVENT shows the wait statistics for each live session. Althoughwaits affect processes rather than sessions, they are recorded against sessionsbecause sessions can migrate between processes (...
-
编辑 删除
错删除表空间,有rman全备的恢复
错删除表空间,有rman全备的恢复错删除表空间,有rman全备的恢复1.生成测试数据SQL> startupORACLE 例程已经启动。Total System Global Area 105978600 bytesFixed Size 453352 bytesVariable Size 79691776 bytesData...
-
编辑 删除
Optimize Oracle UNDO Parameters
Optimize Oracle UNDO Parameters转自http://www.akadia.com/OverviewStarting in Oracle9i, rollback segments are re-named undo logs. Traditionally transaction undo information was stored in Rollback Segme...
-
编辑 删除
翻译 Oracle 8i interal Service (2.2.4 Wait Parameters)
2.2.4 Wait ParametersThe wait statistics are very useful because they tell you which sessions have beenwaiting, and which types of resources they have been waiting for. They may havebeen waiting for l...
