Oracle Database 10g: Inside the ‘Self-managing’ Database

Oracle Database 10g: Inside the ‘Self-managing’ Database

racle has given its grid-ready, next-generation database the ability to manage itself and assume the burden of daily management tasks from the database administrator (DBA). During a session dedicated to the Database 10g product at the OracleWorld Conference in San Francisco this past week, Richard Sarwal, vice president of server performance and data server applied technology for Oracle, listed five main database manageability challenges that DBAs face today. He stressed that they all occur outside the database itself:

  • Application and SQL management
  • Backup and recovery
  • System requirements management
  • Storage management
  • Space management

Oracle has built functionality into its new database product that enables it to meet each of these challenges with only minimal intervention from administrators. “10g is pulling all those things that take place outside the database inside the database,” said Sarwal.

10g pulls management tasks that take place outside the database inside the database.
Based on customer feedback from the 2001 International Oracle Users Group (IOUG) User Survey, Oracle discovered that DBAs devote 55 percent of their time to ongoing systems management. A self-managing database, Oracle reasons, would return much of that time to DBAs, freeing them to concentrate on more strategic tasks.

How Database 10g Was Built
According to Sarwal, the first thing Oracle did was build a repository inside the database for raw system statistics and object data. The result was the Automatic Workload Repository (AWR). By default, 10g retrieves database system data and dumps it onto disk in the AWR every 30 minutes. Functioning as the database’s own data warehouse, this data collection informs Database 10g‘s self-management.

Next, Oracle had to ensure that the database would know how to use this data, which led to the creation of the Automatic Database Diagnostic Monitor (ADDM). Sarwal calls ADDM (pronounced “Adam”) the brains of the database. Its role is to automatically pore through all the infrastructure data in the AWR, detect patterns of use, and produce graphical diagnostics reports that include recommendations for improving performance. It can also prompt server-generated alerts when bottlenecks, “hot spots,” and other performance problems occur.

ADDM is a “performance expert in a box.”
ADDM is a “performance expert in a box” according to Sarwal. Using its Automatic Tuning Optimizer, for example, ADDM profiles SQL statements to identify bad (or high-load) SQL, automatically adapts to workload changes, and performs dynamic sampling and partial execution techniques.

“Let the Database Manage Storage”
Automatic Storage Management (ASM) is another new Database 10g feature that Oracle is touting. Andy Mendelsohn, Senior Vice President, Oracle Database and Application Server Technologies, describes it as a built-in, high-performance file system and disk manager. Mendelsohn says ASM is based on the principle that the database knows better how to manage storage than its administrators do. “Give the database the raw disk and let the database manage the storage for you,” he said.

The way it accomplishes this is by striping and mirroring data across modular storage arrays (i.e., low-cost storage-like disks), treating the database grid as a large pool of storage rather than separate volumes. ASM simultaneously performs automatic I/O tuning among disks and auto load-balancing based on user-defined requirements. The need for a volume manager and file systems is virtually eliminated, and ASM automatically remirrors when a disk fails.

Self-management, explained Executive Vice President for Server Technologies, Chuck Rozwat in a keynote address Wednesday, means that the database system is capable of taking a workload and figuring out where to run it in order to meet predefined requirements. For example, administrators can predefine a Quality of Service level or define a threshold for CPU usage and let Oracle 10g provision the workload to meet those needs.

Flashback Database: Single-command Recovery
Oracle has built Flashback features into 10g that will replace the old recovery method of restoring data from tape backups. A fundamental change in 10g is the shift in storage media from tape to disk. Mendelsohn explained that the use of tapes dates back decades to when tape was cheaper than disk. But now that the two media are nearly equal in cost, why not use disk, he argues. Tape recovery is linear, so administrators have to recover the database at a given point in time and roll the changes forward. Disk, on the other hand, enables random access recovery where only the needed data is restored.

Juan Loaiza, Oracle’s vice president of systems technologies, describes the Flashback Database feature as “a rewind button for the database.” A Flashback Log inside Database 10g acts as a continuous backup. It captures old versions of changed blocks, operating on only the changed data. An administrator can replay the log to restore a database and it restores only the changed blocks.

Database 10g offers these Flashback recoveries at all levels: database, table, and row.
Database 10g offers these recoveries at all levels: database (Flashback Database), table (Flashback Table), and row (Flashback Row). The result is incremental recovery: the ability to go back only as far as necessary and to conversely go forward if you went too far. Loaiza sums it up by saying, “if it took you five minutes to make an error, it shouldn’t take 50 hours to recover. It should take five minutes to fix.”

All this internal intelligence promises reduced failover times with faster recognition and restart. Loaiza said, “we’re trading disk space, which is cheaper these days, for downtime, which is expensive.”

The approximately 2,000 attendees of Wednesday’s keynote reacted enthusiastically to a demonstration of the new Flashback recovery features.

Oracle Database 10g is slated for release at the end of 2003.

devx-admin

devx-admin

Share the Post:
Battery Breakthrough

Electric Vehicle Battery Breakthrough

The prices of lithium-ion batteries have seen a considerable reduction, with the cost per kilowatt-hour dipping under $100 for the first occasion in two years,

Economy Act Soars

Virginia’s Clean Economy Act Soars Ahead

Virginia has made significant strides towards achieving its short-term carbon-free objectives as outlined in the Clean Economy Act of 2020. Currently, about 44,000 megawatts (MW)

Renewable Storage Innovation

Innovative Energy Storage Solutions

The Department of Energy recently revealed a significant investment of $325 million in advanced battery technologies to store excess renewable energy produced by solar and

Development Project

Thrilling East Windsor Mixed-Use Development

Real estate developer James Cormier, in collaboration with a partnership, has purchased 137 acres of land in Connecticut for $1.15 million with the intention of

