Q
Manage Learn to apply best practices and optimize your operations.

APIs in Oracle Enterprise Manager

I would like to know if there are any APIs available in Oracle Enterprise Manager to find out details of a process. For example, if I know that my SAP program is running slow on my Oracle database, I would like to pass the process ID or program name to an API to get detailed information.

I would like to know if there are any APIs available in Oracle Enterprise Manager to find out details of a process. For example, if I know that my SAP program is running slow on my Oracle database, I would like to pass the process ID or program name to an API to get detailed information such as whether it is waiting on a locked resource or doing a full table scan, etc.
You don't need an API to Enterprise Manager to get this information; just query the dynamic performance view V$SESSION (the source of the data displayed by Enterprise Manager). It contains the client machine name, OS username and program being executed; once you have identified the Oracle session corresponding to the operation of interest, you can find out what it's waiting on ( V$SESSION_WAIT in versions previous to 10g, V$SESSION in 10g), what SQL it's executing (in V$SQLTEXT) and so on.

Dig Deeper on Oracle and SQL

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close