General Ledger - EBS (MOSC)

MOSC Banner

GLPPOS Posting Performance issue.

edited Feb 9, 2015 10:01AM in General Ledger - EBS (MOSC) 3 commentsAnswered

GLPPOS Posting Performance issue and checked the trace file as below:

STAT #4578908304 id=3 cnt=4771 pid=2 pos=1 obj=3411597 op='TABLE ACCESS FULL GL_POSTING_INTERIM_689419 (cr=60 pr=60 pw=0 time=51082 us cost=16 size=287615 card=4715)'

STAT #4578908304 id=4 cnt=4761 pid=2 pos=2 obj=35308 op='TABLE ACCESS BY INDEX ROWID GL_BALANCES (cr=58899579 pr=116 pw=0 time=2662595559 us cost=2 size=31 card=1)'

STAT #4578908304 id=5 cnt=3456441924 pid=4 pos=1 obj=35317 op='INDEX RANGE SCAN GL_BALANCES_N2 (cr=16291501 pr=19 pw=0 time=1415289268 us cost=2 size=0 card=549163)'

WAIT #45

Scans on GL_BALANCES_N2 and GL_BALANCES_N1 INDEX IS NOT USED.


How to improve this kind of performance issue?

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

EBS GL Tags

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