USA Companies

Top Software Development Companies in USA

Navigating the tech landscape to find the right partner is crucial yet challenging. This article offers a comparative glimpse into the top software development companies

Battery Breakthrough

Electric Vehicle Battery Breakthrough

The prices of lithium-ion batteries have seen a considerable reduction, with the cost per kilowatt-hour dipping under $100 for the first occasion in two years, as reported by energy analytics

Economy Act Soars

Virginia’s Clean Economy Act Soars Ahead

Virginia has made significant strides towards achieving its short-term carbon-free objectives as outlined in the Clean Economy Act of 2020. Currently, about 44,000 megawatts (MW) of wind, solar, and energy

Renewable Storage Innovation

Innovative Energy Storage Solutions

The Department of Energy recently revealed a significant investment of $325 million in advanced battery technologies to store excess renewable energy produced by solar and wind sources. This funding will

Renesas Tech Revolution

Revolutionizing India’s Tech Sector with Renesas

Tushar Sharma, a semiconductor engineer at Renesas Electronics, met with Indian Prime Minister Narendra Modi to discuss the company’s support for India’s “Make in India” initiative. This initiative focuses on

Development Project

Thrilling East Windsor Mixed-Use Development

Real estate developer James Cormier, in collaboration with a partnership, has purchased 137 acres of land in Connecticut for $1.15 million with the intention of constructing residential and commercial buildings.

USA Companies

Top Software Development Companies in USA

Navigating the tech landscape to find the right partner is crucial yet challenging. This article offers a comparative glimpse into the top software development companies in the USA. Through a

Software Development

Top Software Development Companies

Looking for the best in software development? Our list of Top Software Development Companies is your gateway to finding the right tech partner. Dive in and explore the leaders in

India Web Development

Top Web Development Companies in India

In the digital race, the right web development partner is your winning edge. Dive into our curated list of top web development companies in India, and kickstart your journey to

USA Web Development

Top Web Development Companies in USA

Looking for the best web development companies in the USA? We’ve got you covered! Check out our top 10 picks to find the right partner for your online project. Your

Clean Energy Adoption

Inside Michigan’s Clean Energy Revolution

Democratic state legislators in Michigan continue to discuss and debate clean energy legislation in the hopes of establishing a comprehensive clean energy strategy for the state. A Senate committee meeting

Chips Act Revolution

European Chips Act: What is it?

In response to the intensifying worldwide technology competition, Europe has unveiled the long-awaited European Chips Act. This daring legislative proposal aims to fortify Europe’s semiconductor supply chain and enhance its

Revolutionized Low-Code

You Should Use Low-Code Platforms for Apps

As the demand for rapid software development increases, low-code platforms have emerged as a popular choice among developers for their ability to build applications with minimal coding. These platforms not

Cybersecurity Strategy

Five Powerful Strategies to Bolster Your Cybersecurity

In today’s increasingly digital landscape, businesses of all sizes must prioritize cyber security measures to defend against potential dangers. Cyber security professionals suggest five simple technological strategies to help companies

Global Layoffs

Tech Layoffs Are Getting Worse Globally

Since the start of 2023, the global technology sector has experienced a significant rise in layoffs, with over 236,000 workers being let go by 1,019 tech firms, as per data

Huawei Electric Dazzle

Huawei Dazzles with Electric Vehicles and Wireless Earbuds

During a prominent unveiling event, Huawei, the Chinese telecommunications powerhouse, kept quiet about its enigmatic new 5G phone and alleged cutting-edge chip development. Instead, Huawei astounded the audience by presenting

Cybersecurity Banking Revolution

Digital Banking Needs Cybersecurity

The banking, financial, and insurance (BFSI) sectors are pioneers in digital transformation, using web applications and application programming interfaces (APIs) to provide seamless services to customers around the world. Rising

FinTech Leadership

Terry Clune’s Fintech Empire

Over the past 30 years, Terry Clune has built a remarkable business empire, with CluneTech at the helm. The CEO and Founder has successfully created eight fintech firms, attracting renowned

The Role Of AI Within A Web Design Agency?

In the digital age, the role of Artificial Intelligence (AI) in web design is rapidly evolving, transitioning from a futuristic concept to practical tools used in design, coding, content writing

Generative AI Revolution

Is Generative AI the Next Internet?

The increasing demand for Generative AI models has led to a surge in its adoption across diverse sectors, with healthcare, automotive, and financial services being among the top beneficiaries. These

Microsoft Laptop

The New Surface Laptop Studio 2 Is Nuts

The Surface Laptop Studio 2 is a dynamic and robust all-in-one laptop designed for creators and professionals alike. It features a 14.4″ touchscreen and a cutting-edge design that is over

5G Innovations

GPU-Accelerated 5G in Japan

NTT DOCOMO, a global telecommunications giant, is set to break new ground in the industry as it prepares to launch a GPU-accelerated 5G network in Japan. This innovative approach will

AI Ethics

AI Journalism: Balancing Integrity and Innovation

An op-ed, produced using Microsoft’s Bing Chat AI software, recently appeared in the St. Louis Post-Dispatch, discussing the potential concerns surrounding the employment of artificial intelligence (AI) in journalism. These

Savings Extravaganza

Big Deal Days Extravaganza

The highly awaited Big Deal Days event for October 2023 is nearly here, scheduled for the 10th and 11th. Similar to the previous year, this autumn sale has already created

Cisco Splunk Deal

Cisco Splunk Deal Sparks Tech Acquisition Frenzy

Cisco’s recent massive purchase of Splunk, an AI-powered cybersecurity firm, for $28 billion signals a potential boost in tech deals after a year of subdued mergers and acquisitions in the