Articles in the Databases Category
Oracle – Optimization of sorting
When we perform a sort operation, we note the increase in I / O to disk. To overcome this increase slows down somewhere the performance of our queries, increase the value of SORT_AREA_SIZE. This parameter …
Oracle – Oracle architecture components
An Oracle server is a system used to manage databases and provides a means of information management open, comprehensive and integrated.
An Oracleserver consists of an instance and a database.
Oracle instance
The Oracle instance can access the …
