What is the value of database files?

[DBAChris]

When parallel_automatic_tuning is set to true oracle sets different parameters on its own one is ENQUEUE_RESOURCES.
When sessions < 4 the formula for ENQUEUE_RESOURCES is database files +20 for sessions between 4-10 the formula is database files + ((sessions-3)*5)+20 and for sessions > 10 the formula is database files + ((sessions-10)*2)+55.

Where can I find the value for database files so I can accurately determine the value of ENQUEUE_RESOURCES.
I have tried datafiles, MAXDATAFILES, control files, log files and redo log files.

 

[rtefft]

I don't know how the number of datafiles fits into your equation; according to the 8.1.7 Server Reference:

&quot;The default value of ENQUEUE_RESOURCES is derived from the SESSIONS parameter and is usually adequate, as long as its value is greater than DML_LOCKS + 20. For three or fewer sessions, the default value is 20. For 4 to 10 sessions, the default value is ((SESSIONS -3)*5)+ 20. For more than 10 sessions, it is ((SESSIONS - 10) * 2) + 55. If you explicitly set ENQUEUE_RESOURCES to a value higher than DML_LOCKS + 20, then Oracle uses the value you provide.&quot;
(Server Reference, Init Parameters pg 1-37)

I didn't see any mention of Enqueues under parallel_automatic_tuning... or is this a 9i thing?

Regards,
Rich
____________________________
Rich Tefft
PL/SQL Programmer