| Connectivity Log File | Location |
| prereq<time_stamp>.log | $OMS_HOME/sysman/prov/agentpush/<time-stamp>/prereqs/local |
| prereq<time_stamp>.out | $OMS_HOME/sysman/prov/agentpush/<time-stamp>/prereqs/local |
| prereq<time_stamp>.err | $OMS_HOME/sysman/prov/agentpush/<time-stamp>/prereqs/local |
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 .
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.
Advantages of using grid control to schedule jobs
Background : I have installed OMS/OMR and OMA successfully. In theory I should see OMA client successfully configured at OMS grid console but
Download OMS software from here
Tweet
