|
|
Advanced Oracle Database Monitoring Tool
Mikulka, David ; Chmelař, Petr (referee) ; Kolář, Dušan (advisor)
This master's thesis describes possibilities of Oracle Database 10g and 11g monitoring. It let the reader know about practical tools for monitoring and describes the database's internal catalogs preserving statistics and the information about running database instances within history. Next, it describes design of an Oracle database monitoring tool, describtion of its implementation and at the end its evaluation and comparison with other similar applications.
|
|
|
Advanced Oracle Database Monitoring Tool
Mikulka, David ; Chmelař, Petr (referee) ; Kolář, Dušan (advisor)
This master's thesis describes possibilities of Oracle Database 10g and 11g monitoring. It let the reader know about practical tools for monitoring and describes the database's internal catalogs preserving statistics and the information about running database instances within history. Next, it describes design of an Oracle database monitoring tool, describtion of its implementation and at the end its evaluation and comparison with other similar applications.
|
|
| |
|
|
XML Representation of Network Traffic
Novák, Martin ; Ščuglík, František (referee) ; Ráb, Jaroslav (advisor)
This bachelor work deals with the representation of captured network traffic in XML and storing within a database system Oracle by using XML schema. The beginning explains the basics of computer networks, network management and network protocols that are captured. Followed by chapters on network traffic analyzer, NetPDL format used to describe intercepted traffic, a chapter devoted to the foundation of relational database systems and the foundation of Oracle database system. At the end of the bachelor work there are chapters dealing with the created XML schemas, implementation of the program, program tools and the description how to use the program.
|
|
|
Impact of partitioning on the performance of Oracle database
Řeháček, Tomáš ; Macák, Petr (advisor) ; Palovská, Helena (referee)
The main aim of this bachelor thesis is to provide information about how to use partitioning in an Oracle database and to determine its effect on change in performance during database load. Description of this additional functionality and proposal appropriate testing environment in which it is possible to make measurements were necessary in order to achieve the main goal. The contribution is in the recommendations that can be drawn on the basis of the values obtained during tests performed. The thesis examines general options of partitioning, benefits and costs that are associated with its use, application partitioning methods and management capabilities. Tests are conducted on a large number of scenarios in the practical part. Conclusions, recommendation and suitable conditions for use of partitioning are based on tests.
|
|
|
Backup and recovery of Oracle Database using Recovery Manager
Hubáček, Filip ; Macák, Petr (advisor) ; Palovská, Helena (referee)
The bachelor's thesis discusses the implementation of backup and recovery of Oracle database using Recovery Manager. There are described individual backup types available in Oracle database environment and recovery types. Author introduces the benefits of using Recovery Manager, as the main backup tool in comparison to other methods of performing backup / restore.The reader is acquaint with the results of tests of the possible backup types. The tested features are speed of backup operation, the availability of the database during the backup, the compression ratio and the speed of restore operation. Base on the comparison of these results is set the backup and recovery strategy for the database of two model companies.
|
guest ::
