Instructor Led Tablespaces Training
Tablespaces Training Provider? - Tell us about your Training!
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
From MeritForge Infotech
Oracle Administration
...--------------
ORACLE ARCHITECTURE
a Databases : Tablespaces and Data Files
a Database Structures: Schemas, Clusters, Hash Clusters, Segments, Extents, Blocks, etc.
a Instances :Internal Memory Structures: SGA, PGA
Process Structures: SMON, PMON, DBWR, LGWR, RECO, CKPT, ARCH, LCKn, Dnnn, Snnn
a Redo Log File Structure
a Control File Structure
a Start up
more...
Oracle Administration
...--------------
ORACLE ARCHITECTURE
a Databases : Tablespaces and Data Files
a Database Structures: Schemas, Clusters, Hash Clusters, Segments, Extents, Blocks, etc.
a Instances :Internal Memory Structures: SGA, PGA
Process Structures: SMON, PMON, DBWR, LGWR, RECO, CKPT, ARCH, LCKn, Dnnn, Snnn
a Redo Log File Structure
a Control File Structure
a Start up
more...
From Wintrac Inc.
Oracle9i Database Administration - DBA I
...und processes, the SGA and memory structures, data files, tablespaces, extents, blocks and rows. Common administration tasks are also considered such as security, backup & recovery, physical storage of indexes and tables and many others.
This course was formerly called a Oracle9i Database Architecture & Administration a DBA Ia .
You can get a complete list of other Oracle classes at
more...
Oracle9i Database Administration
...uch as security, creating users, creating object (tables, tablespaces) and backup and recovery. An in-depth discussion of database architecture is provided.
This course has been completely updated for Oracle9i. Working examples are included throughout the course book and students have access to electronic versions of all examples and lab solutions. Approximately 50% of class time is spent
more...
From L'Obel IT-Palaestra
L'Obel Certified Oracle DBA Training in Bangalore
...ontrol File
a Maintaining Redo Log Files
a Managing Tablespaces and Datafiles
a Describing Storage hierarchy
a Establishing the difference between System and Non-System tablespaces
a Storage Structures and Relationships
a Managing Undo Data
a Understanding the difference between automatic undo Management and Manual undo management
a Creating and Maintaining UNDO
more...
...ontrol File
a Maintaining Redo Log Files
a Managing Tablespaces and Datafiles
a Describing Storage hierarchy
a Establishing the difference between System and Non-System tablespaces
a Storage Structures and Relationships
a Managing Undo Data
a Understanding the difference between automatic undo Management and Manual undo management
a Creating and Maintaining UNDO
more...
L'Obel Certified Oracle Training in Bangalore
...ontrol File
a Maintaining Redo Log Files
a Managing Tablespaces and Datafiles
a Describing Storage hierarchy
a Establishing the difference between System and Non-System tablespaces
a Storage Structures and Relationships
a Managing Undo Data
a Understanding the difference between automatic undo Management and Manual undo management
a Creating and Maintaining UNDO
more...
...ontrol File
a Maintaining Redo Log Files
a Managing Tablespaces and Datafiles
a Describing Storage hierarchy
a Establishing the difference between System and Non-System tablespaces
a Storage Structures and Relationships
a Managing Undo Data
a Understanding the difference between automatic undo Management and Manual undo management
a Creating and Maintaining UNDO
more...
From Software Training Academy, Inc
Oracle 10g Administration
...d managing users, creating and managing database objects (tablespaces, tables, indexes, etc.), running utilities, configuring Oracle networking, and simple backup and recovery techniques. Provides an overview of the Oracle Data Dictionary and Oracle 10g architecture; Administrative Users; Instances; Initialization Parameter Files; creating and managing Users; Password management; Auditing;
more...
...d managing users, creating and managing database objects (tablespaces, tables, indexes, etc.), running utilities, configuring Oracle networking, and simple backup and recovery techniques. Provides an overview of the Oracle Data Dictionary and Oracle 10g architecture; Administrative Users; Instances; Initialization Parameter Files; creating and managing Users; Password management; Auditing;
more...
From Unirac Software Technologies
Oracle Database 10g Administrator Certified Associate 1Z0-042
...data is stored in blocks (4)
[ ] Define the purpose of tablespaces and data files
[ ] Explain space management in tablespaces
[ ] Create tablespaces
[ ] Manage tablespaces: alter, drop, take offline, put online, add data files, make read-only or read-write, generate DDL
[ ] Obtain tablespace information
[ ] Explain key features and benefits of ASM (5)
Administering User
more...
...data is stored in blocks (4)
[ ] Define the purpose of tablespaces and data files
[ ] Explain space management in tablespaces
[ ] Create tablespaces
[ ] Manage tablespaces: alter, drop, take offline, put online, add data files, make read-only or read-write, generate DDL
[ ] Obtain tablespace information
[ ] Explain key features and benefits of ASM (5)
Administering User
more...
Oracle Database 10g Database Administrator Oracle Certified Professional-1Z0-043
...overing from Non-Critical Losses
[ ] Recover temporary tablespaces
[ ] Recover a redo log group member
[ ] Recover index tablespaces
[ ] Recover read-only tablespaces
[ ] Recreate the password file
Monitoring and Managing Storage
[ ] Tune redo writing and archiving operations
[ ] Issue statements that can be suspended upon encountering space condition errors
[ ] Reduce
more...
...overing from Non-Critical Losses
[ ] Recover temporary tablespaces
[ ] Recover a redo log group member
[ ] Recover index tablespaces
[ ] Recover read-only tablespaces
[ ] Recreate the password file
Monitoring and Managing Storage
[ ] Tune redo writing and archiving operations
[ ] Issue statements that can be suspended upon encountering space condition errors
[ ] Reduce
more...
From Ora Training
Oracle DBA training
.... Storage Structure and Relationships
7. Managing Tables, Tablespaces and datafiles
8. Managing Users
9. Managing Database Security
10. Introduction to Oracle Auditing
11. Managing Privileges and Roles
12. Database Space Management
13. Hardware Configuration and Considerations
14. Introduction to Real Applications Clusters
15. Backup and recovery
16. Database cloning
17. Introduction to
more...
From Object Arena
ORACLE 10g11gDBA TrainingObjectArena Chennai
... database instance
- Manage Database Storage Structures: Tablespaces
- DML, DDL, DCL statements
- Triggers & Stored Procedures
- SQL loader Export / Import data
- Managing concurrency & locks
- Database maintenance & performance management
- Backup & recovery concepts & configuration
Realtime Project Guidance - Project work on Realtime scenarious, DBA Functions.
Services
a
more...
From Corporate Education Group
Oracle Database 10g Administration Workshop I
...the database
Storage Structures Define the purpose of tablespaces and data files Create tablespaces Manage tablespaces Obtain tablespace information Create and manage tablespaces using Oracle Managed Files (OMF)
Administering users Create and manage database user accounts Create and manage roles Grant and revoke privileges Control resource usage by users
Managing Schema
more...
...the database
Storage Structures Define the purpose of tablespaces and data files Create tablespaces Manage tablespaces Obtain tablespace information Create and manage tablespaces using Oracle Managed Files (OMF)
Administering users Create and manage database user accounts Create and manage roles Grant and revoke privileges Control resource usage by users
Managing Schema
more...
Oracle Database 10g Administration Workshop II
... General Architecture Creating an ASM instance Creating tablespaces that use ASM storage Viewing ASM information Migrating a tablespace to use ASM storage
Monitoring and Managing Memory
Oracle Memory Structures Automatic PGA Memory Management Using the Memory Advisor Using Automatic Shared Memory Management to avoid long running query issues
Managing Resources
Creating a
more...
... General Architecture Creating an ASM instance Creating tablespaces that use ASM storage Viewing ASM information Migrating a tablespace to use ASM storage
Monitoring and Managing Memory
Oracle Memory Structures Automatic PGA Memory Management Using the Memory Advisor Using Automatic Shared Memory Management to avoid long running query issues
Managing Resources
Creating a
more...
Oracle Database 10g: New Features for Administrators
...
Load and Unload Data
Cross-platform Transportable Tablespaces External Tables Unload DataPump Export and Import Utilities
Automatic Management
Automatic Checkpoint Tuning Automatic Database Diagnostic Monitor Automatic Shared Memory Tuning Automatic Optimizer Statistics Collection Automatic Undo Retention
Manageability Infrastructure
Advisory Framework Automatic
more...
...
Load and Unload Data
Cross-platform Transportable Tablespaces External Tables Unload DataPump Export and Import Utilities
Automatic Management
Automatic Checkpoint Tuning Automatic Database Diagnostic Monitor Automatic Shared Memory Tuning Automatic Optimizer Statistics Collection Automatic Undo Retention
Manageability Infrastructure
Advisory Framework Automatic
more...
