DBA Tools |
|
Good tools make the work easy and improve life quality. |
|
Archives
- 2008.03.20: Recover the table's index structure information.
- 2008.03.20: Recover the Oracle stored procedures' source code.
- 2008.01.18: AnySQL for Micrsoft SQL Server and Sybase
- 2008.01.09: Linux Kernel Parmaters for Oracle 10g RAC
- 2008.01.02: Mini VMWare Oracle RAC (3GB) on RedHat Linux
- 2007.12.31: Install the basic Linux X-Window for xterm
- 2007.12.24: Get Oracle DDL Script
- 2007.12.24: Get Oracle space usage information in AnySQL
- 2007.12.22: Drop 4TB table on dictionary managed tablespace
- 2007.12.20: Describe tables with indexes structure information
- 2007.12.20: What AnySQL learned from MySQL?
- 2007.12.20: Download AnySQL at file.io file sharing service.
- 2007.12.17: Who is the table lock owner / holder?
- 2007.12.13: How AnySQL connect to Oracle database?
- 2007.12.03: How oramon track Oracle performance? -- V$SESSION
- 2007.11.29: Fast Oracle text unload speed with ociuldr by Alibaba
- 2007.11.28: How to improve the performance of Oracle exp/imp?
- 2007.11.27: How oramon track Oracle performance? -- V$SYSSTAT
- 2007.11.20: How many lines in AUL/MyDUL's source code?
- 2007.11.19: How to deinstall and install Oracle XML database (XMLDB/XDB)?
- 2007.11.19: AUL/MyDUL data recovery service models
- 2007.11.16: What's Oracle 11G's compress table support for OLTP system?
- 2007.11.08: More robust DMP format support in AUL version 5
- 2007.11.02: AUL 5 Beta version launched, all features under testing.
- 2007.11.02: ALTER TABLE ... MODIFY DEFAULT ATTRIBUTES ...
- 2007.11.01: Oracle Compress Table Block Format (3)
- 2007.10.31: Source code of Oracle AUL/MyDUL, wroten in Java, but not jDUL copy
- 2007.10.30: Oracle Compress Table Block Format (2)
- 2007.10.30: Oracle Compress Table Block Format (1)
- 2007.10.30: Poor SUN CPU speed for Oracle compress table
- 2007.10.25: When lossing one of the data files for a tablespace
- 2007.10.23: Compare index structure difference between tables
- 2007.10.19: The Oracle data recovery without system is really complex.
- 2007.10.19: Oracle JDBC Asia language support of US7ASCII or WE8ISO8859P1 database
- 2007.10.19: Compare column for different tables on different databases.
- 2007.10.18: Using AUL/MyDUL in a 2TB Oracle database recovery
- 2007.10.16: Compare column for the same table on different databases.
- 2007.10.16: Windows explorer runs slowly due to network drives mapping
- 2007.10.16: Compare column for different tables on the same database.
- 2007.10.16: Fastest Oracle data recovery service by AUL/MyDUL utility
- 2007.10.15: Track Oracle database performance with oramon utility
- 2007.10.15: Compare column script for tables on different databases.
- 2007.10.15: How my DBDiff (ocidiff) utility works for different objects?
- 2007.10.11: New command line option for text export utility -- BUFFER
- 2007.10.11: Cost saving in wrong place
- 2007.10.11: The payment of AUL Oracle data recovery service.
- 2007.10.11: How AUL support the partition table's CLOB/BLOB recovery?
- 2007.10.11: How AUL support different Oracle CLOB/BLOB chunk size?
- 2007.10.11: Tuning Oracle SQL performance by rewriting it.
- 2007.10.11: Performance issue by OR operation because filter at table level.
- 2007.10.10: How to perform bulk delete in PL/SQL for better performance?
- 2007.10.10: How to modify the storage properties of XMLTYPE type?
- 2007.10.10: How to choose the SIZE and HASHKEYS of hash cluster table?
- 2007.10.10: Compute statistics when creating index will analyze table in Oracle 9i
- 2007.10.10: How to handle resource busy (ORA-00054) error in Oracle?
- 2007.10.10: Connect to Oracle database without tnsnames.ora configuration?
- 2007.10.10: The steps of Oracle table online redefination
- 2007.10.10: How much files can be stored in one directory?
- 2007.10.10: Some LOB recovery related options in AUL/MyDUL utility.
- 2007.10.10: How to change the character set of the export dmp file?
- 2007.10.10: lslog -- read basic information form archived log file
- 2007.10.09: How does Oracle csscan utility working?
- 2007.10.09: How to compile version independent OCI program on Linux/Unix?
- 2007.10.09: How to recover Oracle data when losting system tablespace?
- 2007.09.29: Analyze or DBMS_STATS, choose one but don't mix them
- 2007.09.29: Oracle Bug : exp-00003 when export tables with LOB columns
- 2007.09.29: Integrite RMAN data file copy feature into Shell/Perl script
- 2007.09.28: How to compile Oracle Call Interface (OCI) program?
- 2007.09.27: Choosing right separators when unload (export) rows to text file
- 2007.09.27: How to pass parameters to your program in Shell script.
- 2007.09.26: The LONG RAW data type support of text unload (export) utility
- 2007.09.26: How to move Oracle context index to another tablespace?
- 2007.09.26: Convert to Veritas Quick-IO file with shell script.
- 2007.09.25: Got the "Table is full" error for MySQL memory engine table
- 2007.09.25: How to install or uninstall (remove) Context on Oracle 9i/10g?
- 2007.09.25: What does the REPLACE mode of Oracle SQL Loader do?
- 2007.09.25: How to specify query option of Oracle export utility.
- 2007.09.21: Use MyLOG to fasten the recovery of drop operation
- 2007.09.21: MyLOG, an offline Oracle log miner to extract the redo SQLs
- 2007.09.20: Operation through Oracle Enterprise Manager (OEM) is dangerous
- 2007.09.20: Tools can be used to copy archived log to remote host
- 2007.09.20: Make some changes to the text unload utility -- ociuldr
- 2007.09.19: Migrate data from US7ASCII database to UTF8 database
- 2007.09.19: Write Windows batch script to load the data for AUL (MyDUL)
- 2007.09.19: Is it dangerous to change the table owner in this way?
- 2007.09.18: Load sybase date type into Oracle -- sqlldr
- 2007.09.18: Compare and repair table structure between two schemas
- 2007.09.17: How AUL (MyDUL) recover truncated table's data easily?
- 2007.09.17: Set the different options value for AUL (MyDUL) utility
- 2007.09.17: Check your data files with DBVerify utility -- dbv
- 2007.09.17: sqlldr - Internal error: ulconnect: OCIInitialize [1804]
- 2007.09.17: Schedule DBA jobs on Windows with AT command
- 2007.09.16: The return (exit) code of ociuldr text unload utility
- 2007.09.16: The dump format recovery of AUL (MyDUL)
- 2007.09.15: High performance tuning for Oracle SQL Loader
- 2007.09.15: Step by step AUL/MyDUL data recovery example
- 2007.09.15: How to handle dead (corrupted) block in AUL (MyDUL)?
- 2007.09.15: The steps of register and apply AUL(MyDUL) license
- 2007.09.15: What to do before you choose AUL(MyDUL) as recovery solution
- 2007.09.14: Critical bug fix for asyncdata data migration script
- 2007.09.14: How Perl or asyncdata connect to different databases
- 2007.09.13: Features overview of AUL(MyDUL) data recovery utility
- 2007.09.13: How to upload OS files to LOB columns with Oracle SQL Loader
- 2007.09.12: Unload LOBs to OS files or upload OS files to LOBs in Oracle
- 2007.09.12: Generate SQL Loader control file when unloading with ociuldr
- 2007.09.12: Install ActivePerl, DBI, DBD on Windows for DBA tools
- 2007.09.11: High performance for Oracle text unload or export with ociuldr
- 2007.09.11: Implement materialized view log on MySQL for asyncdata
- 2007.09.11: Using trigger for asyncdata log table in Oracle database
- 2007.09.10: Tuning the performance of data replication with asyncdata
- 2007.09.10: Migrate data between different databases with asyncdata script
- 2007.09.09: Oracle SQL*Plus need learn from MySQL also.
- 2007.09.08: Using UltraEdit macro to format the HTML when bloging.
- 2007.09.07: Data compare tool needed, compare rows between tables.
- 2007.09.07: AUL(MyDUL), an oracle database recovery utility.
- 2007.09.07: How to unload or export rows as text file, excel CSV file, or excel xls file?
- 2007.09.07: Rsync2 brings me a extra bonus, how to?
- 2007.09.06: What's the role of dbatools.net?
Contact us: anysql©yahoo.com/anysql©126.com, MSN: loufangxin©msn.com, AIM: loufangxin