For example, in one instance there are three 400MB, 300MB and 200MB circuits. Whether orakl will occupy less resources (and productivity therefore will grow) if to leave only the first scheme, and the others to delete? I ask because somewhere long ago I read that orakl loads the database into memory and I am interested that if I work only with the first scheme, are there any others in memory that I do not work with.

  • I doubt that there is an impact on the speed of work. Unless time of reading of files falls due to increase in time of search in FAT. Even so, this can be neglected. our dba joke - the most important optimization of oracle db, - migration from windows to linux - jmu

1 answer 1

The number of users does not affect the performance of the database. By default, about fifty users are created in Oracle ( link ).