Oracle JOB Guaranteed Real time training & projects @Globals Technologies

Published 10-07-12


Location: Home Location
jayanagar 4th block


Pls bring this page printout in order to avail discount from Rs.500 to -5000/-

Oracle 10g DBA offers many new tools that help DBAs work more efficiently (and perhaps more
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
Trainingfrom INSPIRE GEC.

Defining an Oracle Server, Database, 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, readonly, readwrite, Temporary
tablespace groups, multiple blocks

Creating and Managing a Tablespace when using OMF and the advantages of OMF

Extent management- Dictionary Managed and Locally Managed Tablespaces
(AUTOALLOCATE, UNIFORM) and advantages of locally managed over dictionary managed

Big File Tablespace, Temporary Tablespace Group.
Storage Management

Creating, Maintaining tables using appropriate storage settings - initial, minextents, pctfree,

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 nformation
User Management
Creating user's, 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
Globals Technologies
(Karnataka service excellency award winner for year 2011)
#363, 1st floor, Nxt to Bennison Super Mkt,
16th Main Road, Jayanagar 4th T Block, Bangalore 560003
Cell: +91-9343030003, 9343212122


Help & Support

Please write to us if you need any further information.