Call (800) 766-1884 for Oracle support & training
Free Oracle Tips

Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance

Free Oracle Tips



BC Oracle tuning

Oracle training

Oracle support

Remote Oracle



  Oracle Tips by Burleson

Monitoring Database Initialization Parameters

The database initialization parameters are critical parts of the database. I have seen many installations where administrators were very diligent about database backups but neglected to document the settings of their initialization parameters. At some installations DBAs—or should I say DBBSs (database babysitters)—didn’t even know the location of the init<SID>.ora file.    

The documentation of the parameters has been covered in earlier sections; with the advent of Oracle, the v$parameter file provides the source for discovering the value and status of any documented initialization file parameter in effect for the current session (previously it was for the instance.) Oracle also added the V$PARAMETER2, V$SYSTEM_PARAMETER, and V$SYSTEM_PARAMETER2 views. The V$SYSTEM_PARAMETERS view shows the instancewide parameter values. The V$PARAMETER2 and V$SYSTEM_PARAMETER2 views show the same parameters as their nonnumbered counterparts, except that any multivalues string (such as CONTROL_FILE or ROLLBACK_SEGMENT) will have an individual listing for each value of the string, differentiated by an ORDINAL column to tell you the order that the substring occurred within the master string. A simple script to generate a nearly ready-for-prime-time init<SID>.ora file is listed in Source 11.34. Of course, with Oracle, you can use the CREATE PFILE command if you have a current SPFILE to generate a parameter file listing.

See Code Depot


Oracle performance tuning software 

Oracle performance tuning book


Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel
Oracle training & performance tuning books



Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.