When you run a query to fetch data from SQL Server into Oracle, and that query hangs, it leaves a process (after you kill off the sql*plus instance) running on your system called dg4odbc. dg4odbc is the database gateway application that allows Oracle to access SQL Server. In my case, my Oracle server had its CPU pegged at 100%, most of which was shared among several of a single dg4odbc instance.
I went ahead and killed off the dg4odbc process, and my CPU went back to normal.
I went ahead and killed off the dg4odbc process, and my CPU went back to normal.
No comments:
Post a Comment