SubjectsSubjects(version: 845)
Course, academic year 2019/2020
   Login via CAS
Oracle Administration - NDBI013
Title in English: Administrace Oracle
Guaranteed by: Department of Software Engineering (32-KSI)
Faculty: Faculty of Mathematics and Physics
Actual: from 2019
Semester: summer
E-Credits: 2
Hours per week, examination: summer s.:0/2 C [hours/week]
Capacity: unlimited
Min. number of students: unlimited
State of the course: taught
Language: Czech, English
Teaching methods: full-time
Additional information:
Guarantor: RNDr. Michal Kopecký, Ph.D.
Class: Informatika Bc.
Informatika Mgr. - volitelný
Classification: Informatics > Database Systems
Annotation -
Last update: T_KSI (28.04.2016)
The lecture will provide students with the knowledge of configuration, maintenance and optimization of Oracle Server. Students will learn specific features of SQL Server including practical administration (configuration, backup and recovery) and programming support (optimization, debugging, performance monitoring, transaction support). The knowledge in scope of lecture NDBI025 - Database Systems is supposed! The knowledge in scope of lecture NDBI026 - Database Applications is welcome!
Course completion requirements -
Last update: RNDr. Michal Kopecký, Ph.D. (12.10.2017)

This seminar is composed mostly of referats. The condition of obtaining the credit is

  • in one of seminar present aproximately 45-minute long referate on a given topic
  • before the end of the examination period, to submit one of the following:

a) a more detailed written report describing chosen feature of the database

b) a more detailed written report describing the process of putting into operation / configuration chosen database feature

c) a simple application, acquiring and appropriately representing some useful data from the database

Literature - Czech
Last update: Ing. Ladislav Kopecký (21.04.2005)

Manuály k databázovému systému

  • SQL Database Administrators Guide
  • SQL*Net for TCP/IP
  • SQL Database Installation Guide

Loney K., Theriault M.: Mistrovství v Oracle 9i; Oracle Press

Lacko L.: Oracle - správa, programování a použití databázového systému; Computer Press

Syllabus -
Last update: Ing. Ladislav Kopecký (17.04.2005)

Oracle Administration

  • Logical and physical organisation of the database.
  • Processes and memory structures.
  • Data security under OS UNIX.
  • Client/server architecture. Net protocol confuguration.
  • User management, permissions.
  • Data backup and restore. Error recovery.
  • Server optimisation.

Data access using programs written in C/C++

  • Embedded SQL, Pro*C preprocessor.
  • Oracle Call Interface.

Charles University | Information system of Charles University |