Create .run_awr with following details :
"TNS-connect-string : recipient-list : hrs of AWR snapshot"
[oracle@ ~]$ cat .run_awr
prod:root@oracledbasupport.co.uk:11
I added this script in my crontab for a daily emails:
Read more…
Comparing Files is one of very common task as a DBA, System Administrator. There are tonnes of Oracle,Websphere,linux configuration files. Often I have to compare one server to another and locate changes between environments.
Read more…
Imagine you have to drop an Oracle user and create it with all privs/roles again. This often happens in test cycle of 3rd party products. The privs are sent to user on ad hoc basis to get around the installation errors and then comes requirement to replicate it on another server. How do you do it? Attached script will create a spool file for user granted roles, object Privileges
Read more…
T-SQL script to add a server load . I have used this script to test backup timings, replication latency. One run of following procedure incerased log fie to 8GB and datafile to 6GB Read more…
Following script will only work if your servers were enabled with password less login ( How to for linux /HP UNIX)
Read more…