SubjectsSubjects(version: 944)
Course, academic year 2023/2024
   Login via CAS
Oracle Administration - NDBI013
Title: Administrace Oracle
Guaranteed by: Department of Software Engineering (32-KSI)
Faculty: Faculty of Mathematics and Physics
Actual: from 2023
Semester: summer
E-Credits: 2
Hours per week, examination: summer s.:0/2, C [HT]
Capacity: unlimited
Min. number of students: unlimited
4EU+: no
Virtual mobility / capacity: no
State of the course: taught
Language: Czech, English
Teaching methods: full-time
Teaching methods: full-time
Additional information:
Note: the course is taught as cyclical
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. (30.04.2020)

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

  • either present referate on a given topic in one of seminar
  • or submit before the end of the examination period

more detailed written report describing chosen feature of 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 |