The 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 CommentExpert Oracle Posts
Below 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 CommentQ: What is RMAN and why is it used in Oracle databases? Answer: RMAN (Recovery Manager) is a utility in Oracle databases that provides a…
Leave a CommentThe below script can be used to find SQL details from AWR. set lines 155 col execs for 999,999,999 col avg_etime for 999,999.999 col avg_lio…
Leave a CommentThe below script can be used to run SQL tuning advisor manually. CREATE TUNING TASK DECLARE l_sql_tune_task_id VARCHAR2(100); BEGIN l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task ( sql_id =>…
Leave a CommentMongoDB is a popular, open-source NoSQL database that is known for its scalability and high performance. It uses a document-oriented data model, which means that…
Leave a CommentHere are a few scripts that can be used to compile invalid objects in an Oracle database: Note: Please make sure that you have the…
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 CommentQ: What is Oracle ASM and what are its benefits compared to traditional file systems? Ans: Oracle ASM is a volume manager and file system…
Leave a Comment