ITPub博客

http://203.208.39.132/search?q=cache:8fYSCnEDEuMJ:www.cnblogs.com/yifan268/archive/2009/04/09/1432671.html+A+row+in+the+leaf+block+of+the+index+for+the+key+value+is+deleted+and+inserted.&cd=1&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy2_kDiML_-bsFj-V3qU7ADErZ7MVpA[@more@]---20090409 test delete row 对index 空间的影响---DB version ：8174 & 10204--建立环境CREATE TABLE mestst.xmTEST1( ID VARCHAR2(10 ), NAME VARCHAR2(10 ))TABLESPACE USERS; CREATE IND

http://203.208.39.132/search?q=cache:G6VNIhr2AWoJ:www.builder.com.cn/2007/0915/507188.shtml+TNSPING&cd=1&hl=zh-CN&ct=clnk&gl=cn&st_usg=ALhdy29lFhW22ega5yVA7dBxDI54394oaw[@more@]比较orale的tnsping与TCP/IP的ping命令：　　-----------------------------------------------------------------------------　　Oracle Net 工具（命令）tnsping，是一个OSI会话层的工具，它用来：　　1）验证名字解析（name resolution，当然是oracle自己的网络服务名）　　2）远程的listener是否启动　　在验证上面两项功

http://empo007.itpub.net/post/12076/465449[@more@]这里对10G的AWR,ASH,METRIC,ALERT&ADVISOR进行下总结1、AWR架构包含两个部分，一个是in-memory statistics，存放在内存中，一个是persistent portion2、AWR中存放下面的统计信息：Object statistics，new SQL statistics，The new wait classes interface，The new time-model statistics，V$SYSSTAT and V$SESSTAT，Oracle optimizer statistics，Operating system statistics，Active Session History，Metrics3、ASH中包含最近会话的活动信息，系统每秒对v$session进行抽样，放

http://space.itpub.net/?471666/viewspace-217128[@more@]oracle推出已经2年多了，但只在04年用过几个月，之后接触的数据库大部分是8i和9i，所以，很多10g的新特性没有接触到。现在有时间可以学习10g了。打算用一系列的文章来记录学习10g新特性的心得。一、概述awr(Automatic Workload Repository)是oracle 10g推出的一个强有力的信息收集工具，它比之前的statspack有显著的改进，收集的信息也更多、更全面，使用方法也更简单。二、安装awr是默认安装的，装好了10g的数据库就已经可以使用awr了。三、配置awr默认每个小时收集一次统计信息

151. View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERT view.After 30 minutes, you executed the following command:SQL> SELECT reason,metric_value FROM dba_outstanding_alerts;REASONMETRIC_VALUE-----------------------------------------------------------------------------Tablespace [TEST] is [28 percent] full 28.125What could be the two reasons for the elimination of the other rows in the output? (Choose two.) A) The threshold alert conditions are cleared.B) The threshold alerts

http://203.208.39.132/search?q=cache:Oup0IPnh-ScJ:tolywang.itpub.net/post/48/309884+Oracle+Shared+Server+configuration&cd=1&hl=zh-CN&ct=clnk&gl=cn&st_usg=ALhdy28WDhCP7SpoiRNW-w-Qo-1nWOf9mQ[@more@]=========================================================== 作者: tolywang(http://tolywang.itpub.net)发表于:2007.07.19 09:59分类: Oracle数据库管理 出处：http://tolywang.itpub.net/post/48/309884--------------------------------------------------------------- 1、overview:dedicated Serve

使用ddl跟踪发现drop实际上完成两个动作：rename 和drop ，我不明白的是为何rename了以后还可以drop table t?使用ora_rowscn不能找回以前修改的记录，因为变化是跟随着block为单位的，一个block中包含很对row,只能记录最后一个row的变化瞬间之前的时间[@more@]对一个表反复flashback发现rowid在来回两个地址上变化，不分配新的地址；AAAMHvAAHAAAAAsAABAAAMHvAAHAAAAAsAAAAAAMHvAAHAAAAAsAABAAAMHvAAHAAAAAsAAAAAAMHvAAHAAAAAsAABSelect scn_to_timestamp(445331) From dual 09-10月-09 05.13.55.000000000 下午 09-10月-09 05.13.52.000

