Logo Background

Oracle Memory Allocation

  • By on August 20, 2008 | No Comments

    Oracle stores information in memory and on disk. Memory access is much faster than disk access, so it is better for data requests to be satisfied by access to memory rather than access to disk. For best performance, store as much data as possible in memory rather than on disk. However, memory resources on your operating system are likely to be limited. Tuning memory allocation involves distributing available memory to Oracle memory structures.

    Database Memory Allocation Method

    Oracle’s memory requirements depend on your application; therefore, you should tune memory allocation after tuning your application and SQL statements. If you allocate memory before tuning your application and SQL statements, you may need to resize some Oracle memory structures to meet the needs of your modified statements and application.

    Tune memory allocation before you tune I/O. Allocating memory establishes the amount of I/O necessary for Oracle to operate.

    Previous
    Next
    » CHMOD Recursive Command On Specific File Extension
Leave a Comment