Home » RDBMS Server » Performance Tuning » Script needed ---- URGENT Please HELP
icon4.gif  Script needed ---- URGENT Please HELP [message #117519] Wed, 27 April 2005 14:08
goodfrnd
Messages: 6
Registered: May 2004
Junior Member
Hi,
Iam asked to write a script which deals with the below stated problem

1 . The Script has to check for sessions or transactions into the database and the Query executed by it.
2. The Script needs to check the status of the transaction or session.
3. The script needs to check for the session or the Transaction which is in the database for more than 15 Sec of time if more than 15 Sec page the DBA and also check if it is holding any locks in the database and the type of lock.
4 . The script if its a generic one would be more helpful.

Thus the Script needs to log the Status of a Session or Transaction,Query exected by it,Locks (if any) held in the database ,check the time of execution if more than 15 Sec page the DBA immediately.

I want to Schedule the above script running for every 5 mins for one hour thus the log generated by this script should be appeneded with the current time so that I can veiw all the logs for one Hour of time.

The OS used is : SUN Solaris
Database : oracle 8.1.7.4

Please Help me in putting up this script.

Thanks in advance,
GoodFrnd
Previous Topic: How much SGA..?
Next Topic: Rollback segment error in production HELP
Goto Forum:
  


Current Time: Sun Dec 22 23:30:22 CST 2024