Database Tuning (MOSC)

MOSC Banner

Slow query on FND_CONCURRENT_REQUESTS

edited Mar 7, 2012 3:08PM in Database Tuning (MOSC) 9 commentsAnswered
Hi - We are running following query from Forms and it is taking more time to complete.Following query is running on FND_CONC_REQ_SUMMARY_V view which is running on FND_CONCURRENT_REQUESTS table.We have all Indexes on FND_CONCURRENT_REQUESTS and table has 425K records.Below the SQL statement there is explain plan.FULL TABLE scan is happening on FND_CONCURRENT_REQUEST table and cost of the query is 38K.Please help me to tune this query.SELECT CONCURRENT_PROGRAM_ID,PROGRAM_APPLICATION_ID,PRINTER,PROGRAM_SHORT_NAME,ARGUMENT_TEXT,PRINT_STYLE,USER_PRINT_STYLE,SAVE_OUTPUT_FLAG

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center