Showing posts from October, 2010

OpenSourse - Free Databases for Linux Operating System

Oracle's MySQL

Oracle's MySQL is one of the most popular GPL'ed databases for the GNU/Linux and BSD platforms. MySQL database is popular because of fast performance, high reliability, ease of use, and dramatic cost savings.

SQLite Embeddable SQL Database Engine is a C library that implements a self contained, serverless, zero configuration, transactional SQL database engine. This allows application programmers to embed an SQL server directly into their application. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain. The latest version of SQLite is 3.7.3 and it is recommended for all new development.

Mckoi SQL

Mckoi SQL Database is an Open Source SQL Database System written in Java. Supports transactions, referential integrity, triggers, indexes, Java specific enhancements. Supports multi-threaded, multi-client operation; embedable. Released under the GPL license. This is probably the most advanced open…

Best Tools for Oracle Database Administrators

TOAD for Oracle

Tool for Oracle Application Developers, a very popular tool with a large user base. Includes SQL Editor, Schema Browser, Procedure Editor, SQL Modeler.

Knowledge Base for Oracle Administration

A must have online reference/companion for any Oracle DBA. Saves time searching books for syntax, troubleshooting and research. Great error message guide for developers, plus a comprehensive study guide for Oracle7, 8, & 8i OCP exams with test questions.

SmartDBA Cockpit

SmartDBA Cockpit (previously known as WebDBA) helps you manage your Oracle databases from the convenience of your Web Browser. It allows you to interactively access and administer your databases remotely, and has almost all the features for the day to day working of DBAs.


KeepTool's tools are a suite of user-friendly, well-architected, resource-frugal components designed to fit your enterprise's Oracle-centric roles, be they modellers, architects, developers, DBAs or even data operators.
DB Tool…

Best Tools for Oracle Developers

TOAD for Oracle

TOAD Tool for Oracle Application Developers is a very popular tool. This tool Includes SQL Editor, Schema Browser, Procedure Editor, SQL Modeler. Quest Software product TOAD increases user productivity and improves application code quality. TOAD for Oracle available current version is v10.6.

SQL Insight

SQL Insight is a tool is used to speed, improve, and simplify application and database development. SQL Insight editors support various file types, SQL, PL/SQL, Java, HTML, XML, C++, and Perl. Latest version is SQL Insight 3.
PL/SQL Developer

PL/SQL Developer is an Integrated Development Environment that is specifically targeted at the development of stored program units for Oracle Databases. Over time we have seen more and more business logic and application logic move into the Oracle Server, so that PL/SQL programming has become a significant part of the total development process. PL/SQL Developer focuses on ease of use, code quality and productivity, key advantages duri…

linux scripting rocks with baby

Useful Linux System Log Management Commands

who command who命令查询utmp文件并报告当前登录的每个用户。 who ordered the report query utmp file and each user currently logged on. Who的缺省输出包括用户名、终端类型、登录日期及远程主机。 Who's the default output, including user name, terminal type, login date and the remote host. 使用该命令,系统管理员可以查看当前系统存在哪些不法用户,从而对其进行审计和处理。 Use this command, the system administrator can view the current system, what are the unscrupulous users to its audit and processing. 例如:运行who命令显示如下所示: For example: Run the who command displays as follows:

If specified in the wtmp file name, who commands all previous records check. Command who / var / log / wtmp wtmp file was created since the report has been altered or every login. For example: run the command as follows:

users command users print out a single line with the current logged on user, the user name corresponds to each display a login session. If a user has more than one login session, and that his name will show the same number of users. Run the command as follows:

last command wtmp last command t…