Sometimes users are end-dated but the responsibilities assigned to specific users are not end-dated. Below SQL code can be used to identify all such users…
Leave a CommentCategory: SCRIPTS
Below are some of the useful Oracle EBS queries related to users and responsibilities. LIST OF ACTIVE USERS select user_id,user_name,description,email_address,start_date,end_date from fnd_user where (end_date is…
Leave a CommentThe below script can be used to find the count of users linked to each EBS application. You can also filter and get information for…
Leave a CommentBelow scripts can be utilized to find the number and details of EBS users that were on the system in the last 1 hour. The…
Leave a CommentValue of specific profile option at all level select b.user_profile_option_name “Long Name” , a.profile_option_name “Short Name” , decode(to_char(c.level_id),’10001′,’Site’ ,’10002′,’Application’ ,’10003′,’Responsibility’ ,’10004′,’User’ ,’Unknown’) “Level” , decode(to_char(c.level_id),’10001′,’Site’…
Leave a CommentThe “library cache pin” wait event in an Oracle database occurs when a session is waiting to acquire a shared lock on an object in…
Leave a CommentBelow script can be used to get details of running concurrent requests in your Oracle EBS environment. It gives all useful details from V$SESISON too.
1 Comment Usually we monitor the EXPDP/IMPDP jobs by monitoring the log files generated by expdp/impdp process. Also we monitor alert log too just in case some error pops up. This helps most of the time. If you have a long running expdp/impdp sessions as you are exporting/importing huge GBs then it helps to have a more detailed monitoring of the expdp/impdp jobs. Some of the useful queries which can be used to monitor the Data Pump Jobs are mentioned below.
To start with some of the important tables/views that you should refer to monitor Data Pump Jobs are:
2 CommentsBelow are some of the GoldenGate commands that we use frequently. We work on GoldenGate 12c version but almost all commands work in same manner…
2 CommentsFor Apps DBA sometimes it is necessary to decrypt the EBS Application user’s password. Below package can be used to decrypt the FND_USER password. You will need password of “apps” database userid to be able to decrypt the application user’s password.
5 Comments