Everand Logo

Welcome to Everand!

  • Discover millions of ebooks, audiobooks, and so much more with a free trial

    Only $11.99/month after trial. Cancel anytime.

    Oracle High Performance Tuning for 9i and 10g
    Oracle High Performance Tuning for 9i and 10g
    Oracle High Performance Tuning for 9i and 10g
    Ebook685 pages10 hours

    Oracle High Performance Tuning for 9i and 10g

    By Gavin JT Powell

    3/5

    ()

    Read preview

    About this ebook

    There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration.

    A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model.

    Poorly written SQL code is often a culprit of performance problems and is expensive to rectify. However, tuning of SQL code is generally cheaper than changing the data model. SQL code tends to be contained inside independent blocks within applications or stored procedures.

    Physical database tuning involves hardware resource usage, networking and various other Oracle things such as configuration and file distribution. Physical configuration is often a culprit of poor performance where Oracle is installed with defaults, and never altered by an expert.

    *Includes all three aspects of Oracle database tuning: data model tuning, SQL & PL/SQL code tuning, physical plus configuration tuning
    *Contains experienced guidance and real-world examples using large datasets *Emphasizes development as opposed to operating system perspective
    LanguageEnglish
    PublisherElsevier Science
    Release dateDec 29, 2003
    ISBN9780080513294
    Oracle High Performance Tuning for 9i and 10g
    Author

    Gavin JT Powell

    Gavin Powell, BSc. Comp.Sci., OCP (Oracle8i Certified Professional) has fifteen years of computer industry experience. Diverse experience in database administration and database development in both relational and object databases. Applications development experience is procedural and object-oriented. He also has some systems administration experience. His extensive consulting experience includes software vendors, internet .COM’s (some unfortunately have met with their demise), accounting, banking, financial services, the travel industry, construction, retail, mining, shipping, education and general advisory capacity. Gavin Powell has worked with many software products, tools and programming languages. These tools include items in the list shown below. He has authored two successful books Oracle …High performance Tuning and the just released Oracle SQL

    Read more from Gavin Jt Powell

    Related to Oracle High Performance Tuning for 9i and 10g

    Related ebooks

    Databases For You

    View More
    View More

    Related podcast episodes

    Related articles

    • Article

      Grafana Terminology

      Jan 14, 2020

      A Grafana data source is a database, file or service that provides data to Grafana – it cannot operate without data. A Grafana panel is the basic building block of Grafana. Panels are made of visualisations or queries. A Grafana query is used for req

      1 min read

    • Article

      Your First Steps In Grafana

      Nov 17, 2020

      The easiest way to get hold of Grafana and begin using it as soon as possible is by downloading and executing its official Docker image. This means that apart from the Docker image, you won’t need to download, set up or install anything else for Graf

      1 min read

    • Article

      Grafana, Telegraf And Influxdb

      Jun 30, 2020

      If you don’t like Netdata or if you want to try something else, you can give Grafana (https://grafana.com), Telegraf (www.influxdata.com/time-series-platform/telegraf) and InfluxDB (www.influxdata.com/products/influxdb-overview) a try. Grafana can’t

      1 min read

    • Article

      Heralding An Era Of Advanced Hybrid Design Processors

      Sep 13, 2021

      For the client computing segment, Alder Lake represents Intel’s work in reengineering their processing cores in a big way and push for a more powerful big-core + little-core implementation that ARM processors have touted for a long while, but in the

      5 min read

    • Article

      Vector Vexations

      Apr 2, 2024

      Why does MySQL not support vectors in its community edition? Generative AI is the hot topic in tech. GenAI relies on vector data. Yet Oracle has no plans to support vectors in the community edition of MySQL. If you want to try out vector data with ot

      1 min read

    • Article

      Browser Wars 2020

      May 26, 2020

      Browser Wars 2020
      8 min read

    • Article

      Observability Of The Kernel And Containers

      Apr 4, 2023

      Mihalis Tsoukalos is currently working on Time Series. You can reach him at: @mactsouk. For our final delve into eBPF, we’re tackling applications, the kernel and Docker containers. At the end of the day, all Linux machines execute code for applicat

      10 min read

    • Article

      Browser wars 2020

      Nov 2, 2020

      Browser wars 2020
      8 min read

    • Article

      3ds Max 2024

      Jul 11, 2023

      3ds Max 2024
      3 min read

    • Article

      Networking

      Mar 5, 2024

      > This is likely to result from that Mac having two network connections. When macOS checks every couple of days to ensure that its name is different from others on that local network, it sees itself through the other interface, assumes it’s another M

      1 min read

    • Article

      Rediscover Speed With The Redis Revolution

      Jul 25, 2023

      Credit: https://redis.io Redis is an open-source, in-memory data structure store that has gained popularity R as a highly efficient caching and messaging system. It prioritises speed, efficiency and versatility, making it a top choice for various ap

      8 min read

    • Article

      What is ELT?

      Apr 1, 2021

      It stands for extract, load, and transform- the processes a data pipeline uses for replicating the data from a source system into a target system such as a cloud data warehouse. 1. Extraction is the first step in which data is copied from the source

      6 min read

    • Article

      Browser Wars 2020

      Aug 24, 2020

      Browser Wars 2020
      8 min read

    • Article

      Not End Of Life

      May 30, 2023

      In case you haven’t heard, MySQL 5.7 is going end of life (EOL). The upstream project will stop updates in October and focus on MySQL 8.0. This is a logical decision and they’ve given users ample time to upgrade. But some users and organisations need

      1 min read

    • Article

      Superspeed Your Network For Free… (or Nearly)

      Jan 6, 2022

      A slow network hampers your productivity, and it’s also frankly embarrassing – it sends a message to your staff, and to any external parties who may access it. Yet it’s an area where major improvements can frequently be made with some tweaks to your

      8 min read

    • Article

      The Need For Speed

      Oct 19, 2021

      The 4004 might have required lots of instructions to carry out the simplest of jobs, but the speed also depends on the clock speed and architecture. The clock speed was 740kHz, so just a bit below 1MHz and several thousand times slower than today’s l

      1 min read

    • Article

      The Need For Speed

      Jan 24, 2022

      The 4004 might have required lots of instructions to carry out the simplest of jobs, but the speed also depends on the clock speed and architecture. The clock speed was 740kHz, so just a bit below 1MHz and several thousand times slower than today’s l

      1 min read

    • Article

      Pull, Configure And Run

      Apr 7, 2020

      Guacamole offers ready-to-run installation packages that are available for Linux distros such as CentOS or Debian. However, the thrust of this article is to illustrate running Guacamole in a Docker container context. Fire up an environment where you

      8 min read

    Related categories

    Reviews for Oracle High Performance Tuning for 9i and 10g

    3/5

    1 rating0 reviews

    What did you think?

    Tap to rate

    Review must be at least 10 words

      Book preview

      Oracle High Performance Tuning for 9i and 10g - Gavin JT Powell

      Enjoying the preview?
      Page 1 of 1