oracle support at low prices oracle dba outsourcing oracle database tuning oracle price list
  
free resources from Pro-DBA.com Related links: Need Emergency Help? Low cost 24x7 DBA resource available | 25% discount on Oracle license prices | Oracle support package for £770 a month

oracle dba scripts
We have literally hundreds of Oracle DBA scripts to perform many different tasks on your databases. Below is just a small selection.
Please note that each of the SQL-based scripts have been designed to run in SQL*Plus, and each of the shell scripts have been designed to run in the korn shell.
Script Description
hotbackup.sh Korn shell script to perform a hot backup (online backup)
backups.sql SQL to show online backup status of database files
free.sql SQL to graphically show tablespace usage
jobs.sql SQL to show status of scheduled jobs
seswait.sql SQL to show waiting sessions
cursta.sql SQL to show currently active sessions + statements
checkfilesystem.sh Korn shell script to alert DBA of filling up filesystems
fullexport.sh Korn shell script to perform full database export
verifydb.sh Korn shell script to verify database files
toobig.sql SQL to list segments that cannot extend
explain.sql SQL to show explain plan without running statement
hackuser.sql SQL to hack into account without knowing password
sqlpluscondition.sql SQL example of conditional logic in SQL*Plus
Top of page
 

Copyright Pro-DBA.com 1999-2010, all rights reserved. 11 Greenwich Quay, Clarence Road, London, SE8 3EY.