Latest Databases News

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. ...

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 ...