This Oracle database script provides datafile fragmentation information based on Oracle’s FSFI (Free Space Fragmentation Index) measurements. Basically, the fragmentation of free space within all (read more…)
(read more…)
29
Sep
2010
Datafile FSFI Percent
27
Sep
2010
Disable Table Index Logging
This Oracle database script provides a means to disable the logging function on all of the index objects within a defined schema. The script is (read more…)
(read more…)
27
Sep
2010
Hyperdock for Mac
Hyperdock is currently a beta application designed for Mac OS X 10.6 (and up) that I found on LifeHacker. It demonstrates the same concept of (read more…)
(read more…)
27
Sep
2010
Table DML Percent Statistics
This Oracle database maintenance script provides table statistical information for tables that have more than 10 percent of DML (Data Manipulation Language) performed. The information (read more…)
(read more…)
27
Sep
2010
Index Validate/Rebuild Script
This Oracle database maintenance script has been designed to improve system and database performance by determining which indexes have become candidates for rebuilding. The targeted (read more…)
(read more…)
26
Sep
2010
Evernote
Evernote is an application that I primarily use on my iPhone, and on a daily basis. I is brilliant at syncing my iPhone’s notes-on-the-go with (read more…)
(read more…)
25
Sep
2010
cume_dist {analytic function}
The Oracle SQL aggregate and analytic function CUME_DIST calculates the cumulative distribution of a value in a group of values. The range of values returned (read more…)
(read more…)
