Value 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 CommentExpert Oracle Posts
Q: 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 CommentBelow is some basic information on how database level parameters are managed between CD and PDB databases in Oracle multitenant architecture: Changing parameters for CDB…
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 CommentConverting a database SID from uppercase to lowercase in the Oracle database can be needed sometimes. Below are general steps for converting a database SID…
Leave a Comment