This content has been marked as final. Show 3 replies
971973 wrote:No clue! How about you do a trace of the process that is invoking the sqlplus and see what it's going through behind the scenes?
Here's what I did:
1) Launch cmd (command prompt window)
2) Typed in "sqlplus". Then, the waiting time for sqlplus banner "SQL*PLUS: Release 22.214.171.124.0 .....All rights reserved." to appear is 12 minutes.
After this I can log in to database with no problem (takes < 1 min very fast).
Why did it take so long for the Sqlplus banner to appear? What is happening behind the scene? What initialization processes are going on?
The same happens when I launch "sqlplus.exe" directly. From the moment "sqlplus.exe" window appears on screen, it takes 12 minutes for the banner to appear next.
Grateful if someone is able to help with this pl. Thanks.
you can enable trace on process . use command procmon