In Oracle Database, an invisible index is a type of index that is not used by the optimizer by default but can still be used…
Leave a CommentCategory: SCRIPTS
To fetch the DDL of a table: SELECT DBMS_METADATA.GET_DDL(‘TABLE’, ‘table_name’) FROM DUAL; To fetch the DDL of a view: SELECT DBMS_METADATA.GET_DDL(‘VIEW’, ‘view_name’) FROM DUAL; To…
2 CommentsThe parallel hint in Oracle Database is used to specify that a particular query or operation should be executed in parallel mode, using multiple parallel…
2 CommentsThe below script can be utilized to find if any UNIX process has a database session linked to it and if yes, provide all the…
Leave a CommentHere are a few scripts that can help you find the number of executions of a specific SQL_ID in an Oracle database: Scripts based on…
Leave a CommentBelow script to find a list of all uses who are online in Oracle EBS. COUNT OF USERS SELECT DISTINCT count (*) FROM icx_sessions icx,…
Leave a CommentFind responsibilities that can run the specific concurrent program SELECT fcp.concurrent_program_name, fr.responsibility_name, frg.request_group_name, fcp.user_concurrent_program_name FROM fnd_request_group_units frgup, fnd_concurrent_programs_vl fcp, fnd_request_groups frg, fnd_responsibility_vl fr WHERE 1…
Leave a CommentThe below scripts can be used for responsibility, menu, submenu, and function details of specific responsibilities. 1. Retrieve a list of all responsibilities. Parameters: None…
1 CommentScript to find all active responsibilities linked to an EBS user. SELECT UNIQUE fu.user_id, fu.user_name user_name, fr.responsibility_key responsibility, fa.application_name application FROM fnd_user fu, fnd_user_resp_groups fg,…
Leave a CommentSometimes 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 Comment