Online Tablespaces eLearning Training

Oracle9i Database Admin Manage Data Storage ...mport, identify the features and process of transportable tablespaces and the restrictions while using them. Audience The intended audience for this course include Database administrators, System administrators, Network administrators, and Technical support professionals. Additionally, learners should have taken the first three parts of this series 64311-64313. Suggested prerequisites  more...

Oracle9i Database Admin Create a Database ...atures of Oracle9i, such as Oracle Managed Files and Undo tablespaces, and the new features of the LogMiner utility. Learn To • Discuss the guidelines for creating an OFA structure and the information in the ORACLE_HOME subdirectories. • Identify the requirements and factors considered while creating a database, the guidelines for planning the physical database design, the  more...

Oracle8i Database Admin Create Databases ...entify control files Identify redo log files Identify tablespaces and data files. C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, Technical Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111),  more...

Oracle8 Performance Tuning Managing Memory and Disk I O ...ssues Duration: 1 Hour(s) Identify the recommended tablespaces and divisions of data for an Oracle database. Identify the advantages of partitioned tables. Select the two items needed to choose the correct stripe size. Perform the steps of a query to determine how many full table scans are taking place. Identify the reasons to set the DB_FILE_MULTIBLOCK_READ_COUNT parameter when  more...

Oracle8 Database Administration - Manage Storage Structures ... Identify the features of temporary segments in PERMANENT tablespaces. Identify the features of temporary segments in temporary tablespaces. Identify the guidelines for using temporary segments. Retrieve temporary segment statistics by using Oracle SQL Worksheet. Retrieve the information about temporary segment activity by using Oracle SQL Worksheet. Unit 4: Managing Indexes  more...

Oracle8 Database Administration - Create Databases ...fy the process of log switches and checkpoints. Manage tablespaces and data files. C ontent Emphasis Skills-Based A udience Database Administrators, system administrators, network administrators, and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112 and  more...

Oracle Database 10g Administration Workshop II Part 2 ... the tasks that enable you to recover temporary and index tablespaces. Sequence the steps to recreate a control file when the original file is lost or corrupted. Identify features of control file autobackups. Identify considerations for dropping redo log groups and members. Sequence the steps involved in noncritical file recovery. Identify commands that are used for server-managed and  more...

Oracle Database 10g New Features for Administrators Part 1 ...Oracle Database 10g. Identify features of transportable tablespaces (TTS). Identify functional architecture of Data Pump. Identify features of the Data Pump export and import utilities. Audience: The target course audience is Data Administrators, PL/SQL Developers, and Technical consultants who have experience with the Oracle9i Database. Deployment: Self-Study Language  more...

Oracle Database 10g New Features for Administrators Part 4 ...terprise Manager (EM). Identify conditions for renaming tablespaces in Oracle Database 10g. Audience: The target course audience is Data Administrators, PL/SQL Developers, and Technical consultants who have experience with the Oracle9i Database. Deployment: Self-Study Language Options: US English Total Learning Time: 6 hours Objectives: Unit 1: Backup and  more...

Oracle Database 10g Administration Workshop I Part 1 Learners will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Learners will be taught to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Learn To:  more...