Oracle Apps DBA Monitoring SQL Queries
Being an Oracle Apps DBA, We need to act immediately on the Production issues . we have to analyze and resolve the issues promptly.
Below are the SQL Queries/Scripts which I have Consolidated to analyze the issues.
Click on Links below to View and Download the SQL Queries accordingly Oracle Database Monitoring SQL Queries:
- Query To Monitor Database Session Waits
- Query To Monitor Database Locks
- Query To Check library cache pin Events/Locks
- Query To Monitor Longops Sessions
- Query To Check Database Tablespace Usage With Percentage
- Query To Monitor High Temporary Tablespace Usage Sessions
- Query To find which transactions/sessions consuming the UNDO tablespace
- Query To Monitor Temporary Tablespace Usage
- Query To Get Count and List of Invalid Objects
- SQL Script To Lookup Database Details for a given sid
- SQL Script To Lookup Database Details for a given spid
Oracle Standby Database Monitoring SQL Queries:
Miscellaneous Database SQL Queries:
- Query To Check Database Status and Properties
- Query To Check Oracle Database Size
- Query To Get List Of Tablespaces Exist in an Oracle Database
- Query To Get Datafile Details for a Given Tablespace
- Query To Get List of Database Links
- Query To Get List of Database Directories
- Query To Check Components Status Registered in an Oracle Database
Oracle EBS Application Monitoring SQL Queries:
- Query To Check Concurrent Managers Status
- Query To Check Inactive/Down Concurrent Managers Details
- Query To Check All Workflow Mailer Component Status
- Query To Check Inventory Interface Managers Status
- Query To Check Long Running Concurrent Requests
- Query To Get Details of All Current Running Concurrent Requests
- Query To Check Concurrent Program Run History
- Query To Check Cocurrent Request Status
- SQL Script To Analyze a Concurrent Request
- Query To Get Concurrent Request ID for a Given Oracle SID
- Query To Get Oracle SID Details for a Given Concurrent Request ID
Miscellaneous Oracle EBS Application Related Queries:
- Query To Monitor Invalid objects in Oracle EBS R12.2
- Query To Get Internal Manager (ICM) Log File Location
- Query To Check Oracle EBS Version, OATM Status and other Basic Details
- Query To Get FND NODES Details
- Query To Check FND Languages Installed in Oracle EBS
- Query To Get FND User Details
- SQL Script to Start and Stop EBS Workflow Service Containers
Thanks for sharing those scripts
ReplyDeleteThanks for sharing those scripts
ReplyDeleteThanks u very much
ReplyDeleteThanks !!!
ReplyDeleteI follow your blog regularly.. Thanks for the wonderful stuff for Apps DBAs.
ReplyDeleteOur client wants to:
Oracle EBS SSO Integrations
How to enabe SSOgen SSO for EBS
Any recommendations would be of great help.. Thanks much!!
This comment has been removed by a blog administrator.
ReplyDeleteYour blog is very much informative
ReplyDeleteyou blog is very useful SAP bods learners.very informative content and detailed topic explanation.one of the recommanded content.we are very glad to leave a comment here.thank you for sharing your knowledge.also visit our blogs
ReplyDeleteOracle Apps DBA Training in Bangalore
Good knowledge post for this information
ReplyDeleteOracle Workflow training in bangalore
Hi Kiran - Great Job and thanks for sharing this valuable information. I would request you to post information regarding performance tuning here so that i could be help us. I used to check your blog on regular basis for any new learning prospective. Thanks!!!!!
ReplyDelete