Search

Top 60 Oracle Blogs

Recent comments

November 2020

High System Load with Low CPU Utilization on Linux?

In this post I will show you how to break down Linux system load by the load contributor or reason. You can drill down into the “linux system load in thousands” and “high system load, but low CPU utilization” problem patterns too.
Introduction - terminology Troubleshooting high system load on Linux Drilling down deeper - WCHAN Drilling down deeper - kernel stack How to troubleshoot past problems Summary Further reading Introduction - Terminology The system load metric aims to represent the system “resource demand” as just a single number.

Join Us in Honoring Transgender Day of Remembrance

Today, November 20th, people around the world pause to bear witness to Transgender Day of Remembrance, a day dedicated to honoring the memory of those murdered because of anti-transgender prejudice. Transgender Day of Remembrance reminds us to fight against forces that devalue transgender lives every day. To bring awareness to this important day, we want to pause to share a few stories of transgender people who have found their voice on WordPress.com. We posed a question: “What does Transgender Day of Remembrance mean to you?” Below, we’ve shared a few responses from creators on our platform.

We welcome you to share your own response on your site. In the meantime, read slowly and soak in the hard-fought words of the brave voices who are willing to share their experiences. 

Oracle 12.2: New Statistic Preference PREFERENCE_OVERRIDES_PARAMETER

Introduction

There is a new statistic preference, PREFERENCE_OVERRIDES_PARAMETER available from Oracle 12.2.  It allows the DBA to override any parameters specified when gathering statistics in favour of any statistics preferences that are defined.  This new preference can be specified at database-level or at table-level, or both.

From the introduction of the cost-based optimizer in Oracle 7, we all had to write scripts to collect statistics.  The introduction of the maintenance window in Oracle 10g was supposed to supersede that with a regularly scheduled maintenance window.  It still is not uncommon to find systems that rely on custom scripts that collect object statistics.  Sometimes, commands to collect statistics are embedded in applications.  

Retrofitting Partitioning into Existing Applications: Example 2. Payroll

This post is part of a series about the partitioning of database objects.

Retrofitting Partitioning into an Existing Application: 3. Scripting & Archiving

This post is part of a series about the partitioning of database objects.

Retrofitting Partitioning into an Existing Application: 2. What kinds of partitioning can you do?

This post is part of a series about the partitioning of database objects.

Retrofitting Partitioning into an Existing Application: 1. Introduction

This post is the first in a series about the partitioning of database objects.

Retrofitting Partitioning into Existing Applications: Conclusion

This is the last post in a series about the partitioning of database objects.

The missing multiplication aggregation in SQL

A few days back on Twitter, a cool little discussion arose out of the SQL Daily regular tip – the lack of an aggregate function that will return a aggregated product of a set of numbers.

blog_sql_product