[ 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

Kill all sessions of a specified user name:

The Script:

declare
   ora_user varchar2(30) default 'SCOTT'; --Oracle Username to kill all sessions for
begin
   execute immediate 'alter user '||ora_user||' account lock';
   for crs in (select sid,serial# from v$session where username = ora_user) loop
      execute immediate 'alter system kill session '''||crs.sid||','||crs.serial#||'''';
   end loop;
end;
/

Donate 5$

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