Performance - EBS (MOSC)

MOSC Banner

I would like understand tuning and tkprof

edited Oct 19, 2011 11:18PM in Performance - EBS (MOSC) 7 comments
Hello,

    I have executed tkprof and my explain plan is next :

I would like understand :

I have inserted 24 rows and and I have executed 23 access to the disk.
How can I improve by reduce the access to the disk ? because I have 24 rows and 23 access to the disk.

For me if I have the memory bigger for the disk then I can reduce the number access to the disk.

Who can explain me the process ?

And I see on my result the optimizer mode = ALL_ROWs
is it better or 'FIRST_ROWS is better ?

best regards

Thanks for your help

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 Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center