Re: Need info on ORACLE profiles
Date: 1995/07/15
Message-ID: <3u9rc1$mhs_at_newsbf02.news.aol.com>#1/1
Composite Limits are a total of weighted values you place on each of the other items in the profile. Each of the limits on a profile can be provided with a weight. So if a person is using multiple resources, such as a CPU intensive session and tries to create another session. And the weight for the CPU intensive session is set high, and the creation of another session is high, they would exceed their composite limit and be dropped/stopped from performing the next act.
As for the CPU time per call, that is easy. This is the limit of CPU time a specific SQL statement sent by the user can use. It is measured in 100ths of seconds. It is great for runaway processes or concerns that poorly written SQL statements will kill your production system.
Hopes this helps Received on Sat Jul 15 1995 - 00:00:00 CEST