828
Appendixes
data_source[, Repetitions are indicated by repeating the item
data_source...] between square brackets, adding an optional delimiter
and three trailing dots at the end. In the example, you
specify one or more data sources each delimited by
a comma.
data_source := Often clauses are specified separately. In the example,
you specify the
data_source clause separately.
ALTER RESOURCE COST
You use ALTER RESOURCE COST to specify the parameters Oracle uses to calculate
the total resource cost for a session. Four parameters can be weighted into the
calculation. If a parameter is omitted, it won’t be taken into account at all. The
ALTER RESOURCE COST command’s syntax follows:
ALTER RESOURCE COST
{ CPU_PER_SESSION
integer
| CONNECT_TIME
integer
| LOGICAL_READS_PER_SESSION
integer
| PRIVATE_SGA
integer
}
The following list explains all of the elements used in the ALTER RESOURCE COST
command syntax:
CPU_PER_SESSION Specifies the weight assigned to the
amount of CPU time (in hundredths of a
second) used by a session. The default
value is 0, which means it isn’t taken into
account in the calculation.
CONNECT_TIME Specifies the weight assigned to the
elapsed connection time (in minutes) of
a session. The default value is 0, which
means it isn’t taken into account in the
calculation.
LOGICAL_READS_PER_SESSION Specifies the weight assigned to the
number of data block reads during a
session. The default value is 0, which
means it isn’t taken into account in the
calculation.
PRIVATE_SGA Specifies the weight assigned to the
private size of the SGA (in bytes) used by
a session. The default value is 0, which
means it isn’t taken into account in the
calculation.
评论0
最新资源