Implementation of methods for monitoring of unused objects for Oracle Server

Dariusz Karpisz

Abstract


The problem of maintain of database systems is very complex. One of the most frequent appearing problems is unused object identification, what in long term of time may in negative way affect on system productivity. Proposed in this paper solution based on P/SQL for Oracle 10g may supporting DBA maintains database systems.

Keywords


database audit; monitoring; unused objects; Oracle

Full Text:

PDF (Polski)

References


Gutta R.: Oracle skrypty administracyjne. Mikom, Warszawa 2002.

Loney K.: Oracle Database 10g Kompendium administratora. Helion, Gliwice 2005.

Whalen E.: Oracle Database 10g Administracja bazy danych w Linuksie. Helion, Gliwice 2007.

Theriault M., Carmichael R., Viscusi J.: Oracle DBA - administrowanie bazą danych. RM, Warszawa 2001.

Oracle: Oracle Database Administrator's Guide 10g Release 2. B14231 -02, 2006.

Oracle: Oracle Database Security Guide 10g Release 2. B14266-04, 2008.

Oracle: Oracle Database PL/SQL Packages and Types Reference 10g Release 2. B14258-02, 2007.




DOI: http://dx.doi.org/10.21936/si2009_v30.n2B.453