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

Thread: Init.ora parameters

  1. #1
    Join Date
    Feb 2001
    Posts
    114
    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 ??

    thanks

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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.

    Sam

    Thanx
    Sam



    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