Oracle DBA tool collection

Oracle Database recovery

Aul, also known as mydul, and Oracle DUl, can directly read data from Oracle data files from Oracle software. if you cannot start your Oracle Data normally and there is no valid backup available for recovery, for example, the system tablespace is lost, the table is accidentally deleted or truncate, or the data file has severe bad blocks. you can choose aul (feature overview) as the final restoration method. Compared with the Restoration Service provided by Oracle,Relatively low cost. Aul has recovered more than 3 TB of data for more than 30 customers around the world.

You can download the AUL software, perform a detailed test with a free license based on the usage examples on the website, and then purchase a formal license. you can easily restore a table in the truncate or a database that loses the system tablespace. in terms of processing clob and national language data, AUL is stronger than Oracle DUl. if you have a database that is not backed up, you should pay attention to AUL. compared with restoration services provided by Oracle and other companies, AUL has a very high response time and recovery speed.

If you have questions about ORACLE data recovery, add my MSN (anysql@Live.com) or QQ (37223884) for real-time communication.

Graphical report software

Anysql datareport allows you to easily display data in table formats and various types of charts (pie chart, line chart, bar chart, and area chart ), you can export data to an Excel 2003 file for richer data analysis and presentation. you only need to find an application server, download and install it, and configure the database connection. You can perform data analysis to a certain extent without installing any database client software. the JDBC-based database access layer enables it to connect to a variety of different databases, such as Oracle and MySQL. it has been successfully applied in the business monitoring system. for important business data presentation, anysql datareport has a strong security mechanism to fine-tune access permission control on each page. For all password configurations, you must enter the encrypted password. you can also easily create navigation links between different pages.

Anysql datareport is a free tool. personal and commercial applications are not charged, but the technical support of commercial applications is charged.

Oracle data migration

Text files are an important way of data exchange, but Oracle does not provide tools for exporting data to file files. We must writeProgramOciuldr is a tool written with an efficient OCI interface. it is free to use (download) and open-source (download source code). It can be compiled into executable files on various platforms. multiple command line options provide a wide range of functions, such as optimizing the export speed and automatically generating sqlldr control files for data loading or migration. by judging the program exit code, you can easily integrate and use it in shell or Perl scripts.

Sqluldr is an upgraded version of ociuldr. Through Effective Io optimization, the speed is improved by about 50% and some Enterprise Edition features are added. you can download the executable files on the windows, Linux, and Aix platforms. The usage is basically the same as that of ociuldr, And it is compatible with all the command line options and functions of ociuldr.

Download more detailed instructions to use!

Performance monitoring software

When performance optimization is required, you often don't know how to tune it. The reason is that you don't know where performance problems occur, so you need to use effective performance tools. oramon is a very effective performance data collection tool. It extracts effective performance data from the basic performance view (such as V $ sysstat and V $ session) for horizontal vertical joint comparison and analysis, such as logical reads, physical reads, and number of active sessions at different time points, you can easily locate database performance problems. with the effective combination of datareport, you can build a complete set of performance monitoring pages.

If you have no questions about the performance, do not prevent free downloads and free use, you can provide a certain degreeFree Performance AnalysisService, you only need to pass the performance data collected by oramon to me for analysis.

Other tools

Anysql is a database client interaction tool written in Java. It can execute common SQL or DML statements and has some customizable functions, it integrates many common SQL statements and some special functions for processing long, lob, and other data types.

 

Source: http://www.anysql.net/product