Activation (Communications Industry) (MOSC)

MOSC Banner

Indexes, Materialized Views and ASAP Performance

edited Nov 1, 2012 9:36PM in Activation (Communications Industry) (MOSC) 1 commentAnswered
 In ASAP production environment, dashboard processes are used which collect Work Order / ASDL / CSDL processing data/statistics like failed/completed ASDL per NE etc from SARM tables like (TBL_ASDL_LOG, TBL_WRK_ORD, TBL_SRQ etc) at an interval of every 15 minutes. Business is looking to change the frequency to 5 minutes. This Query is taking around 10-12 minutes to execute every time. However, this process is consuming lot of I/O's on database side and is impacting performance of database as average I/O% is almost 100% always.
DBAs at our end, suggest 2 approaches that can improve these I/O's and time taken by the queries every time:

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