UNIX Priority and Oracle

From: Scott T. Johnson <sjohnson_at_ibm.net>
Date: 1997/02/11
Message-ID: <33013089.267F@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 Tue Feb 11 1997 - 00:00:00 CST