This free video tutorial covers all the administration of Oracle 10G which will help all the database administrator and students for certification and career.An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance.Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. Enterprise grid computing creates large pools of industry-standard, modular storage and servers. With this architecture, each new system can be rapidly provisioned from the pool of components.The database has logical structures and physical structures. Because the physical and logical structures are separate, the physical storage of data can be managed without affecting the access to logical storage structures.

The Oracle grid architecture pools large numbers of servers, storage, and networks into a flexible, on-demand computing resource for enterprise computing needs. The grid computing infrastructure continually analyzes demand for resources and adjusts supply accordingly.Clustering is one technology used to create a grid infrastructure.Grids, which can consist of multiple clusters, are dynamic resource pools shareable among many different applications and users.Applications can be scheduled and migrated across servers in the grid. Grids share resources from and among independent system owners.

A database administrator's responsibilities can include the following tasks:-

  • Installing and upgrading the Oracle Database server and application tools
  • Allocating system storage and planning future storage requirements for the database system
  • Creating primary database storage structures (tablespaces) after application developers have designed an application
  • Creating primary objects (tables, views, indexes) once application developers have designed an application
  • Modifying the database structure, as necessary, from information given by application developers
  • Enrolling users and maintaining system security
  • Ensuring compliance with Oracle license agreements
  • Controlling and monitoring user access to the database
  • Monitoring and optimizing the performance of the database
  • Planning for backup and recovery of database information
  • Maintaining archived data on tape
  • Backing up and restoring the database
  • Contacting Oracle for technical support
Note:-
Download all 2 parts in same folder and extract part 1 in new folder to join both split parts.


Rar Part 1

Rar Part 2




Non Camera SmartPhones

free counters