Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003

    Arrow Unanswered: Caching in Oracle

    I have recently started working on Oracle, and would like to know the following. Since i come from a networking background, and have the inclination towards caching stuff, I wanted to know if there is something like Caching in Oracle.

    My question is detail would be, suppose I have a page which gets used quite often and more or less the SQLs in the same produce the same result everytime, is there a way I could classify those queries as being used extensively, and set aside the resultset in the cache (if there is any such case).

    I would appreciate response in this regards.

  2. #2
    Join Date
    Mar 2002
    Reading, UK
    Oracle doesnt cache resultsets, it does however cache the data, indexes and sql execution plans. The cache for data and indexes is split into multiple caches for different blocksizes and also keep, default and recycle caches for those objects which should be cached always, cached sometimes and cached rarely (i.e. for v.large objects).

    for more info try


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts