Oracle Courses from Globals Technologies, Bangalore - Bangalore

Oracle 10g DBA offers many new tools that help DBAs work more efficiently (and
perhaps more enjoyably), freeing them for more strategic, creative endeavors—not
to mention their nights and weekends.

Oracle 10g DBA Course Details:

• Oracle DBA Training & with live Project.

• Each and Every Student will get full support during the projects.

• Eligible by any Graduates / post graduates

• Covers the entire 6 different Modules of Oracle DBA Training.

• On successful completion of the course, all students get a ‘Certificate in

Oracle DBA Training from INSPIRE GEC.

Architecture:
• Defining an Oracle Server, Database, and Instance.
• Physical Structure, Memory Structure, Process Structure, Logical Structure,
Execution of SQL Statements, User Session

Creating a New Database:
Identifying the application and the no. of applications the DB will support. Adv.
of having each application on each DB. Adv. of having common DB. For all
Applications. UnderstandingTS, Changing Initialization parameters- SGAsize,
Processes, TS Naming Conventions, Block Sizes, Type of DB, No. of users the DB
has to support, etc, Dropping a Database, ASM Database, sysaux, Tablespace,
Default Tablespace.

Managing an Oracle Database:
• Creating and Managing Initialization files - PFILE and SPFILE, Adv. of SPFILE
over PFILE
• Identifying the various states/options of Instance Startup/Shutdown, DB Mount/
Open stages
• Monitoring Alert and Trace Files in udump, bdump and cdump for DB
Troubleshooting
• Configuring System Global Area (SGA) - DB Buffer Cache, Log Buffer and
Shared Pool

• Understanding Background Processes - Mandatory/Optional and the jobs
performed by them using the Data Dictionary to retrieve information about the
database - V$, DBA_views
Managing Tablespaces and Datafiles
• Creating and Altering Tablespaces, adding, resizing, renaming and relocating a
Datafile, Renaming Tablespace.Tablespace - offline, online, read-only, read-write,
Temporary tablespace groups, multiple blocks
• Creating and Managing a Tablespace when using OMF and the advantages of
OMF
feature
• Extent management- Dictionary Managed and Locally Managed Tablespaces
AUTOALLOCATE, UNIFORM) and advantages of locally managed over
dictionary managed tablespaces
• Big File Tablespace, Temporary Tablespace Group.

Storage Management:
• Creating, Maintaining tables using appropriate storage settings - initial, mine
tents, pctfree, etc
• Obtaining table information like avg. row length, chained rows, etc after analyzing
the tables
• Managing. Listing diff. types of Indexes and their uses. Creating B-Tree and
Bitmap Indexes, Maintaining Indexes, Identifying unused Indexes, Obtaining Index
information

User Management:
Creating users, Managing resources with profiles, User Authentication, Managing
user privileges and roles.

Managing Export's & Import's
Main Tasks of Exports and Imports Incremental, Cumulative and Complete Export
and Import Points to remember before doing export and import

Oracle Data Pump:
• Introduction, Benefits of Data Pump Export and Import
• Data Pump Export and Import modes

Also we train on Oracle 10g SQL, Oracle 10g PL-SQL, Oracle 10g Forms and
Oracle 10g Reports

For further details contact:
Globals Technologies
363, 1st Floor (IClub India
Next to Bennison Super Market,
16th Main, 4th T Block, Jayanagar (Near BES College
Bangalore-41 www.globalstechnologies.com
Email – training.globals@gmail.com

Phone - 080-41554144 /9343212122