database tools, oracle, sql server, db2, monitor, monitoring, performance
home
who are we
products
database product monitor
database product reorg
database product capacity planning
external alerting device
customers
partners
links
competition us and them
oracle dba scripts
contact us
our mail list
[ Jan, 2008 ]
B.G.S Software products are becoming popular in china. (See Brochure)

[ Jan, 2008 ]
We have a BLOG for feedbacks and information sharing. (Visit our blog)

[ Oct, 2006 ]
Capacity Planning Package for Oracle Database is now included in the monitor!. More...

[ Jul, 2006 ]
Build a package of the monitor especially to monitor your application and database. Provide a monitoring tool 'built in' in your product. More...

[ Jul, 2006 ]
New object called "History Keeper" was added to the monitor. This object allows saving history of the monitor into a repository in the database.
It's possible to define the frequency of saving a sample, and the number of days to keep in the repository.

[ Jun, 2006 ]
New electronic equipment called "External alerting device" (made by B.G.S.) was added to the monitor.
The device connects to the PC's parallel port and can activate a siren & light alert (wired or wireless). It's possible to define thresholds and statuses to activate the alert.

DBA Scripts for Oracle Database


Oracle DBA needs to perform operations that are more complex than one single SQL command.
DBA's write SQL scripts as part of the routine work.
This is a collection of DBA Scripts.
If you have scripts that you wrote or know that are useful, we'll appreciate it if you can send them to us and we'll put them on this page and Credit you for it.


Change Database Character-set and National Character-set

Author: Boaz Laufer
Script: Click here


Move segments from one Tablespace to another

Author: Boaz Laufer
Script: Click here


Rebuild all unusable indexes (and partitioned indexes)

Author: Boaz Laufer
Script: Click here


Kill all sessions of a specified user name

Author: Boaz Laufer
Script: Click here


Using List Partitions (Supported in Oracle 9i and above) - Note:149116.1 in Metalink

Author: Boaz Laufer
Script: Click here


External Tables (Oracle 9i+ feature)

Author: Boaz Laufer
Script: Click here


Syntax of 'If - Then - Else' in Oracle

Author: Boaz Laufer
Script: Click here


Flip a table on the side (SQL Trick)

Author: Boaz Laufer
Script: Click here


Coalesce all tablespaces

Author: Boaz Laufer
Script: Click here


Compare Table structure between two users

Author: Boaz Laufer
Script: Click here


Convert Unix timestamp format to Oracle Date

Author: Boaz Laufer
Script: Click here


Find Redundant Indexes

Author: Unknown
Script: Click here