| Tunning the performance [message #64819] |
Fri, 13 February 2004 05:47  |
Mahesh
Messages: 90
Registered: January 2001
|
Member |
|
|
Hi Buddies,
I am learning Oracle Database Adminsitration, right now i want to know how the DBA will know this is the correct time for tunning the performance of the database.
|
|
|
|
| Re: Tunning the performance [message #64821 is a reply to message #64819] |
Sat, 14 February 2004 04:10  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
when its in design/development phase , when its in testing ..thats probably the best phase for performance tuning with the highest ROI( return on investment).
when the users start complaining about performance in load test/production !
when the actual throughput (for eg tps) doesnt come close to the expected throughput,in test/production phase.
Never get into 'compulsive tuning' as you can never stop! Also note that whenever there is a change(eg database upgrade , host upgrade , application change , data model change , business requirements change, total/concurrent usage change etc etc ) you are very likely to be called in to investigate something or the other related to performance.
-Thiru
|
|
|
|
| Re: Tunning the performance [message #64822 is a reply to message #64819] |
Sat, 14 February 2004 05:50 |
Michel Bartov
Messages: 35
Registered: February 2003
|
Member |
|
|
I just posted a new release of dbAdmin which is a comprehensive, easy to use, integrated set of tools that allow a novice as well as an experienced Oracle DBA, to manage, monitor, diagnosis and tune the Oracle database 8i as well as 9i. It is also an excellent DBA learning tool as it includes a wealth of functions from managing tables to comparing two schemas, from monitoring the library cache hit ratio to building your own KPIs, with the option the view all the SQLs executed behind the scene. I will appreciate any feedbacks to make it even better. The link is http://www.barsoft.net my email address is mbartov@barsoft.net
Michel.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
