Who we are DBA & Unix Services Scripts & ConfigFiles Tutorials Express Services Oracle Downloads Contact Us DATABASE SCRIPTS The following scripts may be useful to the Oracle DBA in maintaining his/her database. While each script has been tested and deemed working, keep in mind that if you decide to use any of the below SQL routines, you are using them at your own risk. Pinning Objects into the Shared Pool Measuring CPU usage per session Oracle "Cold Backup" Script (UNIX) Oracle "Hot Backup" Script (UNIX) Monitoring the Oracle SGA Sending Email from the Database DATABASE Configuration Files The following are some sample oracle *.ora files which also may be useful they primarily deal with interfacing Oracle with SQL*NET & other clients. Sample tnsnames.ora file Sample listener.ora file (single listener) Sample listener.ora file (multiple listeners) Sample sqlnet.ora file Sample names.ora file (required on Oracle Names Server) Useful Banner® Tricks The following section contains useful Banner® tricks. Removing Duplicate Rows from GOREMAL Changing table owner passwords Script to remove all ^M characters from files ftp-ed over from DOS to Unix Systems Using Batch Files to Setup Multiple Banner® Environments Useful Oracle Tricks The following section contains useful Oracle "Tricks" which the DBA/SYSAdmin may enjoy. Running import with files greater than 2GB on Solaris Oracle Kernel Parameters for Solaris Importing from an Oracle 8 Database to Oracle 7 Finding Duplicate Columns
The contents of www.nyquest.com are Copyright © 2007 by Nyquest Consulting. Sungard® and Banner® are registered trademarks of Sungard® Corporation. Nyquest is not affiliated in any way with Sungard®. All Rights Reserved.