dbsnake.net
» About Me Focus on Oracle
http://www.dbsnake.net/about-me
How to use embedded BBED in ODU to manually fix missing offset in row directory. 隐含参数 minimum giga scn被Oracle废弃后如何调SCN. Library cache lock latch和library cache pin latch的持有顺序. On 一次library cache pin故障的解决过程. On 一次library cache pin故障的解决过程. On UPDATE GLOBAL NAME为空之后的恢复.
dbsnake.net
» Oracle数据库优化器探秘 Focus on Oracle
http://www.dbsnake.net/inside-oracle-optimizer.html
隐含参数 minimum giga scn被Oracle废弃后如何调SCN. November 18, 2013 Author:. 10 Comments on “Oracle数据库优化器探秘”. December 26, 2013 at 9:57 pm. December 28, 2013 at 11:36 pm. December 29, 2013 at 4:14 pm. January 7, 2014 at 3:24 pm. January 7, 2014 at 3:59 pm. January 19, 2014 at 11:31 am. April 16, 2014 at 7:06 pm. November 20, 2014 at 4:31 pm. December 14, 2014 at 11:39 pm. April 9, 2015 at 2:14 pm. Leave a Reply Cancel reply. Your email address will not be published. Required fields are marked *.
dbsnake.net
» CPU cost对全表扫描成本的影响 Focus on Oracle
http://www.dbsnake.net/cpu-cost-model-and-tsc.html
Library cache lock latch和library cache pin latch的持有顺序. June 10, 2012 Author:. Single-block reads are just as expensive as multiblock reads. Db file multiblock read count. MBDivisor = 1.6765 * power(db file multiblock read count, 0.6581). Tsc cost = Num Blocks / MBDivisor. PARAMETERS USED BY THE OPTIMIZER. OPTIMIZER FEATURES ENABLE = 9.2.0. OPTIMIZER MODE/GOAL = Choose. DB FILE MULTIBLOCK READ COUNT = 16. Table: OPFQ QUE ITM. Alias: OPFQ QUE ITM. TABLE: OPFQ QUE ITM. DB FILE MULTIBLOCK READ COUNT. 8000/(1...
dbsnake.net
» Oracle数据库里什么情况下select操作会hang住 Focus on Oracle
http://www.dbsnake.net/oracle-select-hang-case.html
Larr; Oracle里Instance Recovery的终点. June 28, 2012 Author:. 数据库里是 读不阻塞写，写不阻塞读 ， 那么我们可不可以认为在正常情况下，. Trace lock operations */. DUMP CALL STACK WITH TRACE */. DUMP KGL OBJECT WITH TRACE */. DUMP KGL ENQUEUE WITH TRACE */. DUMP BY HASH VALUE */. SQL select to number(‘210′,’XXXX’) from dual;. TO NUMBER(‘210′,’XXXX’). 8212;——————–. C: Documents and Settings cuihua sqlplus /nolog. SQL*Plus: Release 11.2.0.1.0 Production on. SQL conn / as sysdba;. SQL oradebug event 10049 trace name context forever,level 528.
dbsnake.net
» Books Focus on Oracle
http://www.dbsnake.net/books
Coe xfr sql profile.sql. Display cursor 9i.sql. P app type perf diff demo.prc. P gen multl sql with bind v.prc. P SYS GEN CODE TEMPLATE1.prc. P SYS GEN CODE TEMPLATE2.prc. How to use embedded BBED in ODU to manually fix missing offset in row directory. 隐含参数 minimum giga scn被Oracle废弃后如何调SCN. Library cache lock latch和library cache pin latch的持有顺序. On 一次library cache pin故障的解决过程. On 一次library cache pin故障的解决过程. On UPDATE GLOBAL NAME为空之后的恢复.
dbsnake.net
» Oracle Focus on Oracle
http://www.dbsnake.net/category/oracle
March 4, 2015. SQL select * from v$version;. 8212;—————————————————————————–. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production. PL/SQL Release 11.2.0.3.0 – Production. TNS for Linux: Version 11.2.0.3.0 – Production. NLSRTL Version 11.2.0.3.0 – Production. SQL create table t1 as select * from dba users;. SQL select object id from dba objects where owner=’SCOTT’ and object name=’T1′. 8212;—————-. 8212;—————————. 8212;——-. SQL select count(*) from t1 where user id=5;. 8212;—...
dbsnake.net
» 如何禁掉ASM实例的AMM Focus on Oracle
http://www.dbsnake.net/how-to-disable-asm-instance-amm.html
Larr; How to use embedded BBED in ODU to manually fix missing offset in row directory. March 7, 2014 Author:. RedHat 6.3 x86 64. GI PSU 11.2.0.3.9. Patch:17063116 for 11.2.0.3.7. Patch:11072246 for 11.2.0.3.9. Oracle@rddb2 ]$ su – grid. Grid@rddb2 ]$ sqlplus ‘/ as sysasm’. SQL*Plus: Release 11.2.0.3.0 Production on Thu Mar 6 10:29:23 2014. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production. With the Real Application Clusters and Automatic Storage Management options. CRS-2673: At...
dbsnake.net
» 用好UTL_FILE包其实并不是太容易 Focus on Oracle
http://www.dbsnake.net/not-so-easy-to-use-utl-file.html
October 26, 2012 Author:. UTL FILE.PUT LINE. UTL FILE.GET LINE. UTL FILE.PUT LINE. UTL FILE.PUT LINE. SQL select value$ from sys.props$ where name=’NLS CHARACTERSET’. 8212;—————————————————————————–. SQL create table t1(c1 varchar2(2000) ;. SQL insert into t1 values(‘TEST1. SQL select * from t1;. 8212;—————————————————————————–. SQL select directory name,directory path from dba directories where directory name=’TEST’. Inf utl file.file type;. O vc return flag varchar2(2000);. Utl file.fclose(inf);. SQL s...
SOCIAL ENGAGEMENT