Just found a file sharing service named file.io, and then decide to upload some of my tools to anysql folder for sharing. You can download AnySQL utility (Search ...) here. anysql-jre.zip, AnySQL with JRE for Windows,...
When I start to learn MySQL database, I feel Oracle SQL*Plus should learn from MySQL to display the result as form style. It's not implemented in Oracle 11g's SQL*Plus, but you are still lucky because I implement it...
When describe a talbe to get the structure information, I also hope to display the indexes information. In AnySQL, I wrote the DESCRIBE command with this feature. It really save me a lot of time to write SQLs...
You can get the table and it's indexes' or lob segments' size by "ORA SIZE" command easily. ASQL> ora size sh.t_lobtest OWNER SEGMENT_NAME SEGMENT_TYPE SIZE_MB INIEXT MAXEXT ----- ------------------------- ------------ ------- ------ ------ SH T_LOBTEST TABLE 0.0625 65536 SH SYS_IL0000012006C00001$$ LOBINDEX 0.0625 65536 SH SYS_LOB0000012006C00002$$ LOBSEGMENT 0.0625 65536...
A lot of DBAs are extracting DDL (table create) script with Toad and PL/SQL Developer utilities. But a lot of database are running on Linux or Unix hosts, and connections directly from desktop are not allowed, then it...
As an Oracle DBA, I feel no good command line tools when facing SQL Server or Sybase database, not comfirtable with osql or sqlcmd because too much differences with SQL*Plus. AnySQL is Java & JDBC based, it can...
I took few hours to make some changes to rsync's source code, to fit for copy contents in raw devices to remote host's raw devices. I am an Oracle DBA, and some of our databases are using raw...
WebChart is a Java servlet based platform for simple business data display in tabular or chart mode, it was initially wroted in 2003, but I improved it these days. And I created database performance management pages on it...
I will show you how WebChart works, take a look at the following picture furst, it's WebChart's techniqual framework. WebChart is a three-tier applications, you can view data in HTML or XML or PDF format with...
After introduce of the WebChart features and the the WebChart framwork, somebody told me that they need to test WebChart, but don't know how to install it after download. After reading this article, you should know how to...
