DataBase
半路出家-
5年Java渣渣一枚,做过外包,进过国企,初入互联网
展开
-
sybase 数据导入导出
bcp cnmsdb..FaultDetail out ./sunw.dat -F 1 -L 20 -Ucnms -Pseenms -SSYBASE_TEST -c bcp cnmsdb..FaultDetail in ./sunw.dat -Ucnms -Pseenms -SZOOM192 -c原创 2011-05-24 16:39:22 · 332 阅读 · 0 评论 -
SPID
SELECT /*+ ORDERED */ sql_text FROM v$sqltext a WHERE (a.hash_value, a.address) IN ( SELECT DECODE (sql_hash_value, 0, prev_hash_value, ...原创 2011-08-27 10:20:07 · 387 阅读 · 0 评论 -
sybase统计
select @@maxpagesize/1024 每页大小数据空间统计脚本:select convert(varchar(20),round((sum(u.size)*(select @@maxpagesize/1024)/1024.0),0))+'MB',convert(varchar(20),round(sum(curunreservedpgs(db_id(),u.lstart,u.un...原创 2011-07-29 09:37:51 · 192 阅读 · 0 评论 -
sybase oracle 死锁
select l.spid, locktype=convert(char(12),name), dbname=convert(char(15),db_name(l.dbid)), 'table'=convert(char(15),object_name(l.id,l.dbid)), page, ...原创 2011-10-27 16:45:30 · 112 阅读 · 0 评论 -
操作前判断
部分摘自:http://dingchaoqun12.blog.163.com/blog/static/116062504201112554459595/ MySQL:DROP TABLE IF EXISTS [table_name]Oracle:BEGIN EXECUTE IMMEDIATE 'DROP TABLE [table_name]'; ...原创 2011-12-07 15:50:14 · 162 阅读 · 0 评论