Using a global huge tnsnames.ora file (more than 600k) the start of SQL Tuning module from PAO 6.1.113.1 takes almost half an hour. Using a truncated tnsnames.ora, it takes less than 1 minute. The tnsnames.ora is located on a network drive. If the tnsnames.ora placed on a local drive then the startup is also fast.
The problem is related to startup of SQL Tuning and not how Performance Analysis launch SQL Tuning.
WORKAROUND:
Use a trimmed down version of tnsnames.ora file on the shared drive.
or
Put the huge tnsnames.ora on a local drive.
STATUS:
Waiting for fix in a future release of QCO SQL Tuning
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center