Hi,
I am in a process of automating DBA work. I want to capture all active users on a database by unix script but doesn't work properly if the number of concurrent users is more than 22.
Here is what I did, I create a file called "keystroke" which contain
1
1
q
q
The I create a script getid.ksh the contain this;
promon dbname < keystroke > user.list
The database have more than 100 users but if you vi the user.list
it captured only 22 users the rest are missed because you need to hit RETURN to get the rest of the list. Any help will be much appreciated.
I am in a process of automating DBA work. I want to capture all active users on a database by unix script but doesn't work properly if the number of concurrent users is more than 22.
Here is what I did, I create a file called "keystroke" which contain
1
1
q
q
The I create a script getid.ksh the contain this;
promon dbname < keystroke > user.list
The database have more than 100 users but if you vi the user.list
it captured only 22 users the rest are missed because you need to hit RETURN to get the rest of the list. Any help will be much appreciated.