原创[@more@]--检查是否可以闪回Select flashback_on from v$database; --闪回数据库--建立表Create table t(id int);Create or replace procedure p_tAs V_count int;Begin Select count(*) into v_count from t;End;/--建立触发器Create or replace trigger tri_t_ariudAfter insert or update or delete on tFor each rowIs V_rtn int;Begin V_rtn := 2;End;/--建立索引Create index idx_t_id on t(id);--检查当前的scn方便返回Select dbms_flashback.get_system_change_number from v$database;--插入记录Insert into t values(1

发给大家[@more@]第一章：日志管理 1.forcing log switchessql> alter system switch logfile;2.forcing checkpoints sql> alter system checkpoint;3.adding online redo log groups sql> alter database add logfile [group 4]sql> ('/disk3/log4a.rdo','/disk4/log4b.rdo') size 1m;4.adding online redo log memberssql> alter database add logfile membersql> '/disk3/log1b.rdo' to group 1,sql> '/disk4/log2b.rdo' to group 2;5.changes the name of the online redo logfilesql> alter database rename

http://blog.csdn.net/zhpsam109/archive/2006/11/09/1376266.aspx[@more@] 在 oracle 10g 中,可以创建多个临时表空间,并把它们组成一个临时表空间组,这样应用数据用于排序时可以使用组里的多个临时表空间,一个临时表空间组至少有一个临时表空间,其最大个数没有限制,组的名字不能和其中某个表空间的名字相同。 临时表空间组是在创建临时表空间时通过指定group字句创建的,如果删除组中的全部临时表空间,那么这个组也将消失。 我们将可以将一个表空间从一个组移动另一个组,或是从一个组中删除临时表空间,或是往组里添加新的表

http://203.208.39.132/search?q=cache:HWVo-k7-Qd8J:www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/statements_4003.htm+alter+user+default+role+all+except&cd=2&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy2_P-vPWNNI9YlOWQTrNdipSu_5X9w[@more@]alter user test default role all except create_table; 什么意思？Select * from dba_role_privs中存在default 属性，缺省给用户授予的角色都是yes,就是logon以后可以使用的，如果是no的，需要在会话中 问题：角色授权的时候

Oracle Resumable Space AllocationOracle Tips by Burleson Consulting[@more@]Resumable space allocation, introduced in Oracle 9i, is for all tablespaces at the session level. Database operations are suspended when an out-of-space condition is encountered. These suspended operations automatically resume when the error condition disappears. In Oracle Database 10g, this can be enabled at the instance level. Besides this improvement, automatic alert notification is sent when an operation is suspended

http://203.208.39.132/search?q=cache:442TAM_ydcAJ:blog.oracle.com.cn/index.php/12012/viewspace-6280.html+RESUMABLE_TIMEOUT&cd=1&hl=zh-CN&ct=clnk&gl=cn&client=aff-os-360se&st_usg=ALhdy290zy_Ck3SMisXCD3DcyvYx92J_WA128. In the PROD database you have granted the RESUMABLE system privilege to the CONNECT role.Resumable space operation has been enabled for all user sessions. You want users NOT to be aware of anykind of space-related problems while performing transactions. Inste

http://203.208.39.132/search?q=cache:0W30-f-vGR0J:www.experts-exchange.com/Database/Oracle/Product_Info/Q_20643126.html+Oracle+_allow_resetlogs_corruption&cd=5&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy2_LW_AVy-icVpOxO7QQE_ItfJrYew[@more@]This is a two-part question.I have a partially restored database where I have some new, and some older datafiles. Together I have them all. No archivelogs, no anything. This is the path I must take!I have to do a force

http://203.208.39.132/search?q=cache:ZrnX9GSMNm8J:read.newbooks.com.cn/info/195974.html+Oracle+CHECKPOINT_CHANGE%23+%3D+0+v%24datafile&cd=5&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy2_szIuEy5JwMTxqL6yQfC2lascIyw[@more@]scn号与oracle数据库恢复过程有着密切的关系，只有很好地理解了这层关系，才能深刻地理解恢复的原理，从而才能很好地解决这方面的问题。 一。SCN与CHECKPOINT CKPT进程在checkpoint发生时，将当时的SCN号写入数据文件头和控制文件，同时通知DBWR进程将数

http://203.208.39.132/search?q=cache:URJ2wfFaimAJ:space.itpub.net/9421572/viewspace-206239+Oracle+CHECKPOINT_CHANGE%23+%3D+0+v%24datafile&cd=1&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy29hYvP54goF6NW8lkZ_9GEQzGYX9Q[@more@]实验1：数据库正常运行时的各个SCN值SQL> select dbms_flashback.get_system_change_number from dual;GET_SYSTEM_CHANGE_NUMBER------------------------ 547250SQL> select checkpoint_change# from v$database;CHECKPOINT_CHANGE

http://203.208.39.132/search?q=cache:4BWUg5KYn24J:www.51testing.com/%3Fuid-1854-action-viewspace-itemid-6579+Oracle+ORA-01190&cd=1&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy2-NWlPJt6kWe9WRaPA4rTZ3fuPnlg[@more@]在进行RMAN操作的时候,当出现了控制文件和数据库文件的SCN不一致的情况,系统不能正常的OPEN,此时出现的错误号码为:ORA-01190此时需要修改init<dbname.ora>_allow_resetlogs_corruption=FALSE将其该为TRUE在SQL命令行中使用create spfile from pflie (将修改后的pf

http://203.208.39.132/search?q=cache:TTlxSoeT0twJ:www.cublog.cn/u/20078/showart.php%3Fid%3D462659+Oracle+ORA-01190:+%E6%8E%A7%E5%88%B6%E6%96%87%E4%BB%B6%E6%88%96%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6+%E6%9D%A5%E8%87%AA%E6%9C%80%E5%90%8E%E4%B8%80%E4%B8%AA+RESETLOGS+%E4%B9%8B%E5%89%8D&cd=8&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy29-J4kzC8miXSm5tt6gFtH_SInI_g[@more@]SQLPLUS>ALTER DATABASE DATAFILE 2 ONLINE;ALTER DATABASE DATAFILE 2 ONLINE*ERROR 位于第 1 行

请问各位在v$undostat中该属性好像是一个地址，记录的是在starttime和endtime这段时间内出现的sql语句消耗的undo大小的sql标记，我是否能够根据这个属性和别的例如v$sql关联来查询出相关的sql语句？[@more@]

http://203.208.39.132/search?q=cache:moSKLP4q_s0J:school.cnd8.com/oracle/jiaocheng/37407.htm+Oracle+UNDO_RETENTION&cd=4&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy284cNxsbtRS5YZXuQC3mMRz995GUw[@more@]昨天，一个朋友的数据库数据被误操作删除掉了，请求我帮忙进行恢复。数据库版本是Oracle10g Release 2的，我首先想到的是使用Flashback Query进行闪回恢复，不幸的是ORA-01555，数据已经不能被闪回了。查看当时的数据库参数undo_retention设置，发现这个参数被在10g中缺省的被设置为