for sql tuning advisor - plan with id 1 could not be reproduced in the current environment.
I am a beginner for sql tuning.
ALTERNATIVE PLANS SECTION
Plan 1
Plan Origin :Cursor Cache
Plan Hash Value :394423625
Executions :765
Elapsed Time :254.540 sec
CPU Time :3.648 sec
Buffer Gets :785622
Disk Reads :786210
Disk Writes :1
Notes:
- Statistics shown are averaged over multiple executions.
- The plan with id 1 could not be reproduced in the current environment. For
this reason, a SQL plan baseline cannot be created to instruct the Oracle optimi
zer to pick this plan in the future.
0