I was trying to execute following SQL through client side tools and found network delays were contributing to the SQl execution times. This SQL normally returns in less than 50 millisec and now taking more than 700 Msec. I am addicted to TOAD -TORA GUI created Execution plans and was looking for a an easy way to get execution times as well as plans on sqlplus. Here is how you do it .
Read more…
For last many years I worked for number of clients using all sort of latest technologies. One of my duties was tuning and monitoring system performance which formed part of Capacity planning. I have been using number of tools and when I saw 10G grid first time I could see a real way forward where a database technology could work towards client needs to deliver end result.
Read more…
Advantages of using grid control to schedule jobs
- Could be run against multiple targets at any given time
- Run a job immediately or repeatedly on a schedule
- Could be submitted against number of targets
- Could be shared using job library
Read more…
Click on Database Tab at grid Control

Read more…
Background : I have installed OMS/OMR and OMA successfully. In theory I should see OMA client successfully configured at OMS grid console but
Read more…
Download OMS software from here
Read more…