Reducing Priority on job submitted to Oracle
From: Scott T. Johnson <sjohnson_at_ibm.net>
Date: 1997/02/09
Message-ID: <32FE9739.4889_at_ibm.net>#1/1
Date: 1997/02/09
Message-ID: <32FE9739.4889_at_ibm.net>#1/1
I have a stored procedure which is called by a Pro*C program. The program takes 2 hours to complete and seems to eat a lot of CPU time.
Is there a way to reduce the priority of a process, job, or procedure which Oracle is running. I have read that reducing the Oracle background processes will not work. Is there a setting in the user profiles. The profile options don't seem to apply. They just return an error of some time if the parameter is violated.
Any ideas?
Thanks,
Scott
Received on Sun Feb 09 1997 - 00:00:00 CET