Oracle Point, Oracle Life.

In versions before Oracle 10g, statspack is useful utility to monitor database performance and workload issues. I just came across a shell script which can automate snapshot report create and mail to DBA.

The script is re-posted as below without change.

[oracle@www1 sql]$ more backup/auto_send_perf.sh
#!/bin/sh
. ~oracle/.bash_profile

/home/oracle/product/9.2.0/bin/sqlplus -s aaa/bbb@ccc<<!
set head off
set timing off
spool /home/oracle/sql/backup/snap_begin.lst
select min(snap_id) snap_id
from stats$snapshot
where snap_time between trunc(sysdate) and trunc(sysdate)+1;
spool off
spool /home/oracle/sql/backup/snap_end.lst
select max(snap_id) snap_id
from stats$snapshot
where snap_time between trunc(sysdate) and trunc(sysdate)+1;
spool off
exit
!

BEGIN_SNAP=`cat /home/oracle/sql/backup/snap_begin.lst | tail -n 2`
END_SNAP=`cat /home/oracle/sql/backup/snap_end.lst | tail -n 2`
#END_SNAP=`expr $BEGIN_SNAP + 13`
REPORT_NAME=/home/oracle/sql/report/sp`date +%m%d`_ac

/home/oracle/product/9.2.0/bin/sqlplus -s aaa/bbb@ccc<<!
define begin_snap=$BEGIN_SNAP
define end_snap=$END_SNAP
define report_name=$REPORT_NAME
@?/rdbms/admin/spreport
exit
!

mail -s “perfstat report” ddd@eee.fff < /home/oracle/sql/report/sp`date +%m%d`_ac.lst

[oracle@www1 sql]$crontab -l
* 21 * * * /home/oracle/sql/backup/auto_send_perf.sh >> /home/oracle/sql/backup/perf.lst 2>&1

Note: The snapshot report is created from 8:00 AM to 8:00 PM daily and the job of crontab is called at 9:00 AM.

Popularity: 23% [?]

DbForge studio for MYSQL is a powerful “mobile application development tool” for working with MYSQL. It is a standalone application that runs with .NET framework 1.1 or 2.0 dbForge studio for MYSQL supports all features of MYSQL versions 3.2.3 and higher. This software development tool presents a powerful visual interface for developing scripts, executing queries, managing users and more. Among other popular tools dbForge studio for MYSQL is very trusted “software development company tool in South Africa”.

On the other hand dbForge Fusion for MYSQL is a powerful add-in designed to simplify the MySQL database application development process. It combines with Delphi, making all database development and administration tasks available from your favorite IDE. It provides an easier way to explore and maintain existing databases, design compound SQL statements, query and control data in different ways.

The latest release of dbForge version 3.0 is a version that includes a collection of essential features to simplify database development tasks, save time and present new opportunities for professional work with MYSQL databases.

So, before using dbForge studio for MYSQL you must know some of the important features of this tool.

* Integrated Database Project Development:

Enhance your work with complex database projects. Save your time as you can integrate various SQL and script files into a project, group them into folders, and manage in one place.

* Stored Routine Debugger:

Debug stored procedures, functions, and triggers with no worry as you can easily set breakpoints to stop execution on any code line and evaluate variables and parameters declared in routines.

* Powerful SQL management:

Free yourself from boring work while coding with well-thought features. Speed up your development with code templates, code completion, syntax check, code formatter, and many other options.

* Visual Query Builder:

Create effortlessly complex queries which you could not create before. Do not think about coding, just use query builder, select parameters, set conditions in a convenient editor, and then view and edit a query text.

* Convenient Schema Object Editors:

Get clear and automated ways to work with tables, views, procedures, functions, triggers, events, and user-defined functions (UDF).

With all these key features and more, this software development tool is a cutting-edge development environment for professional working with MYSQL databases.

Popularity: 50% [?]