AnySQL.net数据复制，数据迁移，数据库优化，系统监控，备份恢复，报表展现，原创工具等Weblog 产品介绍技术服务工具下载博客聚合文章归档关于我们orastats & mysqlstats通用监控工具Posted by anysql on 2013-03-19select name, bytes from v$sgastatunion allselect name, value from v$sysstatselect name, value from v$sgaKey|{CURR|DELTA}|Label|…user=sysquery=select name, value from v$sgaformat=Fixed Size|curr|Fixed|Variable Size|curr|VarS|Database Buffers|curr|Data|loop=10wait=5D:\MyTools\x64>orastats parfile=orastats.txt2013-03-19 22:57:08 Fixed VarS Data2013-03-19 22:57:08 2174k 134m 134m2013-03-19 22:57:13 2174k 134m 134m2013-03-19 22:57:18 2174k 134m 134m2013-03-19 22:57:23 2174k 134m 134m2013-03-19 22:57:28 2174k 134m 134m2013-03-19 22:57:37 2174k 134m 134mD:\MyTools\x64>orastats parfile=orastats.txt wait=5 loop=1 format=orastats.timestamp=2013-03-19 22:58:46Database Buffers=134217728.000000Fixed Size=2174888.000000Redo Buffers=5005312.000000Variable Size=134217816.000000Tools No Comments »从MySQL迁移数据到Oracle库的工具Posted by anysql on 2013-02-01mysql2ora.exe user1=/@::test user2=test/test table1=emp_his table2=emp_his direct=yes filler=id0 rows processed at 2013-02-01 21:01:39.1000000 rows processed at 2013-02-01 21:01:41.2000000 rows processed at 2013-02-01 21:01:44.3000000 rows processed at 2013-02-01 21:01:46.3830800 rows processed at 2013-02-01 21:01:48.mysql2ora.exe user1=/@::test user2=test/test table1=emp_his table2=emp_his filler=id0 rows processed at 2013-02-01 21:11:24.1000000 rows processed at 2013-02-01 21:11:28.2000000 rows processed at 2013-02-01 21:11:32.3000000 rows processed at 2013-02-01 21:11:37.3830800 rows processed at 2013-02-01 21:11:40.Tools No Comments »按事务一致性导出的数据Posted by anysql on 2013-01-31Hi Fangxin,user=stats_user/stats_user@tooldbpresql=set transaction read onlyquery=select * from all_objectsfile=nulquery2=select * from all_tables
file2=nul
E:\>.\sqluldr2 parfile=test.txt

0 rows exported at 2013-01-31 13:07:43, size 0 MB.

12916 rows exported at 2013-01-31 13:07:44, size 1 MB.

output file nul closed at 12916 rows, size 1 MB.

0 rows exported at 2013-01-31 13:07:44, size 0 MB.

1435 rows exported at 2013-01-31 13:07:44, size 0 MB.

output file nul closed at 1435 rows, size 0 MB.
Tools 2 Comments »
从MySQL数据库自由导出文本
Posted by anysql on 2013-01-18
SQL*UnLoader: Fast Oracle Text Unloader (GZIP, Parallel), Release 4.0.1
(@) Copyright Lou Fangxin (AnySQL.net) 2004 – 2010, all rights reserved.
user = username/password@tnsname

sql = SQL file name

query = select statement

field = separator string between fields

record = separator string between records

rows = print progress for every given rows (default, 1000000)

file = output file name(default: uldrdata.txt)

log = log file name, prefix with + to append mode

fast = auto tuning the session level parameters(YES)

text = output type (MYSQL, CSV, MYSQLINS, ORACLEINS, FORM, SEARCH).

charset = character set name of