[ 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.

Oracle Database Scripts

External Tables (Oracle 9i+ feature):

The Script:

-- Create the Directory and grants
create directory mydir as '/export/home/external' ;
grant read on directory
grant read on directory mydir to ;
grant write on directory mydir to user with directory>;

-- Create the table
create table {user}.{table name}
(c1 number,
c2 number,
c3 number)
organization external
(type oracle_loader default directory mydir
access parameters (records delimited by newline
badfile 'datafile_bad.log' nologfile fields terminated by ',')
location ('datafile.dat'));

Donate 5$

If you found this information useful, don't be cheap, donate 5 dollars (with PayPal):