Aimstar

AIMSTAR Blog

An Oracle DBA Performance Case Study

Posted by Theodore Williams on Mar 7, 2017 11:20:00 AM

INTRODUCTION:

This article details the Oracle Database Administration  steps taken to solve a performance issue at a previous client.

Overview:  The client had an application in which much of the processing involved a parent and child table.  The parent table had an “on delete cascade” constraint. 

Problem: The pages in the client application were taking a long time to load and the delete function was taking minutes to finish what should have taken seconds to complete.

Relevant Topics:  Dynamic Sampling, Statistics Generation, Locked Tables, Recursive SQL, Unindexed Foreign Keys, Oracle DBA, database systems, database management

Read More

Topics: Oracle DBA, database systems, database management, Oracle database development, Oracle Database Administration