Oracle database tutorials,examles,scripts and codes

Admin Fri Jan 04, 2008 6:51 am

Lesson 1. Introduction to the Oracle Data Dictionary This tutorial provides an Introduction to the Oracle Data Dictionary from the perspective of the DBA. Diagrams, examples and queries against the Oracle Data Dictionary views support the descriptive text.
Lesson 2. Oracle9i Architecture: Files An introduction to Oracle Architecture with an in-depth look at the operating system files that make up the database.
Lesson 3. Oracle9i Architecture: Processes An overview of Oracle Background Processes.
Lesson 4. Oracle9i Architecture: Memory An in-depth lesson on the memory areas used by the Oracle Database such as the SGA and PGA.
Lesson 5. Creating Oracle Administrative Users A practical and hands-on lesson on creating and using Oracle administrative users.
Lesson 6. Starting and Stopping an Oracle Instance An in-depth, hands-on lesson on using the Oracle STARTUP and SHUTDOWN commands to start and stopn an Oracle database.
Lesson 7. Oracle Initialization Parameter files Learning how to start an Oracle database with non-default parameter files, change parameter values and work with 9i SPFILES.
Lesson 8. Creating and Managing Oracle Users Administrative processes needed to create and manage all users of the Oracle database.
Lesson 9. Oracle Password Management A hands-on lesson on Oracle password aging, locking and complexity routines.
Lesson 10. Introduction to Oracle Database Auditing A hands-on tutorial on recording user activity in the Oracle Database.
Lesson 11. Managing Oracle Security A discussion of Security related tasks for the Oracle DBA
Lesson 12. Managing Oracle Tablespaces Creating and managing locally managed tablespaces, including a discussion of Automatic Segment Storage Management (ASSM) and Oracle Managed Files (OMF).
click here to begin!