-
编辑 删除
关于legacy system中使用bind variables(zt)
http://preferisco.blogspot.com/2006/04/how-many-binds-does-it-take-to-save.htmlSunday, April 02, 2006How many binds does it take to save time? Here's a tale about how something that seems intuit...
-
编辑 删除
mysql中权限控制粒度与性能的平衡
在mysql.user,mysql.host,mysql.db 等权限表中进行过细的控制会影响到sql 的性能，mysql manual中有详细的描述,以后补充.
-
编辑 删除
mysql执行命令报segmentation fault 错误
admin@xxx:/tmp$ ./mysql -uxxx -pxxx -h172.16.x.xWelcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 507 to server version: 4.1.14-logType 'help;' or '\h' f...
-
编辑 删除
ssh Interrupted system call
admin@xxx:/tmp$ scp admin@172.16.x.x#37000:/usr/local/bbs/mysql .Host key not found from database.Key fingerprint:xukik-hazut-hecar-modyb-bofep-levob-hobon-carim-hirav-deref-zyxexYou can get a public ...
-
编辑 删除
how to use typeset?
admin@xxx:~$ typesetBASH=/bin/bashBASH_VERSINFO=([0]="2" [1]="05a" [2]="0" [3]="1" [4]="release" [5]="i386-slackware-linux-gnu")BASH_VERSION='2.05a.0(1)-release'C2CDB_HOME=/usr/local/c2cdbCOLUMNS=132D...
-
编辑 删除
SET GLOBAL SQL_SLAVE_SKIP_COUNTER
<<MySQL Reference Manual>>P445文中的意思是当master传到slave的语句中要用到auto_increment,或者last_insert_id()时,需要skip两个event. 但实际情况并非如此-------------------quote begin----------------------...
-
编辑 删除
expdp report error when export tables
;;;Export: Release 10.2.0.1.0 - 64bit Production on Friday, 09 February, 2007 11:02:01Copyright (c) 2003, 2005, Oracle. All rights reserved.;;;Connected to: Oracle Database 10g Enterprise Editi...
-
编辑 删除
How Can I unload data to a flat file
http://www.evdbt.com/unload.sqlhttp://www.jaredstill.com/content/dump.htmlhttp://asktom.oracle.com/tkyte/flat/index.htmlhttp://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:728625409049...
-
编辑 删除
shared_pool_lru_stats
http://www.freelists.org/archives/oracle-l/11-2004/msg00291.htmlhttp://www.freelists.org/archives/oracle-l/04-2006/msg01150.html
-
编辑 删除
Oracle, History and the Wait Interface
http://www.dbazine.com/olc/olc-articles/still3
-
编辑 删除
Pipelined Functions
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:19481671347143
-
编辑 删除
mysql中创建包括特殊字符的帐号
要求创建一个帐号为!bbs@,口令为%adfdf$df%mysql> grant select on *.* to \!bbs@@localhost identified by 'a';sh: identified: command not found -> mysql> grant select on *.* ...
-
编辑 删除
mysql中的表大小限制
for myisam, it depend the filesystem limit on the systemfor innodb,can exceed the file size limit to tablespace limit, the maximum is 64TB.see the following articlehttp://lists.mysql.com/mysql/204119m...
-
编辑 删除
各种不同文件系统的比较,信息很详细
http://simlovic.sk/wikipedia/en.php/Comparison_of_file_systems
-
编辑 删除
oracle10.2.0.1.0中与all_objects有关的bug
IIRC this is a known bug. Just go back to 9i view definition or changethe all_objects view definition with /*+RULE */ hint.K GopalakrishnanCo-Author: Oracle Wait Interface, Oracle Press 2004http://www...
-
编辑 删除
在sqlplus交互环境下测试存储过程
sqlplus手册中说得比较清楚Use the following commands to create and display bind variables.PRI[NT] [variable ...]Displays the current values of bind variables, or lists all bind variables.VAR[IABLE] [va...
-
编辑 删除
找出B中没有包括A中对像的同义词的A对像
column object_name format a30select a.owner, a.object_name, a.object_type from dba_objects a where a.owner = '&BASE_OBJECT_SCHEMA' -- choose ...
-
编辑 删除
library cache pin 中block情况
library cache pin在compile 对像(比如procedure,function,package,triiger等)时发生得较多.通过下面的脚本可以观察lock情况.select decode(lob.kglobtyp, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER',...
-
编辑 删除
dml locks(dml_locks)
Parameter type IntegerDefault value Derived: 4 * TRANSACTIONSModifiable NoRange of values 20 to unlimited; a setting of 0 disables enqueuesBasic NoReal ApplicationClustersYou must set this parameter f...
-
编辑 删除
dbms_xplan
测试表：create table tb1 as select dba_objects;SQL>delete from plan_table;SQL>explain plan for select owner,object_type,count(*) from tb1 group by owner,object_type;SQL> select * from table( dbms_xpla...
