DBA Tools |
|
Writing professional DBA tools and scripts for better DBA life |
|
Archives
- 2011.04.20: Oracle ASM Data Recovery Test of AUL for Oracle ASM Utility.
- 2011.04.20: Change of the AUL license mode on Linux platform.
- 2011.04.15: AUL for Oracle ASM, Oracle ASM Data Recovery Utility.
- 2011.04.10: Trigger based data replication utility from Oracle to MySQL database
- 2011.04.08: Migrate Oracle data to MySQL database with ora2mysql utility
- 2010.05.13: Windows GUI version of SQLULDR2 and DataCopy released.
- 2010.04.30: SQLULDR2 : Native Parallel Support! Parallel Inside!
- 2010.04.19: SQLULDR2 Windows Developer SDK Released.
- 2010.04.17: DataCopy : Native Parallel Support Now ! Parallel Inside !
- 2010.04.15: Parallel execution of SQLULDR2 or DataCopy for huge tables
- 2010.04.14: Data Migration between different Oracle character set
- 2010.03.25: DataSync: Data Replication (SCOTT.EMP) between Oracle databases
- 2010.03.17: DataCopy : Oracle data migration utility, faster than exp/imp
- 2010.03.04: Define the row filters for reports in WebChart
- 2010.03.03: Define different SQLs for different databases in WebChart
- 2010.01.27: The logical database layer and physical database layer
- 2010.01.27: Fixed AUL license is available now for you
- 2009.10.29: Migrate data from Oracle to MySQL with SQLULDR2
- 2009.06.11: Protect the database connection information in SQLULDR2
- 2009.06.10: Copy data between different databases with copydata script
- 2009.06.05: Change the WebChart XSL template to show nagivation links
- 2009.06.05: SQLULDR2 Bug: ORA-24345 error possible
- 2009.06.03: How to change SQLULDR2 session level's parameters?
- 2009.06.02: Create the HREF links in WebChart Pages
- 2009.05.26: Get more than expected from oramon performance alert.
- 2009.05.23: Send oracle performance alert based on oramon performance data
- 2009.05.21: Deploy the new oramon version to production database hosts.
- 2009.05.10: How to Anayze Oracle Performance Data, Lession Two
- 2009.05.09: How to Anayze Oracle Performance Data, Lession one
- 2009.05.06: PayPal charge too much for payment, welcome to AliPay.
- 2009.05.05: SQLULDR2, upgrade of ociuldr, free of charge now.
- 2009.04.29: Save the customer's data, resue the world.
- 2009.04.26: Click "Ask Me" to post a question to me now
- 2009.04.22: Demo of oramon and WebChart performance solution
- 2009.04.22: Specify multiple lines value in WebChart defination
- 2009.04.17: SQLULDR2 can compress the output file in GZIP format
- 2009.04.17: Load oramon performance data into database for further analyze
- 2009.04.16: Install and start oramon to gather performance data
- 2009.04.16: Gather and keep Oracle performance data with oramon
- 2009.04.10: Performance test of Oracle datapump, exp and SQLULDR2.
- 2009.04.06: A light way Oracle performance tracking solution
- 2009.04.02: License required for full SQLULDR2 (Oracle Text Unload) version.
- 2009.04.01: SQLULDR2, how to unload data to screen (STDOUT)?
- 2009.04.01: Specify table name for SQLULDR2 (SQL*Unloader) text unloading
- 2009.04.01: Customize all the chart colors of WebChart utility
- 2009.03.29: Two samples of SQL*Loader (sqlldr) control files.
- 2009.03.29: sqluldr2 (OCI 8 based) is comming with one megabyte LOB support
- 2009.03.25: The parfile option of newer text unload utility (sqluldr)
- 2009.03.24: sqluldr, enterprise edition text unloading utility
- 2009.03.23: Text Export and Import Performance Testing
- 2009.03.21: WebChart Sample Pages on MySQL Database
- 2009.03.19: 25%+ performance improve for text unloading with ociuldr
- 2009.03.12: WebChart Advanced Security - Password Encrypt
- 2009.03.12: The simple online editor of WebChart
- 2009.03.10: Improved crosstab feature and formula columns in WebChart
- 2009.02.26: WebChart, what's in the WCML files.
- 2009.02.19: WebChart is running in alibaba now ......
- 2009.02.17: WebChart Advanced Security Overview
- 2009.02.17: Export data to fixed length text file with ociuldr
- 2009.02.13: WebChart Input & Output Maps
- 2009.02.13: WebChart Marker Language , the wcml files
- 2009.02.07: WebChart Demos - Business Charts (Pie Chart, Bar Chart and Line Chart)
- 2009.02.06: WebChart Demos - Tabular data display
- 2009.02.06: WebChart database connection configuration
- 2009.01.15: Export data to Microsoft Office Excel file with WebChart
- 2009.01.14: WebChart Installation on Windows or Linux/Unix?
- 2009.01.13: WebChart Techniqual Framework
- 2009.01.12: WebChart Features Overview, create your business charts on web pages
- 2008.11.26: How to keep given gigabytes of archive log files with Perl
- 2008.11.26: Find archive log file by given sequence with perl
- 2008.10.17: rawsync, rsync for database on raw devices
- 2008.10.04: AUL/MyDUL vs. Oracle DUL, which is better?
- 2008.07.16: Save 15 mins downtime by tuning the sequence.
- 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