Init.ora parameters Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Init.ora parameters

  1. #1
    Join Date
    Feb 2001
    hi all,

    As a DBA what are the parameters in the init.ora which we should keep in track on a day to day basis ??


  2. #2
    Join Date
    Oct 2000
    Saskatoon, SK, Canada
    The basic paramters that you might want to keep track of are the shared_pool, db_buffers, large_pool and MTS_*. But most of the parameters are static in nature as a result any changes would require bouncing of the instances. But as a DBA you should configure these parameter and make sure that they are sufficient enough for the instance's long run.

    If your application is being coded poorly and then if you try to satisfy the application through these parameters, would no way help. On such cases, you would first want to tune the application, before tuning the instance.



    Life is a journey, not a destination!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width