surfinggaq.blogg.se

Oracle database administration
Oracle database administration





It is important to plan how the logical storage structure of the database will affect system performance and various database management operations. The logical storage structure of the database Planning for backup and recovery of database informationĪs the database administrator, you must plan: Monitoring and optimizing the performance of the database Modifying the database structure, as necessary, from information given by application developersĮnrolling users and maintaining system securityĮnsuring compliance with Oracle license agreementsĬontrolling and monitoring user access to the database Installing and upgrading the Oracle Database server and application toolsĪllocating system storage and planning future storage requirements for the database systemĬreating primary database storage structures (tablespaces) after application developers have designed an applicationĬreating primary objects (tables, views, indexes) once application developers have designed an application Therefore, database administration is sometimes not a one-person job, but a job for a group of DBAs who share responsibility.Ī database administrator's responsibilities can include the following tasks: An Oracle Database system can be large and can have many users. Each database requires at least one database administrator (DBA).







Oracle database administration