Optimization methods in distributed databases in Oracle DBMS

Andrzej Barczak, Dariusz Zacharczuk, Damian Pluta


The article presents the procedures, which need be taken in order to maximize the performance of distributed database. Various methods are describe and their impact on performance depending on the environment and configuration. At the end of publication, author shows the path that one should take and data which should be collected, so that the whole process has given a positive result.


optimization; distributed data base; Oracle

Full Text:

PDF (Polski)


Alapati S. R.: Expert Oracle Database 10g Administration. Apress, 2005

Antognini Ch.: Troubleshooting Oracle Performance. Apress, 2008.

Barczak A., Florek J., Sydoruk T.: Bazy danych. Wydawnictwo Akademii Podlaskiej, 2007.

Burleson D. K.: Oracle Tuning: The Definitive Reference. Rampant TechPress, 2010.

Dye Ch.: Oracle Distributed Systems. O'Reilly, 1999.

Greenwald R., Stackowiak R., Stern J.: Oracle Essentials: Oracle Database 10g. 3rd Edition. O’Reilly, 2004.

Kyte T.: Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions. Apress, 2010.

Lonley K., Bryla B.: Oracle Database 10g Podręcznik administrator baz danych. Helion, Gliwice 2008.

Powell G.: Oracle Performance Tuning for 10gR2. Elsevier Digital Press, 2007.

Price J.: SQL i Programowanie, Oracle Database 11g. Helion, Gliwice 2009.

Tow D.: SQL. Optymalizacja. Helion, Gliwice 2004.

Urman S., Hardman R., McLaughlin M.: Oracle Database 10g. Programowanie w języku PL/SQL. Helion, Gliwice 2007.

Whalen E., Schroeter M.: Oracle Optymalizacja wydajności. Helion, Gliwice 2003.

Wrembel R., Bębel B.: Oracle Projektowanie rozproszonych baz danych. Helion, Gliwice 2003.

Oracle PL/SQL Database Code Library and Resources, http://psoug.org/reference/library.html.

Oracle: Dokumentacja techniczna.

DOI: http://dx.doi.org/10.21936/si2015_v36.n1.726