Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Limit CPU_PER_CALL for Profile

596569Sep 6 2007 — edited Sep 6 2007

Hi Everyone,

I'm trying to limit the CPU_PER_CALL value on the 'default' profile, in my 10g database.

I changed the CPU_PER_CALL value in Enterprise Manager, which in effect runs the following SQL:

ALTER PROFILE "DEFAULT" LIMIT CPU_PER_CALL 10000

This should limit the queries run against the DB to 10 seconds, however I still have no problem running 20, 30 second queries, etc.

Am I misunderstanding what CPU_PER_CALL does? Or have I just set it up wrong?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 4 2007

Added on Sep 6 2007

#general-database-discussions

7 comments

11,567 views