In the use of large systems, we will encounter such errors because the system is wrong Table Full Error caused an Oracle database. This incorrect caused by the NFILE value is too small.
Take a look at the explanation of HPDoc: Nfile Defines The maximum number of files That Can Be Open Simultaneously, System-Wide, at Any Given Time.
At first glance, it seems to be the number of documents we see, in fact, it is not, seeing the nofile parameters to manage.
IT is The Number of Slots in The File Descriptor Table. Be Generous With this Number Because The Required Memory Is Minimal, And NOT HAVING ENOUGH SLOTS RESTRICTS System Processing Capacity.
NFILE default calculation formula is as follows: ((16 * (NPROC 16 MAXUSERS) / 10) 32 2 * (NPTY NSTRPTY)
So how do this value be set?
Priority Consideration According to the results of SAR -V, appropriate increases. Observe about a week, use LSOF to see how much it actually takes.
