Oracle buffer gets

Posted on 2007-10-12
Last Modified: 2013-12-19
Hello I'm using Oracle 9i .
Do u have any idea how can I reduce buffer gets except from using bigger block_size
Thank you
Question by:active1065
    1 Comment
    LVL 73

    Accepted Solution

    write more efficient sql and pl/sql.

    That's not meant to be funny, but really, to reduce the gets, you need to "get" less data.  Do less work on the db.  

    Don't process things in loops requerying the same data again and again.
    Do use single sql statements to process the data once.

    Don't self-join if you don't have to.
    Do use analytics to refrence data within the same result-set.

    Use scalar subqueries instead of joins to do singleton lookups.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now